Form displays records for some users, not for others?

M

mpa.pirate05

My office has been using an Access database for a couple of years now
to track records. The database resides on a server and about 12 or so
people can access it. Some of us recently upgraded to MS Office 2007,
some are still using MS Office 2003.

Just yesterday, one of our users noticed that he could not view
records in a form when he used the combo list drop down to select a
primary record for which he wanted to view details and enter data. He
is using Office 2003. The rest of us who are using Office 2007 can use
the database with no trouble at all. The user who is having the
problem opened up a back up database from a few months ago and was
able to use the combo list to view records without any trouble, so I
am perplexed as to what the issue is. At first I thought might be
something on his machine since the rest of us could use the database
correctly, but now I am not sure.

To my recollection there has not been any changes to the database in
question.

Any ideas? I am thinking about recommending that the troubled user
upgrade to MS Office 2007 to see if that might fix it.

Thanks!

Mike
 
F

fredg

My office has been using an Access database for a couple of years now
to track records. The database resides on a server and about 12 or so
people can access it. Some of us recently upgraded to MS Office 2007,
some are still using MS Office 2003.

Just yesterday, one of our users noticed that he could not view
records in a form when he used the combo list drop down to select a
primary record for which he wanted to view details and enter data. He
is using Office 2003. The rest of us who are using Office 2007 can use
the database with no trouble at all. The user who is having the
problem opened up a back up database from a few months ago and was
able to use the combo list to view records without any trouble, so I
am perplexed as to what the issue is. At first I thought might be
something on his machine since the rest of us could use the database
correctly, but now I am not sure.

To my recollection there has not been any changes to the database in
question.

Any ideas? I am thinking about recommending that the troubled user
upgrade to MS Office 2007 to see if that might fix it.

Thanks!

Mike
Click to expand...

have you recently installed Access 2003 Service Pack 3 on that
machine?
Could be the Service Pack 3 bug.
See this link for details on the hotfix.

http://support.microsoft.com/kb/945674
 
M

mpa.pirate05

have you recently installed Access 2003 Service Pack 3  on that
machine?
Could be the Service Pack 3 bug.
See this link for details on the hotfix.

http://support.microsoft.com/kb/945674
Click to expand...

I just checked his machine and his Access 2003 is SP3. I think I need
our IT guy with administrative rights to install the hotfix - fingers
are crossed!!!
 
K

Klatuu

Do it.
It could be corruption. When you use an unsplit database in a multi user
environment, you are almost guaranteed to get corruption.

Is your database split?
Click to expand...

No
 

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

Access User Login form in Access with Ristriction 0
Audit Tracking - Users 4
Custom Ribbon For A Form Doesn't Work 1
form genrated for some records not for others 3
cant add new records to a form 3
Form Not Visible 2
Combo: Row source changed, but old list appears 2
Combo box with sorted query will not return all records 7

Top