By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,945 Members | 1,650 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,945 IT Pros & Developers. It's quick & easy.

Export database to different Access instance

P: 2
I have a split database. Back-end is Test.mdb and the Front-end is Test.ldb. I made a copy from one system and saved it to another system running a different instance of Access. When I try to run a specific query I get an error saying the 'format' function is not recognized. The new instance is Access 2016 version. Any suggestions for fixing this?
Sep 19 '18 #1
Share this Question
Share on Google+
3 Replies

Expert 100+
P: 1,430
Firstly your Test.Ldb is not the front end. It is a lock file (size is only 1KB) and it is created when a Db is opened, and usually gets deleted when the Db is closed. In your case, with both Front End & Back End, 2 lock files will be created.

There is a lot of advice on google about converting Mdbs. You may be lucky in being able to open the Dbs wth Access 2916 then saving them in 2016 format. If not, you may have to open the file with Access 2010, then do the conversion.

After converting, compile your VBA and see if there are errors. Check the VBA references for the word "MISSING".

I think there should be a reference to C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL).

Sep 19 '18 #2

P: 2
Thanks for the response Phil. As you may have guessed I am a relative newbie in Access. Thanks for pointing out the lock file for me. I will check out the information on converting the database. Thanks again.

Sep 20 '18 #3

Expert Mod 15k+
P: 31,492
ACCDB & MDB formats are not the same. This may sound obvious but sometimes it just isn't.

If you copy an MDB file as an ACCDB then it's still an MDB - just with an ACCDB extension. If you want to convert to a later version then you need to use the new version to run a conversion.

As Phil says - LDB & LACCDB are extensions for the lock files. Do not confuse these with Access databases. They eally aren't those.
Sep 21 '18 #4

Post your reply

Sign in to post your reply or Sign up for a free account.