splitting a database

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Hey everyone,

Two newbie questions:

1) If I split a database, How do I secure the back-end to
open with only the same workgroup file as the (previously
secured) front-end?


2) If I have secured a database for user-level security,
the Admins workgroup PID is not listed on the snapshot or
anywhere because it "was previously created". Is there any
way of finding it out afterwards? Is it necessary to know
if I want to recreate the user file?

TIA

Chris
 
Hey everyone,

Two newbie questions:

1) If I split a database, How do I secure the back-end to
open with only the same workgroup file as the (previously
secured) front-end?
Click to expand...

If you open the frontend using a particular workgroup, then the
backend will use the same workgroup. What you really need to do is to
open the backend manually with the appropriate workgroup (using a
desktop shortcut to launch Access is the easiest method) and apply
security from within that session.
2) If I have secured a database for user-level security,
the Admins workgroup PID is not listed on the snapshot or
anywhere because it "was previously created". Is there any
way of finding it out afterwards? Is it necessary to know
if I want to recreate the user file?
Click to expand...

The only way to recover PIDs is from your written records. You should
always write down the information you use to create workgroups and
accounts.

See the website in my signature for additional information.



**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
 
Hi Chris,

When you open the FrontEnd with the secured MDW file by default your are
using the same for the BackEnd. Example:

- FrontEnd Database ------- Linked to ---------> BackEnd Database

- Shortcut to open the FrontEnd Database
c:\full path to msaccess.exe "c:\FEDatabase.mdb" /wrkgrp "full path to
secured *.MDW file"

So by opening the FrontEnd database this way you are accessing the backend
database using the same secured *.MDW file.

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights



--------------------
| Content-Class: urn:content-classes:message
| From: "Chris" <[email protected]>
| Sender: "Chris" <[email protected]>
| Subject: splitting a database
| Date: Sun, 18 Jul 2004 10:10:30 -0700
| Lines: 18
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcRs6iDn6vPQ80P0SQCC6IVGVPrkjg==
| Newsgroups: microsoft.public.access.security
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.security:12192
| NNTP-Posting-Host: tk2msftngxa12.phx.gbl 10.40.1.164
| X-Tomcat-NG: microsoft.public.access.security
|
| Hey everyone,
|
| Two newbie questions:
|
| 1) If I split a database, How do I secure the back-end to
| open with only the same workgroup file as the (previously
| secured) front-end?
|
|
| 2) If I have secured a database for user-level security,
| the Admins workgroup PID is not listed on the snapshot or
| anywhere because it "was previously created". Is there any
| way of finding it out afterwards? Is it necessary to know
| if I want to recreate the user file?
|
| TIA
|
| Chris
|
 
When you open the FrontEnd with the secured MDW file by default your are
using the same for the BackEnd. Example:

- FrontEnd Database ------- Linked to ---------> BackEnd Database

- Shortcut to open the FrontEnd Database
c:\full path to msaccess.exe "c:\FEDatabase.mdb" /wrkgrp "full path to
secured *.MDW file"

So by opening the FrontEnd database this way you are accessing the backend
database using the same secured *.MDW file.
Click to expand...

Eric,
This is all true, but it doesn't address the need to secure the backend. The
user will need to open the backend directly and apply security to it.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
 
Back
Top