Access 2002

[Guest]

I'm not sure if this is the best place to post this question because I don't
know what is causing this problem.
I have an Access 2002 database in a server that is shared by all of us in
our unit. There is a form that allows us to enter new records and one of the
fields is set up as a list box. The source of the data in this list box
comes from a table. The user is instructed to click on the up/down arrows
(scroll) and highlight a value.

When I open the form, it allows me to scroll up or down and select a value.
When other users open the form, there are no arrows, just a box. They cannot
even enter a choice. Does anyone know what would cause this?

Thank you in advance for any help.

 

[John Vinson]

I'm not sure if this is the best place to post this question because I don't
know what is causing this problem.
I have an Access 2002 database in a server that is shared by all of us in
our unit. There is a form that allows us to enter new records and one of the
fields is set up as a list box. The source of the data in this list box
comes from a table. The user is instructed to click on the up/down arrows
(scroll) and highlight a value.

When I open the form, it allows me to scroll up or down and select a value.
When other users open the form, there are no arrows, just a box. They cannot
even enter a choice. Does anyone know what would cause this?

Thank you in advance for any help.

If you and the other user are attempting to update the same record *IN
THE SAME FORM*, the second and later users will be locked out.

You *really* should split your database. See

http://www.granite.ab.ca/access/splitapp.htm

for the rationale and instructions. Basically, you can use Tools...
Database Utilities... Database Splitter Wizard to split the database
into a "backend" containing only the tables, and a "frontend"
containing the Forms, Queries, Reports etc. Each user will get their
own copy of the frontend linked to the shared backend; that way
there'll be no contention for this listbox, faster performance, less
bloat and less corruption.

John W. Vinson[MVP]

 

[Guest]

Thank you, John. I will attempt to split the database for performance.