A quick commentary on Access

[The Vicer]

Hi All


I read recently that there is a command in Windows (Shadow Volume) that allows you to back up an open file. If that is the case could it be used With Access to back up the data files for a multi-user application on a regular basis. If that is the case then would this negate the use of going to SQL Server when smaller data files (2G limit for Access) are concerned. If a backup every 15 minutes was scheduled could that be a viable work around for small business operators. I know some data may get lost if a crash does occur but it may be an acceptable trade off for some business types. Just throwing it out there for your comments.

The Vicer

[thhui]

As far as I know, there are many limitations of using shadow copy (eg. only server version can do this, a whole volume backup, etc).

Therefore, you must take note on this if you want to use it as a backup option.

Really, mssql server has a lot of advantages over using access (including backup). However, access is mostly suitable for a low scale application and far more easy to design and implement.

[NTC]

a regular copy/paste of a BE file does not disturb the users. there isn't any reason to work with the shadow file.