splitting a secured dbase in access 2003

[Todd]

I secured my dbase and would now like to split the dbase into FE and BE.
I've seen some instructions that suggest splitting it manually. The first
step says to copy the dbase and this will be the backend. Then it says to
open the backend (copy) and delete all objects except the tables. Problem is
that when I try to open the copy to delete the other objects I can't access
the dbase, it says I don't have the necessary permissions.

I am the creator and have admiin rights but should that matter because I'm
not prompted to login when I try to open it anyway.

How can I open the BE to delete everything exceept the tables?

 

['69 Camaro]

Hi, Todd.

I am the creator and have admiin rights but should that matter because I'm
not prompted to login when I try to open it anyway.

If you're not prompted for User ID and password when you attempt to open any
Access database (not just the secured ones), then you aren't joined to a
secured workgroup where the default Admin user has the password set.

Problem is
that when I try to open the copy to delete the other objects I can't
access
the dbase, it says I don't have the necessary permissions.

Try using a Windows shortcut that opens the secured database while pointing
to the secured workgroup so that you'll be joined to it for the current
session only. Use the following syntax for the shortcut's target (all one
line):

"<Full path to Office>\MSAccess.EXE" "<Full path to DB>\MyDB.MDB" /wrkgrp
"<Full path to secure workgroup>\Secure.MDW"

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Todd]

Thanks!
--
Todd

Hi, Todd.


If you're not prompted for User ID and password when you attempt to open any
Access database (not just the secured ones), then you aren't joined to a
secured workgroup where the default Admin user has the password set.


Try using a Windows shortcut that opens the secured database while pointing
to the secured workgroup so that you'll be joined to it for the current
session only. Use the following syntax for the shortcut's target (all one
line):

"<Full path to Office>\MSAccess.EXE" "<Full path to DB>\MyDB.MDB" /wrkgrp
"<Full path to secure workgroup>\Secure.MDW"

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

['69 Camaro]

You're welcome! I take it that it was helpful.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.