Software

Ask something
Discussion Locked

Prevent design change to Access database

0 helpful
3 replies

by linkbutler

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
In the past, I have downloaded sample databases that allowed user interaction and data entry, but did not allow the user to modify or view the Db design. The only files downloaded were the .mdb databases, themselves. I need to distribute a simular Access 2000 dbase ( only the .mdb file ) between different locations, that can be run on any pc with Access 2000. I need to be able to modify-update everyones Db as needed,( from any pc, any location )via e-mailing the Db, but they can only enter and store the data. One .mdb file, that only I can view the Db design, or modify the Db design, on any pc.

3 replies

by linkbutler

This will prevent design changes by everyone, myself included. I was looking for a way to shut out the curious (for obvious trouble-shooting reasons), but still be able to modify the .mdb myself. I could carry a copy of the db and modify as needed, importing their specific data. Considering I cover 16 cities, maintaining over 800 computers, I obviously do not have a lot of time available for trouble-shooting more problems than they already create, which is why I was hoping to be able to do this without setting up (and trouble-shooting)permissions on each machine. Thanks for the answer.

This discussion is closed to new replies.