Unable to see data in lookup field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rmlogan - 24 Apr 2008 22:39 GMT

I have 7 computers that are mapped to a Access Database on a Stand Alone PC.
The database has been working great. Recently the database on the stand alone
computer was copied to a Thumb Drive. The user that copied the database to a
thumb drive can take thumbdrive to 3 of the 7 computers and is able to see
and select the data in the lookup field. But when the thumb drive is taken to
the other 4 computers the lookup data is not shown but can be selected. Also
when accessing the database directly from the stand alone computer the lookup
data is not showing but can be selected. Renamed the database file on the
thumb drive and copied to the stand alone pc and still can not view the
lookup data. Any ideas why this is happening and how to fix it?

Thank You

Reply to this Message

Dirk Goldgar - 25 Apr 2008 01:20 GMT

>I have 7 computers that are mapped to a Access Database on a Stand Alone
>PC.
[quoted text clipped - 12 lines]
> thumb drive and copied to the stand alone pc and still can not view the
> lookup data. Any ideas why this is happening and how to fix it?

I'm not sure, but I wonder if the computers that can't see the lookup list
are running Access 2003 SP3 without the post-SP3 hotfix. There is a bug in
SP3 that would cause combo box lists to be blank under certain
circumstances. Here's a description of the bug:

http://support.microsoft.com/kb/945280/

And here's a description of the hotfix, with a link to download it:

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

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message

rmlogan - 25 Apr 2008 03:24 GMT

> >I have 7 computers that are mapped to a Access Database on a Stand Alone
> >PC.
[quoted text clipped - 23 lines]
>
> http://support.microsoft.com/kb/945674/

I will give your suggestion a try and let you know the results.

Reply to this Message