I agree with june, I'd pay to see the setup, because I know the solution has to be simple.
VIP
Windows XP 
Access 2003
I agree with june, I'd pay to see the setup, because I know the solution has to be simple.
Competent Performer
Windows 7 64bit Access 2010 64bit
I already knew it was a problem with my backend (see first post). My user is opening in exclusive mode presumably because he doesn't have write access on the shared drive holding the backend (according to my reference book). Except HE DOES HAVE WRITE ACCESS ON THE SHARED DRIVE!!!
Only one user has this problem so I don't think the back end is corrupted. When he is using the database, no one else can reach back end (either by opening the back end file or viewing records via the front end).
VIP
Windows 7 64bit Access 2010 32bit
Very odd!
Maybe get IT to delete that user profile and recreate?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
VIP
Windows XP Access 2003
Right click on the database itself (back end), click PROPERTIES go to the SECURITY tab.
Look for your problem user in the list of users.
Compare him to the other users if everything is the same click on the ADVANCED tab
click on EFFECTIVE PERMISSIONS tab check those against the other users as well
Creating a search form that opens a record in form view in edit mode
Posting Permissions
Reply With Quote