Thread: MS Access file
View Single Post
  #1  
Old January 11th, 2010, 03:33 PM posted to microsoft.public.access.tablesdbdesign
Zilla
external usenet poster
 
Posts: 16
Default MS Access file

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