I have a complex Access 2002 database with multimple tables, queries, forms, and reports. The database is used by miltiple users that have one of four different levels of security. The databae uses a workgroup security file. The database is designed to be opened without the workgroup security file by general users (who have the lowest permission levels).
I've been working on the database recently to make some "minor" modifactions. Unfortunately, one of my modifications has had a undesired result. Now when one of the forms is opened by a general user, a dialog box opens to say "Record(s) cannot be read; no read permission on <tablename>". Unfortunately, Access doesn't give me a button on the dialog box to "Debug" and find the offending line of code. I'm only given "OK" and "Help" buttons. Clicking "OK" dismisses the dialog, but the form doesn't open. Clicking "Help" tells me its a 3112 error.
I must have a bad SQL statement somewhere in the project that's trying to open a protected table that the average user doesn't have permissions to.
I've tried searching all the code in my database/project for the table name mentioned in the dialog, but I don't see anyting wrong with the code (i.e. nothing that I've recently modified). I tried setting a break point at the first line of code in the form_open event to step through each line of code to trap the error, but the error trips even before the first line of code is executed.
I would appreciate ANY help in trying to find out what Access is doing when the error occures. What does Access do before the form_open event?
Thanks in advance,
Scott