On Mon, 11 Jan 2010 07:33:37 -0800 (PST), Zilla wrote:

I have a file at work that the boss uses and now has given to me. Only
problem is the person who designed the access file to run from the
bosses desk top. When I try and run the file from mine it comes up
with an error shown below. I would like to know how I can change the
code so that I can run the file as well. This file is in a general
folder not locked. This is driving us both nuts can anyone help?

Thanks


Private Sub Form_Start() ----------------- This part
is highlighted yellow.
Set db = CurrentDb
DoCmd.SetWarnings False
DoCmd.Maximize
Call Delete_Queries("*")
Call Delete_Tables("Temp*")
Me.Database_Name = DBName
strUser = UCase(GetUser)
Me.User = strUser
End Sub

Is this in Access 2007? If so, the database must be in a "Trusted Location" in
order for VBA code such as this to be allowed. It would appear that the
developer specified the boss's folder as trusted, but yours isn't.

Check the Access help for "Trust Center".
--

John W. Vinson [MVP]