Split database subform not seen by all users

  • Thread starter Thread starter paul
  • Start date Start date
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!?
 
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".
 
Thanks, it worked!
-----Original Message-----
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".




.
Click to expand...
 
Back
Top