Avatar of Brogrim
Brogrim
Flag for Ireland asked on

MS Access _ File Not Found

I have transferred a database (accdb) from one PC to another and I keep getting the message "File Not Found".

The ODBC is connection Fine but when I try to compile I get the message "File Not Found".

Any Ideas
Microsoft Access

Avatar of undefined
Last Comment
TONY TAYLOR

8/22/2022 - Mon
TONY TAYLOR

Look at the "References".  Were there any connected to the old PC that are not on the new?
Brogrim

ASKER
No they are both identical in the list.

I reinstalled the "ms activex data objects 2.8 library" to see would that help but nothing
TONY TAYLOR

Have you tried to decompile?

Something like this from the "run box":

"C:\Program Files\Microsoft Office\Office\MSACESS.EXE" "C:\users\you\documents\YourDatabase.mdb" /decompile
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Brogrim

ASKER
On checking this again on the PC that is working there is a reference for "Microsoft Access 15.0 Object Library", the new one is 15.0,

I have tried to update it but I am getting a message:

"Cant remove control or reference: in use"
TONY TAYLOR

Close out of the database, open while holding the "shift" key.  You should be able to remove it at that time.
Brogrim

ASKER
I have tried the decompile but it looks like I have wiped all the code, modules wont open and the code behind all command buttons is missing.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
TONY TAYLOR

I am going to assume that the database got corrupted in the copy.  Try to copy a new version of the file.  Corruption is a big thing with Access databases.
Brogrim

ASKER
It wont allow me to do that even opening with the shift key held down
TONY TAYLOR

See comment 40832786
Your help has saved me hundreds of hours of internet surfing.
fblack61
Brogrim

ASKER
I have just realise that the the MS Access Version where it is working OK is 32 Bit.

The PC I am moving to has a  64 Bit MS Access version.

Is that what is causing me all the problems?
TONY TAYLOR

It very well could be.  Without having access to your environment and your files, it is very difficult to tell.  If you are using different references (even if they are named the same, you might have difficulty).

Is it possible to create a new Access database on the new computer and copy all of the Access Objects in to the new database?
Jeffrey Coachman

I have transferred a database (accdb) from one PC to another and I keep getting the message "File Not Found".
Lets be clear, ...Is this a split database?

In a split database you don't really "transfer/move" a database.

Each user has a copy of the font end db file on their computer.
The single Back end db file, is typically stored on a shared drive/folder on a server.

Please clarity your setup.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Brogrim

ASKER
I have tried that I think it is the "Microsoft Access 15.0 Object Library" reference that is missing on the new PC that is making the difference.
Brogrim

ASKER
Jeffrey, It is an Access 10 accdb file with Mysql BackEnd.

I copied the working file and relinked the tables
Jeffrey Coachman

ok
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Brogrim

ASKER
I've requested that this question be deleted for the following reason:

I have got completely confused with the questions and as you will see it was months ago and no longer an issue. Apologies for the delay in replying.
ASKER CERTIFIED SOLUTION
TONY TAYLOR

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Brogrim

ASKER
Please excuse my ignorance
TONY TAYLOR

No worries.  I don't take (nor meant) any offense.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.