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


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
 
Ad

Advertisements

J

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.
 
L

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
 
Ad

Advertisements

Joined
May 6, 2014
Messages
1
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top