Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Determine if user is linking to or directly opening data table

Status
Not open for further replies.

xwordmark

Programmer
Aug 19, 2009
11
ID
I have several Access 2007/2010 databases operating (front end stored locally on user's PC, back end data files stored on network). My question is this: Is there a way to determine if the user is linking to the data files by opening the front end (properly) or if he/she is going on the network and opening the data file directly (improperly)?
 
Not sure how to do that, but I usually lock the back end.
Enforce no shift bypass
Have a pop up form and hide everything else.
Pop up form says not to access directly and use their front end
Close db when closing pop up.
 
One thought would be to set an added column in the front end to a diffent default value and specify a different table level default in the backend. Obviously someone could write the same data manually but this may catch some.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top