In our db we can search by last name or company name. When searching by a person's name, a form pops up where we enter the last name. The event procedure for the form is to run a query in and in that query the search criteria for the lastname is
Like ([forms]![Person...
We are a small company with only 6 users with Microsoft Access 2000. The first person who opens the DB has no problems but when a second person tries to open the db, we get a message "the database has been placed in a state by "USER" and the second person can not get into the DB...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.