Question Backup in .accde

[mcdhappy80]

What would be the best way to make backup of data in .accde database?
Can this be done properly without first splitting the database?
I prefer not to complicate things because only one user at the time will work with the database.
Can tables (with data) be exported from .accde database?

Thank You.

 

[Galaxiom]

It is always a good idea to split a database even with a single user. Separation of data and program is always best practice. Splitting does not complicate anything but results in two simplified files instead of one complex file.

It also means smaller backups. The front end accde does not change. You would only be backing up the data. However you will need the original accdb to relink the tables to the front end.

Yes the tables can be exported.

 

[HiTechCoach]

IMHO, splitting a database into a Front end and Back end actually simplifies things and adds another level of protection for the data.

For anyone reading this thread, I would recommend reading the original post for here:

http://access-programmers.co.uk/forums/showthread.php?t=177082