Copying data of tables to another database

[Sniper-BoOyA-]

Good afternoon,

Ive made some databases in the past few weeks, and every now and then there has been an update in either the VBA code or in the query format.

Which means i'd have to manually copy the data from the former Database to the new and improved database. Which works, but takes a lot of time.

Is it possible to create some sort of macro which copies the content of the tables from one database and pastes it into a new one ?

Currently, the company i work for uses a program called 'F-suite', which basically copies a standard and empty database to a specified location. Which will be used by the employees / people at the lab to enter data.

The problem now is, once there is an update to the database, all existing databases have to be updated aswell.

So it would be very helpful to have some sort of macro which copies and pastes the tables to a new database.

Ive been looking around on google, but all i see is information about mysql en sql servers. Nothing about Access.

Any suggestions?

Cheers!

 

[HiTechCoach]

Sounds like you need to split your database.

See: Splitting your Access database into application and data

 

[Sniper-BoOyA-]

Ill have a look... Thanks m8!