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

  • Thread starter Thread starter Larry Kahm
  • Start date Start date
L

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
 
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.
 
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
 
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
 
Back
Top