How to specify password to MAKE TABLE query (97)

Topic

New Reply

How to specify password to MAKE TABLE query
I

Reply | Quote

Replies

Not really answering your question but why not do it the other way round? Set up a select query containing all the necessary data in your non-passworded db and set a link to it in the passworded db.
Best I can think of. Hope it helps.

Reply | Quote

Sorry the reason I can

Reply | Quote

You may have to do this in code. Then you would put the password in the connect string.

Reply | Quote

That

Reply | Quote

Look up CreateWorkspace in on-line help. You’ll need to pass the userid and password like this:

Set wrkJet = CreateWorkspace(“”, “userid”, “pwd”)
Set db = wrkJet.OpenDatabase(strDBPathAndFile)

You need to substitute the actual password and username for pwd and userid in the above example.

Reply | Quote