Keith Nichols
Registered User.
- Local time
- Today, 20:35
- Joined
- Jan 27, 2006
- Messages
- 431
Hi Folks,
This may not be an Access problem per se, and if not, I appologize in advance.
I have a FE/BE split database with multiple users. I have found out how to add a command line switch to the shortcuts (the shortcut must go to the application first for any switches to work) which opens the database front end nicely. Problem is, I can't get it to connect to the appropriate WIF.
I have tried copying the text from "Microsoft Access Inside Out" which didn't work as it has "/wrkgroup" rather than "/wrkgrp". My set up wouldn't accept that.
Anyway I'm half way there but stuck now. I don't get any error messages when I use the shortcuts but Access stays joined to whatever WIF it was connected to the last time it was running.
I have searched this site but couldn't find anything regarding this specific problem, in the recent past at least.
Any ideas what I'm doing wrong?
I have copied the details from the 2 shortcuts below. The first is to my database and the networked WIF, the second to Access to return the desktop PC to the default WIF. I have also added the Access version number and operating system version numbers.
This is the shortcut to my database with the workgroup switch set to the WIF created for this database:
Target:
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\EDT DB\WC-ED0023001R0.02a-fe.mdb" /wrkgrp "K:\EDT FOLDER\EDT DB\ED.00.23.001_WIF.mdw"
Start In:
"C:\Program Files\Microsoft Office\OFFICE11"
Network Drive WIF Path:
K:\EDT FOLDER\EDT DB\ED.00.23.001_WIF.mdw
This shortcut is supposed to restore Access to the default WIF on the desktop PC:
Target:
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" /wrkgrp "C:\Documents and Settings\QPUser\Application Data\Microsoft\Access\System.mdw"
Start In:
"C:\Program Files\Microsoft Office\OFFICE11"
Desktop WIF Path:
C:\Documents and Settings\QPUser\Application Data\Microsoft\Access\System.mdw
Access path:
C:\Program Files\Microsoft Office\OFFICE11\Access.exe
Access Version:
2003 (11.6355.6408) SP1
Environment:
OS Name Microsoft Windows XP Professional
Version 5.1.2600 Service Pack 1 Build 2600
Thanks in advance,
Keith.
This may not be an Access problem per se, and if not, I appologize in advance.
I have a FE/BE split database with multiple users. I have found out how to add a command line switch to the shortcuts (the shortcut must go to the application first for any switches to work) which opens the database front end nicely. Problem is, I can't get it to connect to the appropriate WIF.
I have tried copying the text from "Microsoft Access Inside Out" which didn't work as it has "/wrkgroup" rather than "/wrkgrp". My set up wouldn't accept that.
Anyway I'm half way there but stuck now. I don't get any error messages when I use the shortcuts but Access stays joined to whatever WIF it was connected to the last time it was running.
I have searched this site but couldn't find anything regarding this specific problem, in the recent past at least.
Any ideas what I'm doing wrong?
I have copied the details from the 2 shortcuts below. The first is to my database and the networked WIF, the second to Access to return the desktop PC to the default WIF. I have also added the Access version number and operating system version numbers.
This is the shortcut to my database with the workgroup switch set to the WIF created for this database:
Target:
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\EDT DB\WC-ED0023001R0.02a-fe.mdb" /wrkgrp "K:\EDT FOLDER\EDT DB\ED.00.23.001_WIF.mdw"
Start In:
"C:\Program Files\Microsoft Office\OFFICE11"
Network Drive WIF Path:
K:\EDT FOLDER\EDT DB\ED.00.23.001_WIF.mdw
This shortcut is supposed to restore Access to the default WIF on the desktop PC:
Target:
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" /wrkgrp "C:\Documents and Settings\QPUser\Application Data\Microsoft\Access\System.mdw"
Start In:
"C:\Program Files\Microsoft Office\OFFICE11"
Desktop WIF Path:
C:\Documents and Settings\QPUser\Application Data\Microsoft\Access\System.mdw
Access path:
C:\Program Files\Microsoft Office\OFFICE11\Access.exe
Access Version:
2003 (11.6355.6408) SP1
Environment:
OS Name Microsoft Windows XP Professional
Version 5.1.2600 Service Pack 1 Build 2600
Thanks in advance,
Keith.