Split database subform not seen by all users

P

paul

I've split the tables from our database and put them on
the server. The front end(forms, queries, reports) is on
each users desktop.
In the data entry form, there is a sub form. When more
than one user is in the main form, 1st user into the
database sees the sub form, 2nd(3rd, 4th, etc.) user into
the database doesn't. They all can see the main form
although it takes longer to load for #2 user.
Any help - thanks!?
 
N

news.east.earthlink.net

It sound like a "lock" is being placed on the records of the subform. This
locking is determined when the recordset is opened. Check how it is opened
and make sure it is not opened "Exclusive".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Column Orders 1
Focus set to sub-form when form first opened. 3
subform not consistently displaaying records 2
ACC2000: Run-time error 2450--Move from form to subform to subfor 1
Tabbed form help 1
syncronize two subforms oncurrent events 0
go to specific record based on choice in subform 2
Inconsistent Add Record Performance 2

Top