How can I attach External MS-Access Tables to MS-AccessDatabases 
Author Message
 How can I attach External MS-Access Tables to MS-AccessDatabases


I'm desperately trying to append an external Access 2.0 table to an existing
Access 2.0 Database. It won't work.

Tabledef# = Database1.Tabledefs(#)
Database2.Tabledefs.Append Tabledef#
=> Empty fields collection

Tabledef#.Connect = "database.mdb"
Tabledef#.SourcetableName = "Tablename"
Database2.Tabledefs.Append Tabledef#
=> Couldn't find installable Isam

The Data Access Guide shows no single line of code how to manage this.
Does anyone knows how to do it?

Thanks a lot in advance ...

bye Raffael

     _/_/   _/_/

  _/_/_/ _/_/_/         http://www.*-*-*.com/ ~orient/
 _/  _/ _/  _/      phone/fax: +49(221)1392959/1392960
_/   _/_/    _/

Sat, 12 Sep 1998 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Regarding Accessing External database using MS-Access and MS-Visual Basic

2. Error updating attached MS-Access 2.0 tables

3. MS Access external tables don't work

4. Attaching External Access Table to Access Database

5. Lookup MS Access table from MS Word

6. Attaching Access Table in external database

7. Attaching Access table in external database

8. Attach MS SQL tables via ODBC

9. Link external table in MS SQL Server

10. Link external table in MS SQL Server

11. HELP: Attach Lotus to MS Access 2.0

12. Accessing current record in MS Access with DDE from MS Word


Powered by phpBB® Forum Software