Front End - Back End DB

[UncleHuckleberry]

Hello,

I have a question about syncronising front ends on an access database split. I would like to implement a structure which has a back end database storing the data tables and several front ends which allow the users the ability to add additional queries and reports.

I have seen several techniques for updating front ends from the server side to issue a common front end, but I haven't seen anything for looking for changes and backing up front ends from the client side. My fear is a front end on a clients machine may be deleted / corrupted / hard drive failure and any queries or reports they had added would be lost. Is there a way to keep automatically backup users fronts ends to the server?

"When the going gets wierd, the wierd turn pro" - R. Duke

 

[fredk]

I put the frontends on the network server also - Perhaps someone will respond that this is not the best arrangement but I tested putting the front end on the users computer and found that there was no drop off by moving the users front-end to the network drive.

The main reason for doing this was to be able to update the users front-ends.

Fred

 

[GingerR]

I'd just put them on servers and check with server admins on backup procedures. Surely they back up regularly. At the worst a user would lose a day's work.