Security problem on Access 2007

[Chipcom]

Hi

I have mdb file that created in Access 2003 and formatted by access
2000.
I have changed the Access to Access 2007 and my OS to vista , the user
name and the computer name too.
When I open the mdb file and tried to load form for an example I am
getting the massage:
You don't have permission to run 'frmLogon.'
To run this object, you must have Open/Run permission for it. For more
information on permissions and who can set them, click Help.

When I click the help button I see some unrelavants topics than can't
give me the correct information.
I know somehow that the problem is from the inheritance of the file
owner and permission.

Can you please tell me what to do to overcome this problem?

Thanks

 

[Douglas J. Steele]

One possibility is that VBA is disabled by default. You need to add the
path to where your database is stored to the Trusted Locations. You do this
through Office Button | Access Options | Trust Center | Trusted Locations.

 

[Chipcom]

One possibility is that VBA is disabled by default. You need to add the
path to where your database is stored to the Trusted Locations. You do this
through Office Button | Access Options | Trust Center | Trusted Locations.

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no private e-mails, please)










- Show quoted text -

I already add the location and it didn't solve the problem.

Any another Idea?

Thanks

 

[Joan Wild]

You need to launch it via a desktop shortcut, since it's secured.
"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"

 

[Chipcom]

You need to launch it via a desktop shortcut, since it's secured.
"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"

--
Joan Wild
Microsoft Access MVP









- Show quoted text -

I would like to know how to change the owner database (From the "old"
owner to the "new" owner) ?


Can you please help with that?

 

[Joan Wild]

I would like to know how to change the owner database (From the "old"
owner to the "new" owner) ?


Can you please help with that?

You'd need to create a new mdb while logged in as the 'new' owner (note that the accdb format doesn't support user level security), and then import all the objects from the old mdb and then apply the permissions.

It really isn't worth it, IMO. As long as you can log in and use the database, who cares who the name of the owner is?