Splitting Database, does that affect Security

  • Thread starter Thread starter Joyce
  • Start date Start date
J

Joyce

I placed users in one of three user levels with the
security wizard and assigned user names and passwords.
then I split my database. Now my security is not
working. did splitting the database invalidate my
security? I'm lost.
 
Joyce said:
I placed users in one of three user levels with the
security wizard and assigned user names and passwords.
then I split my database. Now my security is not
working. did splitting the database invalidate my
security? I'm lost.
Click to expand...

If you used the splitter wizard then yes; at least on the back end or data
file. If you had used the following procedure this would not have
happened.

Make a copy of the combined file (both will still have security). Then
remove all the tables from one copy and everything except the tables from
the other. Use the linked table manager in the one without tables to link
to all of the tables in the other.

In the future, use the above procedure or start out with a split app before
you apply security.
 
Back
Top