Database file name change causes issues with database design updates

[Michael]

I use Access 2003 and I have a Database called "MyNewDatabase.mdb" and its
security file called "My New Database.mdw". When I change the database file
name to: "My New Database.mdb" so that it matches the naming convention of
the security file and I open the database and I try to do a design change to
a form, I get error messages that I did not open it exclusively, there may
be other users, and I cannot update the design. I know I am the only user
and it runs on my laptop. When I change the name back to the original name,
this problem goes away and I can change the design with no problem.

I also tried changing the security file name to match the database file
naming convention, but the same issue appeared. What am I doing wrong?

Thank you,
Michael

 

[Joan Wild]

Both the mdb and the mdw need to create a ldb file. Since they're both
named the same, the second one can't be opened.

You could put the mdw in a different folder. However I'd suggest you give
them distinctive name to avoid confusion.