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...
 
You must log in or register to reply here.

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

Split the Database and VBA code issue 4
Pass Subform filter to subform in report 0
trying to minimize Write Conflicts in a multi-user database 64
subform not consistently displaaying records 2
How to Show Form ComboBox value into other Form Label caption 3
Focus set to sub-form when form first opened. 3
DataMacro problem after Splitting Access Database 2010 0
ACC2000: Run-time error 2450--Move from form to subform to subfor 1

Back
Top