TransferDatabase

  • Thread starter Thread starter JA
  • Start date Start date
J

JA

I am trying to link a table in MS SQL database to MS
Access database using the macro.
I get the error maessage " could not find installable ISAM"
Why do I get this message? I am using MS Office 2000.

Action:TransferDatabase

Transfer Type:Link
Database Type:ODBC Database
Database Name:\\HQ-STT-2\WBTManager
Object Type:Table
Source:Students
Deastination:Students
Structure Only:No
 
Looking at the "Database Name" Section, I notice that
format looks like a a Server ID complete with a
directory. Is this format correct? Bear in mind that in
the "Database Name" you are supposed to enter the name of
the connection specified in ODBC. Refer to the Control
Panel/Administrative Tools/Data Sources (ODBC) for the
registered connections. If this is a Database that is
used by any user, then I suspect that you will need to
check out the "System DSN" page.
 
Back
Top