Hi Abu

Thanks for the reply, adding timestamps and the such to the tables will not be an issue, and it is only one way synch, Access to SQL as its only a logging system so the clients will not need any info from the main DB.

As I say I am only new to SQL so just looking into your SQL scheduled job. My only concern is that I will have to create a linked server to each Access database then have the job pull the information.

I have a few concerns on this though, if I have 20 databases and the job has to pull data from all these databases each minute, I think the overhead on the SQL server may be to much and effect the main application running on the server.

What happens if a data pull from a database takes longer than 1 minute.

What happens if the SQL job cant see a database.

I would like to try and stay with the access databases on the local systems if possible.

Cheers

Dj