Queries, programmatically within Visual Basic

H

Humberto DeLuca

I'm writing code to open another access database (DATABASE
ONE) within a database to extract a recordset. DATABASE
ONE has it's own system DB file with different
permissions.

How do you do this in code? I tried to change the
EngineDB.SystemDB string to the DATABASE ONE location of
the system.mdw file. I also set up the user name and
password. However, when I try to access the particular
table I want, I get a 'you don't have permission to access
this database, etc'.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top