Replicate Access Table In Another Access DB

[kiwieur]

Hi Team,

We are developing an Intranet and one of the tasks is to use data from a production system however, we do not want to keep querying the live system and putting extra stress on it as we have approx. 60 users who are working on it at some time during the day.

Therefore our idea was to run Make Table queries every 30 mins and copy this table to another access DB and then use these static tables for the intranet pages.

We intend to do this by running an access macro from a scheduled task.

Could someone explain if there is a better way to do this as we would believe we will have problems if someone is accessing the static tables when we are trying to copy the updated table across.

All information will be greatly recieved as we would like to attempt to get this right first time.



Regards

Paul

 

[dhookom]

I would probably use SQL Server rather than Access tables if possible. Any amount of users would not be an issue. If you can setup SQL Server for only the intranet, you could use a SQL Server Integration Services package to update SQL Server tables.

Duane
Hook'D on Access
MS Access MVP

 

[BNPMike]

Access has built-in replication. Look at "About choosing a tool for replication" in Access help.