VBA Password and Importing

[Jake]

I posted this earlier, but the answer went off the wrong
way and the post has been passed over since...sorry about
the repost!

Anyway, I have an app where the frontend has a password on
the VBA project. When this app updates, it looks at a
table and imports/deletes the various forms, queries,
reports, and modules from a "master", updated version on a
shared drive. This is running into problems, because both
the shared drive version and the user's version have the
password on the vba project, and an error is given saying
that the password must first be supplied. How do I give
the password in order to make this work?

Thanks!
Jake

 

[Tim Ferguson]

When this app updates, it looks at a
table and imports/deletes the various forms, queries,
reports, and modules from a "master", updated version on a
shared drive.

This is not a simple nor a recommended way of updating a front end. The
whole point (well, a large part of it anyway) is that separating the front
end from the data means that you can simply throw away the front end and
replace it with an updated one. There should be nothing in the front end
that needs to be keps (if it's permanent, it should be in the back end).

HTH


Tim F

 

[Tim Ferguson]

I wish it were that simple. Users are constantly asking
for new reports, changes to the forms, etc. but then get
frustrated at having to recopy the front end. This was my
solution to their complaints. Do you have any ideas how
to do what I requested?

Well, you can certainly make the process pretty painless. You can place a
copy command in the logon script, or you can simply install a shortcut on
their desktops to call something like

command.com /c copy j:\access\newfrontend.mdb h:\data\frontend.mdb

and if they can't even run that then they do have big problems!

Best wishes


Tim F

 

[Jake]

Surely you jest.

I wish I were. It seems like everyone is just looking for
a reason to whine, and the "difficultly" of copying gave
them one. I'll take a look at the site you recommended,
though - THANKS!

Jake