PC Review


Reply
Thread Tools Rate Thread

Correct syntax to join a specific MDW

 
 
JTB
Guest
Posts: n/a
 
      3rd Sep 2003
I'm working on a locked down workstation that will not
keep my setings when I change to a different mdw. I set
it in the morning but when I login again the next day it
defaults the the standard Access mdw file. I was told
that if I create a shortcut on my desktop and added the
location of the mdw I want to join I wouldn't have go
throught the hassle of re-join the mdw every morning.

Can someone help with the correct syntax?

Thanks
 
Reply With Quote
 
 
 
 
Rick Brandt
Guest
Posts: n/a
 
      3rd Sep 2003
"JTB" <(E-Mail Removed)> wrote in message
news:11c201c37252$a50ea130$(E-Mail Removed)...
> I'm working on a locked down workstation that will not
> keep my setings when I change to a different mdw. I set
> it in the morning but when I login again the next day it
> defaults the the standard Access mdw file. I was told
> that if I create a shortcut on my desktop and added the
> location of the mdw I want to join I wouldn't have go
> throught the hassle of re-join the mdw every morning.
>


"Full path to MSAccess.exe" /wrkgrp "Full path to mdw file" "full path to mdb file"


 
Reply With Quote
 
Rick Brandt
Guest
Posts: n/a
 
      4th Sep 2003
I don't think it matters. Other than the path to the executable being first.

"Scott McDaniel" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I thought that the correct syntax was:
>
> "Path to MSAccess.exe" "Path to MDB file" /wrkgrp "Path to workgroup file"
>
> Does it work both ways?
>
> "Rick Brandt" <(E-Mail Removed)> wrote in message
> news:bj5n2k$fnmgn$(E-Mail Removed)...
> > "JTB" <(E-Mail Removed)> wrote in message
> > news:11c201c37252$a50ea130$(E-Mail Removed)...
> > > I'm working on a locked down workstation that will not
> > > keep my setings when I change to a different mdw. I set
> > > it in the morning but when I login again the next day it
> > > defaults the the standard Access mdw file. I was told
> > > that if I create a shortcut on my desktop and added the
> > > location of the mdw I want to join I wouldn't have go
> > > throught the hassle of re-join the mdw every morning.
> > >

> >
> > "Full path to MSAccess.exe" /wrkgrp "Full path to mdw file" "full path to

> mdb file"
> >
> >

>
>



 
Reply With Quote
 
Joan Wild
Guest
Posts: n/a
 
      4th Sep 2003
True. For some of the switches, the order matters, but not in this case.

--
Joan Wild
Microsoft Access MVP

"Rick Brandt" <(E-Mail Removed)> wrote in message
news:bj7cds$fpch2$(E-Mail Removed)...
> I don't think it matters. Other than the path to the executable being

first.
>
> "Scott McDaniel" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > I thought that the correct syntax was:
> >
> > "Path to MSAccess.exe" "Path to MDB file" /wrkgrp "Path to workgroup

file"
> >
> > Does it work both ways?
> >



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL VBA -- INNER JOIN Syntax amywolfie Microsoft Access 6 6th Jun 2011 08:15 PM
WHERE syntax v. JOIN ON syntax Siegfried Heintze Microsoft Access Database Table Design 8 17th Dec 2007 01:30 PM
dlookup syntax on self join =?Utf-8?B?dHVya2V5?= Microsoft Access Queries 3 22nd May 2006 04:27 PM
sql union self-join syntax SillySally Microsoft Access Queries 27 18th Mar 2005 03:25 AM
mistake in the syntax inner join Frank Dulk Microsoft Access Queries 1 22nd Oct 2003 06:36 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:29 PM.