Incomplete Records with an ODBC Linked Table?

W

WildlyHarry

I have built a database in Access 2000 that makes use of the ODBC function to
link three tables from a Lotus Notes Database. On my machine, the tables
contain the full records from the Lotus Notes Database. On other machines
the tables are truncated. The other users are also on Access 2000. Only
about 10% of the Lotus records appear in the Access table. While the records
on the Access table are the same from machine to machine, they appear to be
random records from Lotus. I have no idea why this is happening. Has anyone
ever experienced anything like this? Thank you in advance for you help in
this matter.
 
G

ghetto_banjo

i had something similar in Access 2003 with ODBC connections to an AS/
400 database. it was fixed by going to the Linked Table Manager and
refreshing all of those ODBC connections for the linked tables.

if that doesnt work, i havent a clue.
 

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

ODBC 3
make table not replacing table on back end 11
Linked Tables - Do I Need DNS on end users PC? 1
Email Message Text Going in "TO" Field 2
Separate Form 0
Would like feed back on idea before starting development 1
Error 3157: "ODBC - update on a linked table <table name> failed 4
Linking ODBC Tables for Multiple Users 7

Top