Tabledefs.append

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Is there a way to use

tabledefs.append linktable

where linktable is a linked table.

I have no problem appending a table who is data is in
ACCESS but run into all kinds of trouble when the data is
external (Oracle or orhters).

Thanks
 
I have tried this and still get a 3011: The Microsoft Jet
database engine could not find the
object 'objectname'........


Any suggestions????




-----Original Message-----
[email protected]:

Is there a way to use

tabledefs.append linktable

where linktable is a linked table.

I have no problem appending a table who is data is in
ACCESS but run into all kinds of trouble when the data is
external (Oracle or orhters).
Click to expand...

Here's one sample:

[ http://www.mvps.org/access/tables/tbl0010.htm ]

-- Dev
.
Click to expand...
 
I have tried this and still get a 3011: The Microsoft Jet
database engine could not find the
object 'objectname'........
Click to expand...

Have you tried debugging it to see on which object it fails? What about the
connection string you are using?

-- Dev
 
Back
Top