Yes. Once the VBA stops it looks like the imported tables are not there. However, if I click on the queries tab (Access 2003) and then back to the tables tab, the newly imported tables show up.
They're definitely being imported, but the database just doesn't know it. It's very frustrating.
Hope you can help.
Thanks.
monbois
Last Activity: Nov 9 '12, 08:40 PM
Joined: Apr 12 '07
Location:
-
Cannot Define Tables after Importation from Passworded Access DB
In my MS Access VBA sub-routine, after having identified an external database as having a password, by database retrieves the password from a table before importing the Questions and Text tables from that external database.
The following variables are assigned before the code is executed:
strLXRpthQdb = Name & Path of External Database
strPW = External Database's Password
... -
Do you mind sharing your solution? I'm having the same problem but can't figure it out.
Thanks....Leave a comment:
No activity results to display
Leave a comment: