access2007 create table error - invalid argument

#1

I've got a 2nd MDB with a table (tblPersonalInfo) and I'm trying to
create a linked table
strsql is the path to that mdb

this works
Set db = CurrentDb
Set tbl = db.CreateTableDef("tblPersonalInfo." & lngEmpCode, _
dbHiddenObject, _
"tblPersonalInfo", _
strSql)

but if I use, dbAttachedODBC, I get an error, invalid argument

yet if I use the link table manager to link to the table and I display
its attribute property it is set to the value of dbAttachedODBC, and
the sourceName and connect value match what I'm using above

what am I missing ?

#2

On Dec 13, 8:13*am, Roger <lesperan... (AT) natpro (DOT) com> wrote:

Quote:

I've got a 2nd MDB with a table (tblPersonalInfo) and I'm trying to
create a linked table
strsql is the path to that mdb

this works
* * * * Set db = CurrentDb
* * * * Set tbl = db.CreateTableDef("tblPersonalInfo." & lngEmpCode, _
* * * * * * * * * * * * * * * * * * dbHiddenObject, _
* * * * * * * * * * * * * * * * * * "tblPersonalInfo", _
* * * * * * * * * * * * * * * * * * strSql)

but if I use, dbAttachedODBC, I get an error, invalid argument

yet if I use the link table manager to link to the table and I display
its attribute property it is set to the value of dbAttachedODBC, and
the sourceName and connect value match what I'm using above

what am I missing ?

it looks like 'dbAttachedODBC' is readonly
using dbAttachSavePWD sets up the linked table properly

#3

I just use CREATE TABLE syntax, because I think that's a lot easier to deal with.

Aren't you tired of dealing with all this extra bullshit involved with linked tables?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

access2007 create table error - invalid argument

comp.databases.ms-access comp.databases.ms-access

access2007 create table error - invalid argument - 12-13-2010 , 09:13 AM

Re: access2007 create table error - invalid argument - 12-13-2010 , 11:10 AM

Re: access2007 create table error - invalid argument - 01-03-2011 , 06:02 AM