List Box Data disappears with multi users

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a form with a listbox that works fine with only one user logged in on
the database. When a second user logs in and opens the same form the first
user loses all data in the listbox. If the first user closes the db then
logs back in and opens the form the second user then loses all data in the
listbox but the first user now has all the data again.

The db is not on a server. It is on a workstation that has given other
users on the network full rights to the folder where the db resides.

The db is in Access 2000. It has a front and a back end. Both are in the
same folder.

Any thoughts? Thanks in advance for any and all responses.

Robbie
 
Robbie,

To begin with, each user should have their own, dedicated copy of the FE
(preferably on their local HDD), as opposed to all users opening the
same (single copy of the) FE, which I understand is what you currently
do. This will most likely fix your problem.

Secondly, unless this is a small peer-to-peer network where this is your
only option, you should move the BE to a shared folder on a server.
That would significantly increase performance for all users, and free up
the workstation where the BE currently resides, from the excess workload.

HTH,
Nikos
 
Back
Top