Access to Back End Tables in MS Access
Posted on 2011-09-30
I have looked around but seem to be lost in other questions...
I have a database that contains confidential client information. It is an Access 2003 database.
I'm wondering if there is any way to restrict access to the back end in case people gain access rights to view the folder containing the back end and look at the data in there, or even worse, modifying it. The database is also going to be upgraded to 2010. There is no user-level security on it at this point. Any use in upgrading the back end to SQL?...I don't know how to do this, but I thought about it as an option. Ideally it would be inaccessible to someone using Crystal Reports or something like that also, but first I just want to keep people from opening it using Access.
Any ideas out there? Thanks Experts!