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.
- 1 Answers
- 1974 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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:n
1. Create a backup of both databases in MDB format.
2. 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];`
3. Transfer the MDA file to the second database location.
4. 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 View All Answers
