problem running a procedure in a passworded project

J

June Macleod

I have an Access 2000 database on which I have a password to protect the
project modules.

I have a function which in turn calls another function that alters some
lines of code in the module using ReplaceLine.

It all works well provided I have previously logged into the project module
and supplied the password however I need to run these functions when the
application is first started - I use the /X macroname in the command line
(basically they update a fall out date and set it to the value in an
encrypted text file) and my problem is that it will not run the function for
the end user.

I get the error message "Can't find the procedure '.' when the first
function is called (it never even reaches the line to update the module
code)

Does anyone know if there is any way to set either the security permissions
or else to supply the password to allow the user to run the procedure to
update the module.

Any help would be great.

Thanks

June
 

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