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.
 
You must log in or register to reply here.

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

TransferDatabase maco 1
Access 2007 halts a macro using TransferDatabase method 3
Need help with TransferDatabase comand, please. 1
From a module copy a form & toolbar from another database 1
TransferDatabase problem 6
in Access 2007-TransferDatabase action will not work. 0
Access TransferDatabase Does Not Import 2
TransferDatabase in MDE 5

Back
Top