Solved

Problem with access accdb file format

Posted on 2013-01-18
3
906 Views
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.

thanks
0
Comment
Question by:mgmhicks
3 Comments
 
LVL 30

Expert Comment

by:hnasr
ID: 38794759
Not sure if I understood the requirement.

To save accdb to mdb format.

File - Save & Publish - Save Database As - Select required option
0
 
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
0
 
LVL 40

Accepted Solution

by:
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.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
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…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

914 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

16 Experts available now in Live!

Get 1:1 Help Now