Copying data from one Access Database to other

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Access database which is used by an application and is continously
storing data. The application which is storing data is running on different
machines and storing in different access databses. Is it possible to transfer
the data from these individual PC into a seperate database which the
application is using it? If yes, can anyone help me with this??

Is there a solution for this?

Regards,
Ritesh
 
Ritesh

Are you certain you want to have two copies of the same data? Another
option would be to link to the Access .mdb file that hold the data. This is
a common design recommendation, splitting an application into a back-end
(holding data only), and one copy of the front-end (forms, queries, reports,
code) on each PC, linked to the back-end.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying data from Access database while it is being used 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Copy data from one databse tabel to other database table 1
What are the steps to fix damaged MDF files in SQL Server? 0
Copy and move Access 13 database on laptop to pc with Access 13 0
Migrate mailboxes from one Microsoft Exchange Server to another Exchange 1
VBA - retrieve data on last create named range from previous inserted named range 0
>> building a sql database from another sql database 2

Back
Top