Linking to ODBC Table Causes Access to Crash

D

DerekWrightson

I'm having a problem with some of my Access XP databases whereby I try to
link to a SQL Server table and the Access crashes. I go File - Get External
Data - Link to bring up the wizard, change the file type in the drop down box
to ODBC Database and Access crashes, before I even see the list of DSNs on
the machine. Sometimes a compact and repair would solve this problem, but now
this has stopped working. The database was originally in Access 2000 format.
Converting it to Access 2002 format hasn't stopped the crash happening.

I can program round this using VBA and the DoCmd.TransferDatabase acLink
command, but as another database of mine is having problems with
DoCmd.TransferText acLink, how long will it be before this work-around stops
working? Any advice on what I can do to sort out the problem will be
gratefully received.

Thanks.
 

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 error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Using ODBC import 1
Table Security in Access 2013 1
Access 2007 - DoCmd.TransferDatabase not saving UID and PW 2
"Compile error in table level validation expression " after format 0
Link ForPro table with TransferDatabase 0
Link ODBC table in Access 2007 1

Top