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
BrogrimInformation Systems Development ManagerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

TONY TAYLORCommented:
Look at the "References".  Were there any connected to the old PC that are not on the new?
BrogrimInformation Systems Development ManagerAuthor Commented:
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 TAYLORCommented:
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
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Get Your eBook
BrogrimInformation Systems Development ManagerAuthor Commented:
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 TAYLORCommented:
Close out of the database, open while holding the "shift" key.  You should be able to remove it at that time.
BrogrimInformation Systems Development ManagerAuthor Commented:
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.
TONY TAYLORCommented:
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.
BrogrimInformation Systems Development ManagerAuthor Commented:
It wont allow me to do that even opening with the shift key held down
TONY TAYLORCommented:
See comment 40832786
BrogrimInformation Systems Development ManagerAuthor Commented:
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 TAYLORCommented:
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 CoachmanMIS LiasonCommented:
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.
BrogrimInformation Systems Development ManagerAuthor Commented:
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.
BrogrimInformation Systems Development ManagerAuthor Commented:
Jeffrey, It is an Access 10 accdb file with Mysql BackEnd.

I copied the working file and relinked the tables
Jeffrey CoachmanMIS LiasonCommented:
ok
BrogrimInformation Systems Development ManagerAuthor Commented:
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.
TONY TAYLORCommented:
I don't want to be a pest about this, but this question was originally closed and re-opened twice within 30 days of the original ask.  With all due respect, I am not sure that the length since the original ask is a factor here.

As you can see by the comment on the first re-open, @the_wolfe stated, "It does look like the first comment from TONY TAYLOR eluded to your issue."

The original ask was concerning a "File Not Found" issue.  This issue was resolved as you can see evidenced by the authors comment on ID #40832744 and supported by author comment ID #40832976.

EE thrives on supplying solutions to questions.  In our tutorial on how to ask a question, we lead off with, "If you are not able to find your solution through answer search..."

I find value in having a solution entered in this case.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
BrogrimInformation Systems Development ManagerAuthor Commented:
Please excuse my ignorance
TONY TAYLORCommented:
No worries.  I don't take (nor meant) any offense.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.