multiple user error

[Matt]

Question--

I have a form that is programmed to pop up upon start-up of
the database if there are records in a query called
"Overdue". It's a form that basically lets the user know
that they have X amount of records that are over-due.

This was working great until more than one user started
using the database. It now seems to have trouble counting
the records in the "overdue query"...something about
locking the table. Upon startup, the following message is
shown:

"Couldn't lock table "tablename", currently in use by user
Admin."

anybody seen this before? Any suggestions?

 

[peter walker]

Check the locking options for the database and that query in particular.

--

peter walker MVP

Please post replies to the news group so everyone can benefit.
www.papwalker.com