Software

Ask something
Discussion Locked

Access 97 Sharing a DB

0 helpful
6 replies

by ratliffje

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have done everything that I know, DB has worked fine for 3 yrs. Now if one person has it open another can not close and save changes. It says (user name) has DB locked and you may not save changes.

6 replies

by john

The term "I have done everything that I know" is not very helpful in trying to understand what you have and have not done.

However as a first step I would try importing all the database objects into a new (and hence clean) database file, and then use this file as to replace the existing database. If that fails please supply more details of the steps you have tken to rersolve thr problem.

by berkimdgkr

I don't know how you open the database. However, if user tried to open database exclusively, there are no ways you can open it. Another point you should check is locking. If program lock the table by passive, same problems might happend.

by mattohare

Did one (or more) of your users get a new installation of Access? Or, did one (or more) change their settings to open a database exclusively, by default? Check the users that lock the DB and see if they've made that setting.

Also, someone may have set up a new query (or chagned an existing one) to take locks that it did not in the past.

by butch4444uk

how do i write an expression for todays date so it will give me a query for tomorrows date
now()+1 does not work in query

by dpj

This may not work for '97, as I have not used it in a couple of years, but if memory serves me well, it should.

Expr1: DateAdd("d",1,[Your Field for Date goes here])

-Don

by etruss

I think the reason using Now does not work is because it includes the time as well as the date. The previously suggested solution will probably work or you could use a BETWEEN on the time if necessary to get what you want.

This discussion is closed to new replies.