We are in the process of moving to Access 2003, I have several databases may still rely on macros. But under Access 2003 you get that Macro Security Warning about the Access File being unsafe. I don't want to have all the users manually set the macro set to low, and I don't have the time to go through all the databases start converting and testing the macros in VBA.
I found an article on the MS site Refering to this issue and it recommends using the following code in the on on load event: Application.AutomationSecu
But it does't work.
Jim
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Pete
Yes I saw the piece of code as well but I not sure what to do with it.
The following is a mewbie question:
Do I need to create a seperate database and place in in the on load event on a blank form. Or can I embed it in the specific database that I want to load then set C:\<FileToOpen>.mdb to open its self.
It sounds like a stupid question but I've tried it both ways and on each occasion the multiple instance of the database started opening.
Jim
Pete - thanks for this bit of code, I've been searching for something like this for a couple of days.
My problem is that I need the VBScript to start an Access DB on a machine with only the runtime libraries - not the full Access version - installed. My knowledge of VBScript is pretty limited.
What would be the correct way to do this?
Cheers - Cyberwombat
Business Accounts
Answer for Membership
by: peter57rPosted on 2004-03-04 at 08:43:55ID: 10515476
Hello jnewman,
I'm not sure which MS article you are referring to, but to avoid the security message you have to set the security level outside of ACCess before opening the database.
You can create a VB script file with this code and start your app using this. (Code is from an MS article)
Const cDatabaseToOpen = "C:\<FileToOpen>.mdb"
On Error Resume Next
Dim AcApp
Set AcApp = CreateObject("Access.Appli
If AcApp.Version >= 10 Then
AcApp.AutomationSecurity = 1 ' msoAutomationSecurityLow
End If
AcApp.Visible = True
AcApp.OpenCurrentDatabase cDatabaseToOpen
If AcApp.CurrentProject.FullN
AcApp.UserControl = True
Else
AcApp.Quit
MsgBox "Failed to open '" & cDatabaseToOpen & "'."
End If
Pete
Pete