|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Workgroup file connection problem!!!Hi!
I'v got some problem concerning the connection to splitted database with created WRGRP file which is connected to the server. I created the shortcut in target wrote I "C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE"N:\ StarHolding\Databases\Access DB\Testversion.mdb"\WRKGRP"N:\StarHolding\Databases\Access DB\Security4.mdw" In start in by default: Start in:"C:\Program Files\Microsoft Office\Office12". I placed the spitted file with be extend on the server and unsecured database file plus worgroup file Security4.mdw. The other users can't logga in to database via these shortcut. What I did wrong can someone help me with advice? Otherwise the splitted database file without wrkgrp file works perfectly. I will be very appreciated for an advice. Best regards, Lilian Can't log into the database, or does the shortcut plain not work?
The quotes in what you've presented are definitely incorrect, as is the slash before WRKGRP: what you should have should be "C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "N:\ StarHolding\Databases\Access DB\Testversion.mdb" /WRKGRP"N:\StarHolding\Databases\Access DB\Security4.mdw" Of course, if your database is split, why are you opening a database on the network? Each user should have his or her own copy of the front-end on his or her hard drive. -- Show quoteHide quoteDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Lilian" <Lil***@discussions.microsoft.com> wrote in message news:DFF05FD9-56FE-4014-B8FD-20E5F777AFFF@microsoft.com... > Hi! > I'v got some problem concerning the connection to splitted database with > created WRGRP file which is connected to the server. I created the > shortcut > in target wrote I "C:\Program Files\Microsoft > Office\Office12\MSACCESS.EXE"N:\ StarHolding\Databases\Access > DB\Testversion.mdb"\WRKGRP"N:\StarHolding\Databases\Access > DB\Security4.mdw" > In start in by default: Start in:"C:\Program Files\Microsoft > Office\Office12". > > I placed the spitted file with be extend on the server and unsecured > database file plus worgroup file Security4.mdw. > The other users can't logga in to database via these shortcut. What I did > wrong can someone help me with advice? Otherwise the splitted database > file > without wrkgrp file works perfectly. > > I will be very appreciated for an advice. > Best regards, > Lilian Hi Douglas J.Steele!
When I made workgroup file with different user role and then spitted the databaseI couldnot find the front end database file which I have to install to client computers. The back end file which contains only tables I placed on server. Efter spitting the database with the workgroup file appeared only shortcut in my computer desktop, security.mdw file and bak. file wih the whole not spitted database. In my computer it was not problem to logga in via shortcut to the database. Where is the front end file? If I spitted the database without workgroup file appear both front end back end file and If I connected to client computters without workgroup file everything works the database updates and so on. But with workgroup file the front file disappears. Can somebody say to me the right procedure how to connect the font file with security.mdw to client computers? /Lilian "Douglas J. Steele" skrev: Show quoteHide quote > Can't log into the database, or does the shortcut plain not work? > > The quotes in what you've presented are definitely incorrect, as is the > slash before WRKGRP: what you should have should be > > "C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "N:\ > StarHolding\Databases\Access DB\Testversion.mdb" > /WRKGRP"N:\StarHolding\Databases\Access DB\Security4.mdw" > > Of course, if your database is split, why are you opening a database on the > network? Each user should have his or her own copy of the front-end on his > or her hard drive. > > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no private e-mails, please) > > > "Lilian" <Lil***@discussions.microsoft.com> wrote in message > news:DFF05FD9-56FE-4014-B8FD-20E5F777AFFF@microsoft.com... > > Hi! > > I'v got some problem concerning the connection to splitted database with > > created WRGRP file which is connected to the server. I created the > > shortcut > > in target wrote I "C:\Program Files\Microsoft > > Office\Office12\MSACCESS.EXE"N:\ StarHolding\Databases\Access > > DB\Testversion.mdb"\WRKGRP"N:\StarHolding\Databases\Access > > DB\Security4.mdw" > > In start in by default: Start in:"C:\Program Files\Microsoft > > Office\Office12". > > > > I placed the spitted file with be extend on the server and unsecured > > database file plus worgroup file Security4.mdw. > > The other users can't logga in to database via these shortcut. What I did > > wrong can someone help me with advice? Otherwise the splitted database > > file > > without wrkgrp file works perfectly. > > > > I will be very appreciated for an advice. > > Best regards, > > Lilian > > > I'm sorry, I'm not sure I understand what you're saying.
You should be putting a copy of the front-end database on each user's machine. The workgroup file can remain on the server. Change the details of the shortcut I indicated earlier so that it points to the front-end on the user's machine: "C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "C:\Some Folder\Testversion.mdb" /WRKGRP"N:\StarHolding\Databases\Access DB\Security4.mdw" -- Show quoteHide quoteDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Lilian" <Lil***@discussions.microsoft.com> wrote in message news:F9598916-EEA8-41A6-B83E-41A665B8E28C@microsoft.com... > Hi Douglas J.Steele! > > When I made workgroup file with different user role and then spitted the > databaseI couldnot find the front end database file which I have to > install > to client computers. The back end file which contains only tables I placed > on > server. Efter spitting the database with the workgroup file appeared only > shortcut in my computer desktop, security.mdw file and bak. file wih the > whole not spitted database. In my computer it was not problem to logga in > via > shortcut to the database. Where is the front end file? If I spitted the > database without workgroup file appear both front end back end file and If > I > connected to client computters without workgroup file everything works the > database updates and so on. But with workgroup file the front file > disappears. Can somebody say to me the right procedure how to connect the > font file with security.mdw to client computers? > /Lilian > > > "Douglas J. Steele" skrev: > >> Can't log into the database, or does the shortcut plain not work? >> >> The quotes in what you've presented are definitely incorrect, as is the >> slash before WRKGRP: what you should have should be >> >> "C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "N:\ >> StarHolding\Databases\Access DB\Testversion.mdb" >> /WRKGRP"N:\StarHolding\Databases\Access DB\Security4.mdw" >> >> Of course, if your database is split, why are you opening a database on >> the >> network? Each user should have his or her own copy of the front-end on >> his >> or her hard drive. >> >> -- >> Doug Steele, Microsoft Access MVP >> http://I.Am/DougSteele >> (no private e-mails, please) >> >> >> "Lilian" <Lil***@discussions.microsoft.com> wrote in message >> news:DFF05FD9-56FE-4014-B8FD-20E5F777AFFF@microsoft.com... >> > Hi! >> > I'v got some problem concerning the connection to splitted database >> > with >> > created WRGRP file which is connected to the server. I created the >> > shortcut >> > in target wrote I "C:\Program Files\Microsoft >> > Office\Office12\MSACCESS.EXE"N:\ StarHolding\Databases\Access >> > DB\Testversion.mdb"\WRKGRP"N:\StarHolding\Databases\Access >> > DB\Security4.mdw" >> > In start in by default: Start in:"C:\Program Files\Microsoft >> > Office\Office12". >> > >> > I placed the spitted file with be extend on the server and unsecured >> > database file plus worgroup file Security4.mdw. >> > The other users can't logga in to database via these shortcut. What I >> > did >> > wrong can someone help me with advice? Otherwise the splitted database >> > file >> > without wrkgrp file works perfectly. >> > >> > I will be very appreciated for an advice. >> > Best regards, >> > Lilian >> >> >>
secured database doesn't open on new server
User Permissions Set password for groups Securing Form Entries parental controls Avira warns of master boot sector system error Can I convert my MDE file back to MDB Database? Access 2007 security and the Access 2003 system.mdw file How do I change the user logged into MS Access? Open File - Security Warning |
|||||||||||||||||||||||