|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Shared mdwHow do you force two or more mdb's to share a single mdw via shortcuts
(without joining a default workgroup)? Thanks in advance! -- Brad. Hi, Brad.
> How do you force two or more mdb's to share a single mdw via shortcuts Each Windows shortcut should use the same path and file name for the secure > (without joining a default workgroup)? workgroup file and use the following syntax (watch out for word wrap, as the shortcut should be all one line): (MyDB.mdb shortcut:) "C:\Program Files\Microsoft Office\OFFICE\MSAccess.exe" "C:\Data\MyDB.mdb" /wrkgrp "C:\Data\Secure.mdw" ---------------------------------- (OtherDB.mdb shortcut:) "C:\Program Files\Microsoft Office\OFFICE\MSAccess.exe" "C:\Data\OtherDB.mdb" /wrkgrp "C:\Data\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. http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info. Show quoteHide quote "Brad Hodge" wrote: > How do you force two or more mdb's to share a single mdw via shortcuts > (without joining a default workgroup)? > > Thanks in advance! > -- > Brad. Thanks for your reply. That method will send the other database through the
security file, but it doesn't actually secure that database (you can still open the database by just clicking on it instead of going through the shortcut). I've tried adding a password to the Admin user and then taking away all User group priviledges, but this just adds my PC to the workgroup, and does nothing for network PCs that also use these databases. I guess I need the other database to both go through the workgroup AND deliver the message "You do not have the necessary permissions to use..." when someone clicks on the database itself. Hope that clarifies. -- Show quoteHide quoteBrad. "'69 Camaro" wrote: > Hi, Brad. > > > How do you force two or more mdb's to share a single mdw via shortcuts > > (without joining a default workgroup)? > > Each Windows shortcut should use the same path and file name for the secure > workgroup file and use the following syntax (watch out for word wrap, as the > shortcut should be all one line): > > (MyDB.mdb shortcut:) > > "C:\Program Files\Microsoft Office\OFFICE\MSAccess.exe" "C:\Data\MyDB.mdb" > /wrkgrp "C:\Data\Secure.mdw" > > ---------------------------------- > > (OtherDB.mdb shortcut:) > > "C:\Program Files\Microsoft Office\OFFICE\MSAccess.exe" > "C:\Data\OtherDB.mdb" /wrkgrp "C:\Data\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. > http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info. > > > "Brad Hodge" wrote: > > > How do you force two or more mdb's to share a single mdw via shortcuts > > (without joining a default workgroup)? > > > > Thanks in advance! > > -- > > Brad. If your users can open the database by double clicking on it in windows
explorer, then you haven't completely secured the database. Get a copy of the Security FAQ, read it several times, and follow it to the letter. There is a link to it on the Security page of my website. Show quoteHide quote "Brad Hodge" <BradHo***@discussions.microsoft.com> wrote in message news:E6F1DC75-ECF3-49FE-9825-1115D4F62168@microsoft.com... > Thanks for your reply. That method will send the other database through > the > security file, but it doesn't actually secure that database (you can still > open the database by just clicking on it instead of going through the > shortcut). > > I've tried adding a password to the Admin user and then taking away all > User > group priviledges, but this just adds my PC to the workgroup, and does > nothing for network PCs that also use these databases. > > I guess I need the other database to both go through the workgroup AND > deliver the message "You do not have the necessary permissions to use..." > when someone clicks on the database itself. > > Hope that clarifies. > -- > Brad. > > > "'69 Camaro" wrote: > >> Hi, Brad. >> >> > How do you force two or more mdb's to share a single mdw via shortcuts >> > (without joining a default workgroup)? >> >> Each Windows shortcut should use the same path and file name for the >> secure >> workgroup file and use the following syntax (watch out for word wrap, as >> the >> shortcut should be all one line): >> >> (MyDB.mdb shortcut:) >> >> "C:\Program Files\Microsoft Office\OFFICE\MSAccess.exe" >> "C:\Data\MyDB.mdb" >> /wrkgrp "C:\Data\Secure.mdw" >> >> ---------------------------------- >> >> (OtherDB.mdb shortcut:) >> >> "C:\Program Files\Microsoft Office\OFFICE\MSAccess.exe" >> "C:\Data\OtherDB.mdb" /wrkgrp "C:\Data\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. >> http://www.Access.QBuilt.com/html/expert_contributors2.html for contact >> info. >> >> >> "Brad Hodge" wrote: >> >> > How do you force two or more mdb's to share a single mdw via shortcuts >> > (without joining a default workgroup)? >> > >> > Thanks in advance! >> > -- >> > Brad. Brad, once you open the 'other' database via the shortcut, you then need to
proceed to secure it. The secure mdw will be in use at that point (which is what you want). So once you login via that shortcut, create a new mdb and import all objects from your mdb and then proceed to remove all permissions from the Users Group. Then assign the necessary permissions to the groups you have in your secure mdw. Access always has some mdw set as the default. You'll want system.mdw set as the default (that is the mdw that ships with Access). If you set a password on Admin in this mdw, remove it and you won't be asked for a username/password for all sessions of Access. For your secure mdbs, you'd use the desktop shortcut. -- Show quoteHide quoteJoan Wild Microsoft Access MVP Brad Hodge wrote: > Thanks for your reply. That method will send the other database > through the security file, but it doesn't actually secure that > database (you can still open the database by just clicking on it > instead of going through the shortcut). > > I've tried adding a password to the Admin user and then taking away > all User group priviledges, but this just adds my PC to the > workgroup, and does nothing for network PCs that also use these > databases. > > I guess I need the other database to both go through the workgroup AND > deliver the message "You do not have the necessary permissions to > use..." when someone clicks on the database itself. > > Hope that clarifies. > -- > Brad. > > > "'69 Camaro" wrote: > >> Hi, Brad. >> >>> How do you force two or more mdb's to share a single mdw via >>> shortcuts (without joining a default workgroup)? >> >> Each Windows shortcut should use the same path and file name for the >> secure workgroup file and use the following syntax (watch out for >> word wrap, as the shortcut should be all one line): >> >> (MyDB.mdb shortcut:) >> >> "C:\Program Files\Microsoft Office\OFFICE\MSAccess.exe" >> "C:\Data\MyDB.mdb" /wrkgrp "C:\Data\Secure.mdw" >> >> ---------------------------------- >> >> (OtherDB.mdb shortcut:) >> >> "C:\Program Files\Microsoft Office\OFFICE\MSAccess.exe" >> "C:\Data\OtherDB.mdb" /wrkgrp "C:\Data\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. >> http://www.Access.QBuilt.com/html/expert_contributors2.html for >> contact info. >> >> >> "Brad Hodge" wrote: >> >>> How do you force two or more mdb's to share a single mdw via >>> shortcuts (without joining a default workgroup)? >>> >>> Thanks in advance! >>> -- >>> Brad. Thanks to Lynn for the advice on the Access Security FAQ. I gained lots of
insight into the detailed workings of user level security. I also gained a lot by looking at all the links on your website :) And... Thanks to Joan for the information on importing from from within the mdw and then removing User rights to get the 2 databases to share the mdw. IT WORKED GREAT! This is going to save us a lot of time. -- Show quoteHide quoteBrad. "Brad Hodge" wrote: > How do you force two or more mdb's to share a single mdw via shortcuts > (without joining a default workgroup)? > > Thanks in advance! > -- > Brad. 
Other interesting topics
|
|||||||||||||||||||||||
