Database Exclusive mode problems

[Orson9750]

I have created a database with help from Access Forum experts. The datbase has 6 tables. All tables have working relationships. When I try to create a query or form using 2 joined tables I get an error message " The wizard was unable to open your form ... query in form view or datasheet view, possibly because another user has a source table open in exclusive mode. I checked each table and all tables are on shared with no restrictions. No other database is open, the database in located on my personal drive not on a shared drive at this time.

What else could be the problem?

Thanks for your help

 

[Guus2005]

View the ldb file using the LDBVIEWER and see if someone else is in your database. It could be that that other person is yourself in a second or rogue Access application.

Close all Access applications and use the taskmanager to see if you have any rogue access applications running (or you can reboot).

The ldb file should have been deleted when you exit Access the proper way and you should be able to delete it yourself.

Now try again, open the database with shift pressed run the wizard.


If it still doesn't work, perhaps your database is corrupt. Use compact and repair.

HTH

 

[Orson9750]

Thanks. I finally figured it out. My joined fields were not the same data types. Once I made the change the query and form worked.

I appreciate your example which I am sure will be helpful in the future.