Problem with access accdb file format

Posted on 2013-01-18
Last Modified: 2013-01-23
I have a vb development machine that has access 2010 install on it.  I  have a project that uses the access database and the database has a accdb extension.   I compiled my program and copied the access db over to a pad, and install my program everything is good.  Then I go to get his data back to my development to test a few things with current data, and it will to copy.  Is that what they mean by accdb will not replicate.  I have a window8 machine that is also used for development and when I run the program on that machine the database comes back and says its a invalid format.   Can I get the data from accdb and move it to a mdb.

Question by:mgmhicks
LVL 30

Expert Comment

ID: 38794759
Not sure if I understood the requirement.

To save accdb to mdb format.

File - Save & Publish - Save Database As - Select required option
LVL 84
ID: 38796316
Then I go to get his data back to my development to test a few things with current data, and it will to copy.  Is that what they mean by accdb will not replicate.
What do you mean by that?

If you want to test with user data, you should make every effort to emulate their environment as closely as possible. If they're running Win7, you should be running Win7, not Win8, for example.

You should be able to copy the .accdb file directly from the user machine to yours, however. There should be no format changes, or anything of that nature. It should work exactly as it did in your development phase.

when I run the program on that machine the database comes back and says its a invalid format
This is generally caused by trying to run an .accdb file on a machine that does not have the proper providers installed, for example. You must ensure the target machine has the correct libraries to run your program.

Note, however, that
LVL 40

Accepted Solution

Jacques Bourgeois (James Burger) earned 500 total points
ID: 38796884
Replication is a process that enables to have a master database on the network and many replicas (copies) of the database installed on individual machines. The replicas being installed locally, they can be used even when the user is not connected to the master. The performance is also increased when the user works from a replica, because he is alone in his copy of the database and do not have to query the network everytime he needs to read or change data.

From time to time, the replica is synchronized with the master, which means that the changes made locally are sent to the master, and the changes made by other users are retrieved to become available in the replicat.

Access databases where tuned down when the format moved from .mdb to .accdb, and the replication mechanism was dropped. You cannot use it in .accdb files. This is what they mean by "accdb will not replicate".

You will often get the "invalid format" error because you are trying to read a .accdb file with Access 2003. You need a newer version of Access to access files in that format.

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

815 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now