Access "function is not available"

FormalSmirk

Anybody know anything about access databases?

I've just moved a database that was designed for us a while ago to another PC.
Upon opening it I get "function is not available in expressions in query expression".

I've looked around the web and can't seem to find a clear way to resolve this.
Lots of people say its a library or reference issue however the tools references is grayed out when I go into VB.

TIA

DavidP24

Access has VB code

VB code these days is disabled by default

So set your system to allow VB and try again

Not sure if the DB has used functions that have been removed , if so you will need to install old version.

System

Me as someone who doesn't understand, out of curiosity why use databases or VB?

Neil_Jones

Normally this (message in the OP) means you're trying to do something on the second machine that isn't available but it is available on the first machine. It's usually either an add-in or a different version of an add-in between the two computers that causes the issue. How you rectify it is difficult though without seeing how it's currently done.

Me as someone who doesn't understand, out of curiosity why use databases or VB?

Databases on a basic level can be used as record storage or virtual filing cabinets if you like. But they're much more powerful than that, you can use them for pretty much any job you like. Access is a very powerful program in the right hands but it takes a hell of a lot of time to learn how to use properly.

as for VB or Visual Basic in Office, it basically lets you write code to extend the functionality of the Office program in question or do repetitive things. The proper name for this is a Macro.

FormalSmirk

I've installed Office 2010 on the new PC as I find it easier to use.

This database is a MDE file renamed MDB and I think that is why the resources option is disabled.
Should I be able to see somewhere on the old PC what resources are installed, then install these on the new PC?

FormalSmirk

Thanks David,

What sort of thing would I be looking for?
I cant remember anything being installed when it was setup.