Objects lose permissions during export, I need some help, please...

[Larry Kahm]

I am working remotely on some changes for a secured database. I have a copy
of the FE, the BE, and the MDW file.

When I go to the client site to implement my changes, each and every object
that I export from my development FE to the production FE loses permissions.
I really had no idea this could happen!

Is there a way - programmatically - to transfer the appropriate permissions?
It would take a very looong time to do this manually (some changes affect up
to 30 forms at a time).

Thanks!

Larry

 

[Joan Wild]

Yes, objects always lose their permissions on import or export.

There are tools you can use to transfer the permissions, but it would be
much easier to just overwrite the client's frontend.

 

[Larry Kahm]

Joan,

Thanks for the quick response.

Yes, it normally would be easier to overwrite the FE, except that I'm never
sure whether their "on-site" person hasn't updated something I"m not working
on.

Could you please point me in the direction of where those tools might be so
that I can take advantage of them?

I appreciate your help.

Larry

 

[Joan Wild]

Sandra Daigle's site.
www.daiglenet.com/Samples/dbUtilities2000.zip

 

[Larry Kahm]

Excellent! Thank you very much!

Larry

Sandra Daigle's site.
www.daiglenet.com/Samples/dbUtilities2000.zip

 

[artek]

Excellent! Thank you very much!

Larry

 

[iamthequeen]

Hello,

Does anyone know when you go to export an Object/form to another Access.mdb file why it loses it's permission?

I exported a form using the file/export to another .mdb file and when I open the exported object/form in db after it's exported it no longer has any permissions.

In the new Db with form/object: file, users and permissions, users and group permission, groups, copyorders(Object Name), everyone: (open/run should be checked, however, it's blank)


I am using Microsoft Access 2010 DB.

Thank you