DAO.TableDef - Connect

[mattia]

Hi all, I've been told that useng DAO.TableDef there is the possibility
to attach linked data to your database (I have an access db that uses
data from another access db). Can you provide me some examples and
possible error codes?

Thanks, Mattia

 

[Piet Linden]

Hi all, I've been told that useng DAO.TableDef there is the possibility
to attach linked data to your database (I have an access db that uses
data from another access db). Can you provide me some examples and
possible error codes?

Thanks, Mattia

You should be able to force the errors to occur on your own... like
the database specified doesn't exist that you are trying to link to,
or the table doesn't exist in the database. build a dummy Db that you
are going to link to and misspell the table name, and record the error
#. Do the same with the database...

 

[Piet Linden]

Hi all, I've been told that useng DAO.TableDef there is the possibility
to attach linked data to your database (I have an access db that uses
data from another access db). Can you provide me some examples and
possible error codes?

Thanks, Mattia

check out the Connect property of the tabledef object. ... and the
error codes.

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "LinkTables.mdb" which illustrates how to do this. You can
find it here:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=334

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L