Question about synchronization and record locking

R

Rocky Neurock

I have the need to backup an access database hourly for my company and
in the interest of time I made a small application to copy the
database, append the hour to the filename and store it on a different
server. This backwards method locks the database every hour for about
a minute while it copies over. We can live with that but I'd rather
not.

I'd rather use replication, since we have four offices that use the
database anyway, so I would like to know if hourly synchronization
would cause the same type of locking. Has anyone used replication?
Can you tell me if synchronization causes any sort of locking issues?
Our offices only access data that pertains to that office and each user
only accesses data that pertains to them, so there should never be any
record locking conflicts.

The other alternative I thought of was to use a data reader to copy the
tables every hour so the database didn't get locked up. This method
would be speedy but it prevents me from copying queries, which is a
must. Any ideas here would be helpful too.

Thanks in advance.
 

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

Top