Using VB to Create Linked External Table

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I am trying to use ADOX in VB 6 to programmatically
create a linked Access table from a user-level secured
database ( user id and user pasword with no database
password) on a read-only network drive to a local user-
level secured Access database (again with user id and
user pasword and no database password).

What is the correct Jet I-Isam connection string to
provide? I have
tried ";DATABASE=\\server\share\myremotedb.mdb;UID=myUser
ID;PWD=myUserPWD" to no avail. I receive the following
message : "The Microsoft Jet database engine cannot open
the file '\\SEERVER\SHARE\MYREMOTEDB.MDB. It is already
opened exclusively by another user, or you need
permission to view its data."
 
I've tried User ID=XXX and Password=XXX and got the same
error message. I believe it has something to do with the
inability to provide the system database file in the I-
ISAM connection string. Using Jet OLEDB:System database
= xxx in the connection string produces an unknown
parameter error message.
 
Ok. Sorry I can't help further (cos I don't know ADOX), except to confirm
that you *do* somehow have to identify the correct workgroup file against
which the database was secured.

Maybe try googling for "ADOX workgroup security" or somesuch?

HTH,
TC
 
Back
Top