473,320 Members | 2,158 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Export database to different Access instance

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
3 1007
PhilOfWalton
1,430 Expert 1GB
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).

Phil
Sep 19 '18 #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.

Mark.
Sep 20 '18 #3
NeoPa
32,556 Expert Mod 16PB
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

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

Similar topics

7
by: Spencer | last post by:
Is it possible with a SQL query against a system table to determine what the database name or instance name is that you are logged into? We are on DB2 8.1.6. Spencer
5
by: sql-db2-dba | last post by:
We have DB2 UDB v8.1 fixpak3 on AIX 5. Production and Development configuarations (at least for DB2) are identical albeit production is a 2-way server while development has only one processor....
0
by: Tom | last post by:
Since updating our database to Access 2003, I have not been able to export / import reports queries or anything between different machines. We use an access "Front End" and a SQL back end. I...
1
by: bburton | last post by:
I'm using a form in Access which was used as a bug tracker. The users could update the record with an attachment. (The data type of the field that is used for attachments is the OLE Object) I...
0
by: moshe_n | last post by:
Hello I try to export report from access 2000 by mail and always i get the massege " the report can not open the mail application" I use the Lotus notes application , noach,
1
by: kenshiro2000 | last post by:
I want to export DDL of an existing Database Microsoft Access 2002. I could write a routine that navigate into the TableDef of the DB. Exist something snippet code that do this? thanks
1
by: contact.amarender | last post by:
Hi, I want to export database from MYSQL to Ms Access. Can anybody suggest me a way to do that. thank you, amar
5
by: hugobotha | last post by:
Hi all, Help will be much apreciated here. How can I query two different access databases that has same table and fields. This is how i access the one database but I want to be able to do it...
2
by: dandalero | last post by:
Hi, I'm joining tables from 2 different databases instance located on different SQL Server, I tried server.database.owner.table but I got the following error: "Could not find server...
1
by: DKF9 | last post by:
Hi. I need some help in transferring data from a Lotus Approach database into Access. I have a field in Approach that is like a memo field in Access. There are many lines of data for each row....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.