Link table to User Level Secured Database

[arryb]

Help,

This is driving me mad.

I am trying to connect to a database using User Level Security.
i have the following code so far:

'reattach table from new database
Set tbl = db.CreateTableDef(NewTabName)
tbl.Connect = (";DATABASE=" & Directory & ";UID=RileyM;PWD=RileyM;")
tbl.SourceTableName = NewTabName
db.TableDefs.Append tbl

The code errors on the last line shown and produces an error along the lines of:
Could not read definitions; no read definitions for tblIcons.

Any ideas what the problem is. am i formatting the code incorrectly?

 

[mp9]

I think you may also need to reference the system.mdw file that the secured database uses. I can't really remember the syntax but it might be something like:

tbl.Connect = (";DATABASE=" & Directory & ";UID=RileyM;PWD=RileyM;SystemDB=C:\PathTo\MDWFile.mdw;")

Hope this helps.

http://www22.brinkster.com/accessory/

 

[arryb]

Thanks,

However, it didn't work!
Still get the same error i'm afraid.
I will have a play to see if it is something along those lines.

If anyone can help further i would be very grateful?