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.

On Wed, 1 Nov 2006 14:37:02 -0800, Rena
<(E-Mail Removed)> wrote:

>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]

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

"John Vinson" wrote:

> On Wed, 1 Nov 2006 14:37:02 -0800, Rena
> <(E-Mail Removed)> wrote:
>
> >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]
>