security lost on back end

[JohnLute]

I just split my secured database. The BE file can opened with a click and all
data manipulated! I had no idea that the security wold be lost.

How do I make the BE secure?

Thanks!

 

[Rick Brandt]

I just split my secured database. The BE file can opened with a click and all
data manipulated! I had no idea that the security wold be lost.

How do I make the BE secure?

The splitter wizard does result in an unsecured back end. It's better to split
manually...

Copy original monolithic file (security is retained).

Delete everything but the tables from the new copy.

Use this file as your back end.

 

[JohnLute]

Thanks! That sounds easy enough however, I've added data to the unsecured BE
already. Is there an easy way to import/export the new data into the new BE?
If not, is there an easy way to make the new BE secured?

Thanks!

 

[Rick Brandt]

Thanks! That sounds easy enough however, I've added data to the
unsecured BE already. Is there an easy way to import/export the new
data into the new BE?

If you can identify the new/changed rows then you could create a temporary
front end and use that to link to both back end files. Then run
update/append queries between them. Depending on the number and size of
your tables this could be easy or a PITA.

If not, is there an easy way to make the new BE
secured?

Technically, the back end file resulting from the splitter is still secured
in the sense that it was created while joined to the secure MDW file and
should be owned by a user with proper administrator privileges in that
workgroup. What you have lost is the permissions settings on the database
object and all of the tables themselves. You can certainly go into the
security menu and reset them all back the way they were.

From here I can't say which of those would be easier/faster.

 

[JohnLute]

Thanks, Rick.

When you say go into the security menu do you mean Tools > Security?

If so, I don't see where I need to go from there.

 

[Rick Brandt]

Thanks, Rick.

When you say go into the security menu do you mean Tools > Security?

If so, I don't see where I need to go from there.

The "User and Group Permissions" option should produce a dialog with a list
of all objects and a list of all Groups/Users. You would have to select
each object and assign to it the permisson you want each Group/User to have.

 

[JohnLute]

On second thought - could I simply run the security wizard and create an
entirely new security setup?

I suppose this will lose all User configurations but that's OK as there's
only a few currently setup. It would be faster to set them up again.