Opening/Linking to (user-level) secured db from unsecured db in VB

  • Thread starter 2.0 to 2000 converter - Bruce
  • Start date
2

2.0 to 2000 converter - Bruce

I have looked and looked and from what I have seen, there is no way to open
or link to a (user-level) secured db from an unsecured one usign VBA.
OpenDatabase seems to have provision to allow a way through database-level
password protection, but not user-level.
I am writing a db to perform as many steps as I can to convert an MSAccess
2000 db into an Oracle one with a number of structure changes, so I want to
open or link (attach) to the tables in the production db, so I can run the
conversion queries and produce Oracle scripts ready to run on the Unix Oracle
server.
Any suggestions?
 

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

Similar Threads

Linking to Secured Db 2
creating a new Db through VBA code 0
changes to user level security 1
Cannot Convert Access 2002 DB To Access 2007 6
Append records from table in unsecured db to table in user level s 3
Programatically open Access DB with user level security 2
Appending data to tables in a secured 'BE' db 3
workfile secured db 9

Top