Home All Groups Group Topic Archive Search About

Workgroup file connection problem!!!

Author
25 Mar 2009 1:47 PM
Lilian
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

Author
25 Mar 2009 9:59 PM
Douglas J. Steele
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)


Show quoteHide quote
"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
Are all your drivers up to date? click for free checkup

Author
26 Mar 2009 8:05 AM
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
>
>
>
Author
26 Mar 2009 10:52 PM
Douglas J. Steele
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"


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


Show quoteHide quote
"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
>>
>>
>>

Bookmark and Share