Linking to a ".mdb" database table via an ".accdb" database

[Pierre Doré]

Our organization has just upgraded from MS OFFICE XP to MS OFFICE 2007. We
have many Access Apps in the ".mdb" format using ULS (User Level Security) &
mdw. However all new apps are to be created in the ".accdb". With that in
mind, I ran into a problem. I have to build this new app that will have to
link to mdb database to gather information. I've discovered that the only
way I can access that database is using the acCmdWorkgroupAdministator via
the VBA Editor and selecting the appropriate mdw file. Now instead of having
one password to access this new database, I have to supply two; one for the
mdw and one for the database itself. Also, I now have the problem that the
next time I run an Access 2007 app (accdb), it will prompt me for the
password with the user of the last mdw file that I had to join in order for
that app to function. Is there a way, by code I suspect, to select the
appropriate mdw file and the associated password, and then swith bakc to the
MS Access 2007 system.mdw when closing that app?

 

[Arvin Meyer [MVP]]

Our organization has just upgraded from MS OFFICE XP to MS OFFICE 2007.
We
have many Access Apps in the ".mdb" format using ULS (User Level Security)
&
mdw. However all new apps are to be created in the ".accdb". With that
in
mind, I ran into a problem. I have to build this new app that will have to
link to mdb database to gather information. I've discovered that the only
way I can access that database is using the acCmdWorkgroupAdministator via
the VBA Editor and selecting the appropriate mdw file. Now instead of
having
one password to access this new database, I have to supply two; one for
the
mdw and one for the database itself. Also, I now have the problem that
the
next time I run an Access 2007 app (accdb), it will prompt me for the
password with the user of the last mdw file that I had to join in order
for
that app to function. Is there a way, by code I suspect, to select the
appropriate mdw file and the associated password, and then swith bakc to
the
MS Access 2007 system.mdw when closing that app?

I'm pretty sure that your current methodology is what you are going to have
to do from here on in, unless you either change your structure to use MDBs
for everything, or convert everything to use ACCDBs for everything. Unless
you are intending upon using some of the new field types (multi-value and
attachment, there is no advantage to the new format, and the disadvantage is
that you cannot use ULS, and you cannot share with anyone who has an earlier
version.