Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ODBC Error on MS Access link tables to SQL Server

Status
Not open for further replies.
DanAuber

DanAuber

IS-IT--Management
Apr 28, 2000
255
0
0
FR
I have an access database that uses link tables to SQL server to produce MS Access reports. This all works fine except when a largeish quantity of data is being pulled back when I get an ODBC error. Is there anyway to rectify this.

Thanks

Dan

 
Sort by date Sort by votes
What ODBC error do you get? (There are many.)

If the error is being hidden by Access (a particularly nasty ODBC client, BTW) then enable ODBC trace for the datasource.

Tom Morrison
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Rudraya
  • Locked
  • Question
failed connecting odbc
Replies
0
Views
108
Rudraya
Rudraya
dcern
  • Locked
  • Question
Ingres ODBC Driver slow
Replies
0
Views
107
dcern
dcern
MDGarcia
  • Locked
  • Question
ODBC error: Specified driver could not be loaded due to system error 193
Replies
1
Views
161
k5tm
k5tm
Antonius222
  • Locked
  • Question
Must the driver use SQLGetPrivateProfileString?
Replies
0
Views
50
Antonius222
Antonius222
acoronel
  • Locked
  • Question
Error message to use active directory authetication to access SQL database.
Replies
0
Views
101
acoronel
acoronel

Part and Inventory Search

Sponsor

Back
Top