Database Problem please help

Are you saying that the problem is that the Access database is always open and therefore cannot be accessed to get a backup? That problem is usually peculiar to the system; each system needs to establish a way to do a backup.

Perhaps you could write a macro that exports the data. Can an export be done with the database open? Then if a problem causes the database to be lost, you could import the data into a new database.

Something else you could do is to write your system so that it archives updates (including adds of new data) at the time they occur, so that you have a copy of all data. There is certainly other software, including samples and articles, that you can use for doing that, but I don't know what they are.

Access was not designed to be used for multiple-user use. It is used in web sites for multiple users, but Access is not designed for it. Other database software, such as Microfoft SQL Server, is designed for this, but I know it also costs more. If you can afford something else, then don't use Access.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sam Hobbs17y ago
Are you saying that the problem is that the Access database is always open and therefore cannot be accessed to get a backup? That problem is usually peculiar to the system; each system needs to establish a way to do a backup.

Perhaps you could write a macro that exports the data. Can an export be done with the database open? Then if a problem causes the database to be lost, you could import the data into a new database.

Something else you could do is to write your system so that it archives updates (including adds of new data) at the time they occur, so that you have a copy of all data. There is certainly other software, including samples and articles, that you can use for doing that, but I don't know what they are.

Access was not designed to be used for multiple-user use. It is used in web sites for multiple users, but Access is not designed for it. Other database software, such as Microfoft SQL Server, is designed for this, but I know it also costs more. If you can afford something else, then don't use Access.