Database Split Question

[Guest]

I've done this before but now I'm having a problem splitting another
database. I currently have a secured db that I'm trying to split. When I
split the database into a FE/BE I lose all my permissions for my tables. When
I open the BE the permissions are there but when I open the FE the
permissions are gone. I have to reset all my permissions to my tables now.
Can anyone shed some light as to why this is happening?

 

[Joseph Meehan]

I've done this before but now I'm having a problem splitting another
database. I currently have a secured db that I'm trying to split.
When I split the database into a FE/BE I lose all my permissions for
my tables. When I open the BE the permissions are there but when I
open the FE the permissions are gone. I have to reset all my
permissions to my tables now. Can anyone shed some light as to why
this is happening?

It sounds like you are not joining the workgroup when you open the FE.
Take a look at the properties of the icon you are using to open the BE and
copy the additional information to the other properties and see if that
helps.

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Practice on some copies to make sure you know what you are doing.

 

[Guest]

I am joining the workgroup properly. All my permissions on the FE for the
queries, reports, etc are still intact. The only thing I lose is my
permissions for the tables on the FE.

I've done this before but now I'm having a problem splitting another
database. I currently have a secured db that I'm trying to split.
When I split the database into a FE/BE I lose all my permissions for
my tables. When I open the BE the permissions are there but when I
open the FE the permissions are gone. I have to reset all my
permissions to my tables now. Can anyone shed some light as to why
this is happening?

It sounds like you are not joining the workgroup when you open the FE.
Take a look at the properties of the icon you are using to open the BE and
copy the additional information to the other properties and see if that
helps.

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Practice on some copies to make sure you know what you are doing.

 

[Joseph Meehan]

I am joining the workgroup properly. All my permissions on the FE for
the queries, reports, etc are still intact. The only thing I lose is
my permissions for the tables on the FE.

:

Sorry, but I am out of ideas. Maybe someone else has had this problem.

 

[Joan Wild]

From your description, I surmise that you split the database manually?

When you create the links to the tables from the frontend, the links will
acquire the permissions that you have for the <new tables/queries>.

I generally give full permissions to the table links in the FE. Users will
still be restricted by their permissions on the tables in the BE.


--
Joan Wild
Microsoft Access MVP

I am joining the workgroup properly. All my permissions on the FE for
the queries, reports, etc are still intact. The only thing I lose is
my permissions for the tables on the FE.

I've done this before but now I'm having a problem splitting another
database. I currently have a secured db that I'm trying to split.
When I split the database into a FE/BE I lose all my permissions for
my tables. When I open the BE the permissions are there but when I
open the FE the permissions are gone. I have to reset all my
permissions to my tables now. Can anyone shed some light as to why
this is happening?

It sounds like you are not joining the workgroup when you open
the FE. Take a look at the properties of the icon you are using to
open the BE and copy the additional information to the other
properties and see if that helps.

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Practice on some copies to make sure you know what you are doing.