Avoid security warning through VBA

  • Thread starter Thread starter shailesh.tewari
  • Start date Start date
S

shailesh.tewari

I have an access database and and I have written VBA code in its module
which updates 10 other access databases from text files.I need these
ten databases and I can not create a single database with 10 tables and
update records there.

Any way my question is......When ever the new database is opened up
there comes a security warning asking me to click on Open or Cancel.I
want to avoid this warning so that once I click OK my all 10 databases
should be updated with out asking me for any input.
 
I have an access database and and I have written VBA code in its module
which updates 10 other access databases from text files.I need these
ten databases and I can not create a single database with 10 tables and
update records there.

Any way my question is......When ever the new database is opened up
there comes a security warning asking me to click on Open or Cancel.I
want to avoid this warning so that once I click OK my all 10 databases
should be updated with out asking me for any input.

http://home.bendbroadband.com/conradsystems/accessjunkie/macrosecurity.html
 
try going creating a macro and click on "set warnings" and set it to
"no" or "off" something like that
 

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

Back
Top