How to synchronize two ms access files? I am using one Ms access file (access 2

How to synchronize two ms access files?
I am using one Ms access file (access 2007 accdb file) in my
system. the same file i have given it to another section for
data entry. every day data entry is being done in that
section and i am making reports in my access file. how do i
synchronize both file because i need to update data entries
from that system and update my new reports to that system.
Plz help me how to do that? Network is not available between
these systems and things can be done via storage devices only.

Question Posted / suresh

1 Answers
1972 Views
I also Faced
E-Mail Answers

How to synchronize two ms access files? I am using one Ms access file (access 2007 accdb file) in m..

Answer / Mritunjay Kumar

One approach to synchronizing Access databases without a network connection is by using the Access Compact Database (MDA) format. Here's an outline of the steps:nn1. Create a backup of both databases in MDB format.n2. Export the data from the first database (the main one) to an MDA file, using the following SQL query: `SELECT * INTO TABLE [TableName] FROM [TableName];`n3. Transfer the MDA file to the second database location.n4. Import the data from the MDA file into the second database's main table, using the following VBA script:n```vbanPublic Sub ImportMDA()n Dim db As DAO.Databasen Dim rs As DAO.Recordsetn Set db = OpenDatabase("pathtomdafile.mdb")n Set rs = db.OpenRecordset("TableName", dbOpenDynaset)nn ' Loop through all records in the MDA file and import them into the main tablen Do Until rs.EOFn rs.MoveNextnLoopnn db.Closen Set rs = Nothingn Set db = NothingnEnd Subn```

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Microsoft Related AllOther Interview Questions

What is UNIX?

1 Answers Accenture, Reliance,

how Wsus work ? and how the clients are updated automatically?

2 Answers HP,

What is USB (Universal Serial Bus) ?

1 Answers

Shortcut keys for debugging in visual studio?