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".
 
Top