Perplexed

I have a database running on Access 97. The back end is stored on a 'shared'
drive and 10 users have access to it. Of the 10 users, all are running on a
Win98 platform with the exception on one. My system is Windows 2000. The
front end is copied to each PC locally. Here is my problem.....

I have spent the last three weeks making design changes to the database. I
did this on a front end copy that was only on my PC. Now that it's done and
I'm ready to distribute it to 7 other facilities, I wanted to test it here
first. I copied both the front end and back end to the shared drive, and
copied the front end to the other PC's. It works fine on my PC, but other
users are have problems. In particular, there is a form that looks up an
Appointment number (auto number) and matches it to a record in the table. On
my PC, as I type in the appointment number, it matches as it goes along, and
upon hitting enter, the information from that record is displayed. On every
other PC, an error message is returned stating that the item is not in the
list. If you scroll down the drop down list, the appointment number is
there, and you can retreive the information by clicking on it. I have
checked the properties, and everything is the exact same (as is should be,
since it is all pulling from the same place). I have tried everything I can
think of. I actually made shortcuts to the front end (which is also on the
shared drive) to see if it would work that way. Same problem.

I even went as far as hooking up a laptop to the network that also runs
Windows2000 to see if the problem was that is was running on two different
operating systems. I still get the same error.

Any help that can be provided would be greatly appreciated.

Do the other users have the same version and service pack level of Access as
you do? Do they have the same references (Tools--References)?
What is the control causing the problem, a combo box?
Check the property 'Allow entries not in list'.

Dorian

"Boz" wrote:

I have a database running on Access 97. The back end is stored on a 'shared'
drive and 10 users have access to it. Of the 10 users, all are running on a
Win98 platform with the exception on one. My system is Windows 2000. The
front end is copied to each PC locally. Here is my problem.....

I have spent the last three weeks making design changes to the database. I
did this on a front end copy that was only on my PC. Now that it's done and
I'm ready to distribute it to 7 other facilities, I wanted to test it here
first. I copied both the front end and back end to the shared drive, and
copied the front end to the other PC's. It works fine on my PC, but other
users are have problems. In particular, there is a form that looks up an
Appointment number (auto number) and matches it to a record in the table. On
my PC, as I type in the appointment number, it matches as it goes along, and
upon hitting enter, the information from that record is displayed. On every
other PC, an error message is returned stating that the item is not in the
list. If you scroll down the drop down list, the appointment number is
there, and you can retreive the information by clicking on it. I have
checked the properties, and everything is the exact same (as is should be,
since it is all pulling from the same place). I have tried everything I can
think of. I actually made shortcuts to the front end (which is also on the
shared drive) to see if it would work that way. Same problem.

I even went as far as hooking up a laptop to the network that also runs
Windows2000 to see if the problem was that is was running on two different
operating systems. I still get the same error.

Any help that can be provided would be greatly appreciated.

Wow....that was easy.....You guys ROCK!!!!

"Boz" wrote:

I have a database running on Access 97. The back end is stored on a 'shared'
drive and 10 users have access to it. Of the 10 users, all are running on a
Win98 platform with the exception on one. My system is Windows 2000. The
front end is copied to each PC locally. Here is my problem.....

I have spent the last three weeks making design changes to the database. I
did this on a front end copy that was only on my PC. Now that it's done and
I'm ready to distribute it to 7 other facilities, I wanted to test it here
first. I copied both the front end and back end to the shared drive, and
copied the front end to the other PC's. It works fine on my PC, but other
users are have problems. In particular, there is a form that looks up an
Appointment number (auto number) and matches it to a record in the table. On
my PC, as I type in the appointment number, it matches as it goes along, and
upon hitting enter, the information from that record is displayed. On every
other PC, an error message is returned stating that the item is not in the
list. If you scroll down the drop down list, the appointment number is
there, and you can retreive the information by clicking on it. I have
checked the properties, and everything is the exact same (as is should be,
since it is all pulling from the same place). I have tried everything I can
think of. I actually made shortcuts to the front end (which is also on the
shared drive) to see if it would work that way. Same problem.

I even went as far as hooking up a laptop to the network that also runs
Windows2000 to see if the problem was that is was running on two different
operating systems. I still get the same error.

Any help that can be provided would be greatly appreciated.