Splitting Database, does that affect Security

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

 

[Rick Brandt]

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.

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.