|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Shortcut target pathI'm having a bit of trouble here with the shortcut. If I have to write the
target path, including "path to MSACCESS.EXE" I think I have a problem. I'm not sure how to write it. my path to msaccess.exe is C:\Program Files\Microsoft Office\OFFICE11 What comes next? "Freehal04" <Freeha***@discussions.microsoft.com> wrote in message news:C313F1DF-6C75-4A2B-96C4-75FB4D5DF3C6@microsoft.com... First, put it in quotes (because the path has a space in it)> I'm having a bit of trouble here with the shortcut. If I have to write the > target path, including "path to MSACCESS.EXE" I think I have a problem. I'm > not sure how to write it. my path to msaccess.exe is C:\Program > Files\Microsoft Office\OFFICE11 "C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" "path to mdb" /wrkgrp "path to mdw" That's all on one line. -- Joan Wild Microsoft Access MVP Okay, so here is what it would look like
C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" "\\essorgfs02\Proposal_Resources\CDRL Database\CDRL123.mdb" "\\essorgfs02\Proposal_Resources\CDRL Database\CDRL123.mdw" I named my db the same as my mdw and I'm guessing that wasn't a good idea. Does the target path look right? Show quote "Joan Wild" wrote: > "Freehal04" <Freeha***@discussions.microsoft.com> wrote in message news:C313F1DF-6C75-4A2B-96C4-75FB4D5DF3C6@microsoft.com... > > I'm having a bit of trouble here with the shortcut. If I have to write the > > target path, including "path to MSACCESS.EXE" I think I have a problem. I'm > > not sure how to write it. my path to msaccess.exe is C:\Program > > Files\Microsoft Office\OFFICE11 > > First, put it in quotes (because the path has a space in it) > "C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" "path to mdb" /wrkgrp "path to mdw" > > That's all on one line. > > -- > Joan Wild > Microsoft Access MVP > Change the name of the mdw. You can just change the file name in windows explorer, and then you only need to change the shortcut - it won't affect anything else.
Your target isn't quite right. You forgot the /wrkgrp switch. It should be C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" "\\essorgfs02\Proposal_Resources\CDRL Database\CDRL123.mdb" /wrkgrp "\\essorgfs02\Proposal_Resources\CDRL Database\SomeNewName.mdw" -- Joan Wild Microsoft Access MVP Show quote "Freehal04" <Freeha***@discussions.microsoft.com> wrote in message news:03512CE5-D834-429A-ACAB-79C0CF51F7B2@microsoft.com... > Okay, so here is what it would look like > > C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" > "\\essorgfs02\Proposal_Resources\CDRL Database\CDRL123.mdb" > "\\essorgfs02\Proposal_Resources\CDRL Database\CDRL123.mdw" > > I named my db the same as my mdw and I'm guessing that wasn't a good idea. > Does the target path look right? > > "Joan Wild" wrote: > >> "Freehal04" <Freeha***@discussions.microsoft.com> wrote in message news:C313F1DF-6C75-4A2B-96C4-75FB4D5DF3C6@microsoft.com... >> > I'm having a bit of trouble here with the shortcut. If I have to write the >> > target path, including "path to MSACCESS.EXE" I think I have a problem. I'm >> > not sure how to write it. my path to msaccess.exe is C:\Program >> > Files\Microsoft Office\OFFICE11 >> >> First, put it in quotes (because the path has a space in it) >> "C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" "path to mdb" /wrkgrp "path to mdw" >> >> That's all on one line. >> >> -- >> Joan Wild >> Microsoft Access MVP >> Okay, redid the path and I got a weird error. "The name 'C:\Program'
specified in the Target box is not valid. Make sure the path and file name are correct.' This is strange because the folder on the c drive is called 'Program Files'. Why is it trying to recognize the wrong folder name? What am I missing? As always, thanks so much for your help. Show quote "Joan Wild" wrote: > Change the name of the mdw. You can just change the file name in windows explorer, and then you only need to change the shortcut - it won't affect anything else. > > Your target isn't quite right. You forgot the /wrkgrp switch. It should be > > C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" "\\essorgfs02\Proposal_Resources\CDRL Database\CDRL123.mdb" /wrkgrp "\\essorgfs02\Proposal_Resources\CDRL Database\SomeNewName.mdw" > > -- > Joan Wild > Microsoft Access MVP > "Freehal04" <Freeha***@discussions.microsoft.com> wrote in message news:03512CE5-D834-429A-ACAB-79C0CF51F7B2@microsoft.com... > > Okay, so here is what it would look like > > > > C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" > > "\\essorgfs02\Proposal_Resources\CDRL Database\CDRL123.mdb" > > "\\essorgfs02\Proposal_Resources\CDRL Database\CDRL123.mdw" > > > > I named my db the same as my mdw and I'm guessing that wasn't a good idea. > > Does the target path look right? > > > > "Joan Wild" wrote: > > > >> "Freehal04" <Freeha***@discussions.microsoft.com> wrote in message news:C313F1DF-6C75-4A2B-96C4-75FB4D5DF3C6@microsoft.com... > >> > I'm having a bit of trouble here with the shortcut. If I have to write the > >> > target path, including "path to MSACCESS.EXE" I think I have a problem. I'm > >> > not sure how to write it. my path to msaccess.exe is C:\Program > >> > Files\Microsoft Office\OFFICE11 > >> > >> First, put it in quotes (because the path has a space in it) > >> "C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" "path to mdb" /wrkgrp "path to mdw" > >> > >> That's all on one line. > >> > >> -- > >> Joan Wild > >> Microsoft Access MVP > >> > You need to enclose each path in double quotes
"C:\Program Files\..." Looks like I missed the initial double quote below. -- Joan Wild Microsoft Access MVP Show quote "Freehal04" <Freeha***@discussions.microsoft.com> wrote in message news:4C01D204-1175-4563-A37F-65630529DCDB@microsoft.com... > Okay, redid the path and I got a weird error. "The name 'C:\Program' > specified in the Target box is not valid. Make sure the path and file name > are correct.' > > This is strange because the folder on the c drive is called 'Program Files'. > Why is it trying to recognize the wrong folder name? What am I missing? As > always, thanks so much for your help. > > "Joan Wild" wrote: > >> Change the name of the mdw. You can just change the file name in windows explorer, and then you only need to change the shortcut - it won't affect anything else. >> >> Your target isn't quite right. You forgot the /wrkgrp switch. It should be >> >> C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" "\\essorgfs02\Proposal_Resources\CDRL Database\CDRL123.mdb" /wrkgrp "\\essorgfs02\Proposal_Resources\CDRL Database\SomeNewName.mdw" >> >> -- >> Joan Wild >> Microsoft Access MVP >> "Freehal04" <Freeha***@discussions.microsoft.com> wrote in message news:03512CE5-D834-429A-ACAB-79C0CF51F7B2@microsoft.com... >> > Okay, so here is what it would look like >> > >> > C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" >> > "\\essorgfs02\Proposal_Resources\CDRL Database\CDRL123.mdb" >> > "\\essorgfs02\Proposal_Resources\CDRL Database\CDRL123.mdw" >> > >> > I named my db the same as my mdw and I'm guessing that wasn't a good idea. >> > Does the target path look right? >> > >> > "Joan Wild" wrote: >> > >> >> "Freehal04" <Freeha***@discussions.microsoft.com> wrote in message news:C313F1DF-6C75-4A2B-96C4-75FB4D5DF3C6@microsoft.com... >> >> > I'm having a bit of trouble here with the shortcut. If I have to write the >> >> > target path, including "path to MSACCESS.EXE" I think I have a problem. I'm >> >> > not sure how to write it. my path to msaccess.exe is C:\Program >> >> > Files\Microsoft Office\OFFICE11 >> >> >> >> First, put it in quotes (because the path has a space in it) >> >> "C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" "path to mdb" /wrkgrp "path to mdw" >> >> >> >> That's all on one line. >> >> >> >> -- >> >> Joan Wild >> >> Microsoft Access MVP >> >> >> OMG! It finally works!!!!! I thought this day would never come. I guess
now all I have to do is split it. For right now i only have 1 user. Do you recomend splitting it now, or waiting until my beta testing with my one user is over? Show quote "Joan Wild" wrote: > You need to enclose each path in double quotes > "C:\Program Files\..." > Looks like I missed the initial double quote below. > > -- > Joan Wild > Microsoft Access MVP > "Freehal04" <Freeha***@discussions.microsoft.com> wrote in message news:4C01D204-1175-4563-A37F-65630529DCDB@microsoft.com... > > Okay, redid the path and I got a weird error. "The name 'C:\Program' > > specified in the Target box is not valid. Make sure the path and file name > > are correct.' > > > > This is strange because the folder on the c drive is called 'Program Files'. > > Why is it trying to recognize the wrong folder name? What am I missing? As > > always, thanks so much for your help. > > > > "Joan Wild" wrote: > > > >> Change the name of the mdw. You can just change the file name in windows explorer, and then you only need to change the shortcut - it won't affect anything else. > >> > >> Your target isn't quite right. You forgot the /wrkgrp switch. It should be > >> > >> C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" "\\essorgfs02\Proposal_Resources\CDRL Database\CDRL123.mdb" /wrkgrp "\\essorgfs02\Proposal_Resources\CDRL Database\SomeNewName.mdw" > >> > >> -- > >> Joan Wild > >> Microsoft Access MVP > >> "Freehal04" <Freeha***@discussions.microsoft.com> wrote in message news:03512CE5-D834-429A-ACAB-79C0CF51F7B2@microsoft.com... > >> > Okay, so here is what it would look like > >> > > >> > C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" > >> > "\\essorgfs02\Proposal_Resources\CDRL Database\CDRL123.mdb" > >> > "\\essorgfs02\Proposal_Resources\CDRL Database\CDRL123.mdw" > >> > > >> > I named my db the same as my mdw and I'm guessing that wasn't a good idea. > >> > Does the target path look right? > >> > > >> > "Joan Wild" wrote: > >> > > >> >> "Freehal04" <Freeha***@discussions.microsoft.com> wrote in message news:C313F1DF-6C75-4A2B-96C4-75FB4D5DF3C6@microsoft.com... > >> >> > I'm having a bit of trouble here with the shortcut. If I have to write the > >> >> > target path, including "path to MSACCESS.EXE" I think I have a problem. I'm > >> >> > not sure how to write it. my path to msaccess.exe is C:\Program > >> >> > Files\Microsoft Office\OFFICE11 > >> >> > >> >> First, put it in quotes (because the path has a space in it) > >> >> "C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" "path to mdb" /wrkgrp "path to mdw" > >> >> > >> >> That's all on one line. > >> >> > >> >> -- > >> >> Joan Wild > >> >> Microsoft Access MVP > >> >> > >> > I would split it now. Split it manually - don't use the splitter wizard, as that will leave the backend unsecured.
See www.jmwild.com/SplitSecure.htm for instructions. Be sure to put the frontend on each person's computer (adjust their shortcut target to point to the location of the frontend mdb on their computer). You may (but not likely) have to modify the path to the msaccess.exe file if it differs on each machine. Put the mdw in the same location as the backend. -- Joan Wild Microsoft Access MVP Show quote "Freehal04" <Freeha***@discussions.microsoft.com> wrote in message news:9F1C3904-7B2D-471C-99E3-DA2121C9B6A5@microsoft.com... > OMG! It finally works!!!!! I thought this day would never come. I guess > now all I have to do is split it. For right now i only have 1 user. Do you > recomend splitting it now, or waiting until my beta testing with my one user > is over? > > "Joan Wild" wrote: > >> You need to enclose each path in double quotes >> "C:\Program Files\..." >> Looks like I missed the initial double quote below. >> >> -- >> Joan Wild >> Microsoft Access MVP >> "Freehal04" <Freeha***@discussions.microsoft.com> wrote in message news:4C01D204-1175-4563-A37F-65630529DCDB@microsoft.com... >> > Okay, redid the path and I got a weird error. "The name 'C:\Program' >> > specified in the Target box is not valid. Make sure the path and file name >> > are correct.' >> > >> > This is strange because the folder on the c drive is called 'Program Files'. >> > Why is it trying to recognize the wrong folder name? What am I missing? As >> > always, thanks so much for your help. >> > >> > "Joan Wild" wrote: >> > >> >> Change the name of the mdw. You can just change the file name in windows explorer, and then you only need to change the shortcut - it won't affect anything else. >> >> >> >> Your target isn't quite right. You forgot the /wrkgrp switch. It should be >> >> >> >> C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" "\\essorgfs02\Proposal_Resources\CDRL Database\CDRL123.mdb" /wrkgrp "\\essorgfs02\Proposal_Resources\CDRL Database\SomeNewName.mdw" >> >> >> >> -- >> >> Joan Wild >> >> Microsoft Access MVP >> >> "Freehal04" <Freeha***@discussions.microsoft.com> wrote in message news:03512CE5-D834-429A-ACAB-79C0CF51F7B2@microsoft.com... >> >> > Okay, so here is what it would look like >> >> > >> >> > C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" >> >> > "\\essorgfs02\Proposal_Resources\CDRL Database\CDRL123.mdb" >> >> > "\\essorgfs02\Proposal_Resources\CDRL Database\CDRL123.mdw" >> >> > >> >> > I named my db the same as my mdw and I'm guessing that wasn't a good idea. >> >> > Does the target path look right? >> >> > >> >> > "Joan Wild" wrote: >> >> > >> >> >> "Freehal04" <Freeha***@discussions.microsoft.com> wrote in message news:C313F1DF-6C75-4A2B-96C4-75FB4D5DF3C6@microsoft.com... >> >> >> > I'm having a bit of trouble here with the shortcut. If I have to write the >> >> >> > target path, including "path to MSACCESS.EXE" I think I have a problem. I'm >> >> >> > not sure how to write it. my path to msaccess.exe is C:\Program >> >> >> > Files\Microsoft Office\OFFICE11 >> >> >> >> >> >> First, put it in quotes (because the path has a space in it) >> >> >> "C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" "path to mdb" /wrkgrp "path to mdw" >> >> >> >> >> >> That's all on one line. >> >> >> >> >> >> -- >> >> >> Joan Wild >> >> >> Microsoft Access MVP >> >> >> >> >> >> so if I split the DB and have the user save the front end on their C drive
the path would look like this? "C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" "C:\CDRL123.mdb" /wrkgrp "\\essorgfs02\Proposal_Resources\CDRL Database\CDRLSecurity.mdw" Show quote "Joan Wild" wrote: > I would split it now. Split it manually - don't use the splitter wizard, as that will leave the backend unsecured. > > See www.jmwild.com/SplitSecure.htm for instructions. > > Be sure to put the frontend on each person's computer (adjust their shortcut target to point to the location of the frontend mdb on their computer). You may (but not likely) have to modify the path to the msaccess.exe file if it differs on each machine. Put the mdw in the same location as the backend. > > -- > Joan Wild > Microsoft Access MVP > "Freehal04" <Freeha***@discussions.microsoft.com> wrote in message news:9F1C3904-7B2D-471C-99E3-DA2121C9B6A5@microsoft.com... > > OMG! It finally works!!!!! I thought this day would never come. I guess > > now all I have to do is split it. For right now i only have 1 user. Do you > > recomend splitting it now, or waiting until my beta testing with my one user > > is over? > > > > "Joan Wild" wrote: > > > >> You need to enclose each path in double quotes > >> "C:\Program Files\..." > >> Looks like I missed the initial double quote below. > >> > >> -- > >> Joan Wild > >> Microsoft Access MVP > >> "Freehal04" <Freeha***@discussions.microsoft.com> wrote in message news:4C01D204-1175-4563-A37F-65630529DCDB@microsoft.com... > >> > Okay, redid the path and I got a weird error. "The name 'C:\Program' > >> > specified in the Target box is not valid. Make sure the path and file name > >> > are correct.' > >> > > >> > This is strange because the folder on the c drive is called 'Program Files'. > >> > Why is it trying to recognize the wrong folder name? What am I missing? As > >> > always, thanks so much for your help. > >> > > >> > "Joan Wild" wrote: > >> > > >> >> Change the name of the mdw. You can just change the file name in windows explorer, and then you only need to change the shortcut - it won't affect anything else. > >> >> > >> >> Your target isn't quite right. You forgot the /wrkgrp switch. It should be > >> >> > >> >> C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" "\\essorgfs02\Proposal_Resources\CDRL Database\CDRL123.mdb" /wrkgrp "\\essorgfs02\Proposal_Resources\CDRL Database\SomeNewName.mdw" > >> >> > >> >> -- > >> >> Joan Wild > >> >> Microsoft Access MVP > >> >> "Freehal04" <Freeha***@discussions.microsoft.com> wrote in message news:03512CE5-D834-429A-ACAB-79C0CF51F7B2@microsoft.com... > >> >> > Okay, so here is what it would look like > >> >> > > >> >> > C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" > >> >> > "\\essorgfs02\Proposal_Resources\CDRL Database\CDRL123.mdb" > >> >> > "\\essorgfs02\Proposal_Resources\CDRL Database\CDRL123.mdw" > >> >> > > >> >> > I named my db the same as my mdw and I'm guessing that wasn't a good idea. > >> >> > Does the target path look right? > >> >> > > >> >> > "Joan Wild" wrote: > >> >> > > >> >> >> "Freehal04" <Freeha***@discussions.microsoft.com> wrote in message news:C313F1DF-6C75-4A2B-96C4-75FB4D5DF3C6@microsoft.com... > >> >> >> > I'm having a bit of trouble here with the shortcut. If I have to write the > >> >> >> > target path, including "path to MSACCESS.EXE" I think I have a problem. I'm > >> >> >> > not sure how to write it. my path to msaccess.exe is C:\Program > >> >> >> > Files\Microsoft Office\OFFICE11 > >> >> >> > >> >> >> First, put it in quotes (because the path has a space in it) > >> >> >> "C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" "path to mdb" /wrkgrp "path to mdw" > >> >> >> > >> >> >> That's all on one line. > >> >> >> > >> >> >> -- > >> >> >> Joan Wild > >> >> >> Microsoft Access MVP > >> >> >> > >> >> > >> > Yes.
-- Joan Wild Microsoft Access MVP Show quote "Freehal04" <Freeha***@discussions.microsoft.com> wrote in message news:3C0EC20D-1FBB-44C6-8A8E-6A676D4BFCD4@microsoft.com... > so if I split the DB and have the user save the front end on their C drive > the path would look like this? > "C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" "C:\CDRL123.mdb" > /wrkgrp "\\essorgfs02\Proposal_Resources\CDRL Database\CDRLSecurity.mdw" > > > "Joan Wild" wrote: > >> I would split it now. Split it manually - don't use the splitter wizard, as that will leave the backend unsecured. >> >> See www.jmwild.com/SplitSecure.htm for instructions. >> >> Be sure to put the frontend on each person's computer (adjust their shortcut target to point to the location of the frontend mdb on their computer). You may (but not likely) have to modify the path to the msaccess.exe file if it differs on each machine. Put the mdw in the same location as the backend. >> >> -- >> Joan Wild >> Microsoft Access MVP >> "Freehal04" <Freeha***@discussions.microsoft.com> wrote in message news:9F1C3904-7B2D-471C-99E3-DA2121C9B6A5@microsoft.com... >> > OMG! It finally works!!!!! I thought this day would never come. I guess >> > now all I have to do is split it. For right now i only have 1 user. Do you >> > recomend splitting it now, or waiting until my beta testing with my one user >> > is over? >> > >> > "Joan Wild" wrote: >> > >> >> You need to enclose each path in double quotes >> >> "C:\Program Files\..." >> >> Looks like I missed the initial double quote below. >> >> >> >> -- >> >> Joan Wild >> >> Microsoft Access MVP >> >> "Freehal04" <Freeha***@discussions.microsoft.com> wrote in message news:4C01D204-1175-4563-A37F-65630529DCDB@microsoft.com... >> >> > Okay, redid the path and I got a weird error. "The name 'C:\Program' >> >> > specified in the Target box is not valid. Make sure the path and file name >> >> > are correct.' >> >> > >> >> > This is strange because the folder on the c drive is called 'Program Files'. >> >> > Why is it trying to recognize the wrong folder name? What am I missing? As >> >> > always, thanks so much for your help. >> >> > >> >> > "Joan Wild" wrote: >> >> > >> >> >> Change the name of the mdw. You can just change the file name in windows explorer, and then you only need to change the shortcut - it won't affect anything else. >> >> >> >> >> >> Your target isn't quite right. You forgot the /wrkgrp switch. It should be >> >> >> >> >> >> C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" "\\essorgfs02\Proposal_Resources\CDRL Database\CDRL123.mdb" /wrkgrp "\\essorgfs02\Proposal_Resources\CDRL Database\SomeNewName.mdw" >> >> >> >> >> >> -- >> >> >> Joan Wild >> >> >> Microsoft Access MVP >> >> >> "Freehal04" <Freeha***@discussions.microsoft.com> wrote in message news:03512CE5-D834-429A-ACAB-79C0CF51F7B2@microsoft.com... >> >> >> > Okay, so here is what it would look like >> >> >> > >> >> >> > C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" >> >> >> > "\\essorgfs02\Proposal_Resources\CDRL Database\CDRL123.mdb" >> >> >> > "\\essorgfs02\Proposal_Resources\CDRL Database\CDRL123.mdw" >> >> >> > >> >> >> > I named my db the same as my mdw and I'm guessing that wasn't a good idea. >> >> >> > Does the target path look right? >> >> >> > >> >> >> > "Joan Wild" wrote: >> >> >> > >> >> >> >> "Freehal04" <Freeha***@discussions.microsoft.com> wrote in message news:C313F1DF-6C75-4A2B-96C4-75FB4D5DF3C6@microsoft.com... >> >> >> >> > I'm having a bit of trouble here with the shortcut. If I have to write the >> >> >> >> > target path, including "path to MSACCESS.EXE" I think I have a problem. I'm >> >> >> >> > not sure how to write it. my path to msaccess.exe is C:\Program >> >> >> >> > Files\Microsoft Office\OFFICE11 >> >> >> >> >> >> >> >> First, put it in quotes (because the path has a space in it) >> >> >> >> "C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" "path to mdb" /wrkgrp "path to mdw" >> >> >> >> >> >> >> >> That's all on one line. >> >> >> >> >> >> >> >> -- >> >> >> >> Joan Wild >> >> >> >> Microsoft Access MVP >> >> >> >> >> >> >> >> >> >> Thank you so much for all your help Joan. It goes without saying, I couldn't
have done it without you. Show quote "Joan Wild" wrote: > Yes. > > -- > Joan Wild > Microsoft Access MVP > "Freehal04" <Freeha***@discussions.microsoft.com> wrote in message news:3C0EC20D-1FBB-44C6-8A8E-6A676D4BFCD4@microsoft.com... > > so if I split the DB and have the user save the front end on their C drive > > the path would look like this? > > "C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" "C:\CDRL123.mdb" > > /wrkgrp "\\essorgfs02\Proposal_Resources\CDRL Database\CDRLSecurity.mdw" > > > > > > "Joan Wild" wrote: > > > >> I would split it now. Split it manually - don't use the splitter wizard, as that will leave the backend unsecured. > >> > >> See www.jmwild.com/SplitSecure.htm for instructions. > >> > >> Be sure to put the frontend on each person's computer (adjust their shortcut target to point to the location of the frontend mdb on their computer). You may (but not likely) have to modify the path to the msaccess.exe file if it differs on each machine. Put the mdw in the same location as the backend. > >> > >> -- > >> Joan Wild > >> Microsoft Access MVP > >> "Freehal04" <Freeha***@discussions.microsoft.com> wrote in message news:9F1C3904-7B2D-471C-99E3-DA2121C9B6A5@microsoft.com... > >> > OMG! It finally works!!!!! I thought this day would never come. I guess > >> > now all I have to do is split it. For right now i only have 1 user. Do you > >> > recomend splitting it now, or waiting until my beta testing with my one user > >> > is over? > >> > > >> > "Joan Wild" wrote: > >> > > >> >> You need to enclose each path in double quotes > >> >> "C:\Program Files\..." > >> >> Looks like I missed the initial double quote below. > >> >> > >> >> -- > >> >> Joan Wild > >> >> Microsoft Access MVP > >> >> "Freehal04" <Freeha***@discussions.microsoft.com> wrote in message news:4C01D204-1175-4563-A37F-65630529DCDB@microsoft.com... > >> >> > Okay, redid the path and I got a weird error. "The name 'C:\Program' > >> >> > specified in the Target box is not valid. Make sure the path and file name > >> >> > are correct.' > >> >> > > >> >> > This is strange because the folder on the c drive is called 'Program Files'. > >> >> > Why is it trying to recognize the wrong folder name? What am I missing? As > >> >> > always, thanks so much for your help. > >> >> > > >> >> > "Joan Wild" wrote: > >> >> > > >> >> >> Change the name of the mdw. You can just change the file name in windows explorer, and then you only need to change the shortcut - it won't affect anything else. > >> >> >> > >> >> >> Your target isn't quite right. You forgot the /wrkgrp switch. It should be > >> >> >> > >> >> >> C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" "\\essorgfs02\Proposal_Resources\CDRL Database\CDRL123.mdb" /wrkgrp "\\essorgfs02\Proposal_Resources\CDRL Database\SomeNewName.mdw" > >> >> >> > >> >> >> -- > >> >> >> Joan Wild > >> >> >> Microsoft Access MVP > >> >> >> "Freehal04" <Freeha***@discussions.microsoft.com> wrote in message news:03512CE5-D834-429A-ACAB-79C0CF51F7B2@microsoft.com... > >> >> >> > Okay, so here is what it would look like > >> >> >> > > >> >> >> > C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" > >> >> >> > "\\essorgfs02\Proposal_Resources\CDRL Database\CDRL123.mdb" > >> >> >> > "\\essorgfs02\Proposal_Resources\CDRL Database\CDRL123.mdw" > >> >> >> > > >> >> >> > I named my db the same as my mdw and I'm guessing that wasn't a good idea. > >> >> >> > Does the target path look right? > >> >> >> > > >> >> >> > "Joan Wild" wrote: > >> >> >> > > >> >> >> >> "Freehal04" <Freeha***@discussions.microsoft.com> wrote in message news:C313F1DF-6C75-4A2B-96C4-75FB4D5DF3C6@microsoft.com... > >> >> >> >> > I'm having a bit of trouble here with the shortcut. If I have to write the > >> >> >> >> > target path, including "path to MSACCESS.EXE" I think I have a problem. I'm > >> >> >> >> > not sure how to write it. my path to msaccess.exe is C:\Program > >> >> >> >> > Files\Microsoft Office\OFFICE11 > >> >> >> >> > >> >> >> >> First, put it in quotes (because the path has a space in it) > >> >> >> >> "C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" "path to mdb" /wrkgrp "path to mdw" > >> >> >> >> > >> >> >> >> That's all on one line. > >> >> >> >> > >> >> >> >> -- > >> >> >> >> Joan Wild > >> >> >> >> Microsoft Access MVP > >> >> >> >> > >> >> >> > >> >> > >> >  |
|||||||||||||||||||||||
Other interesting topics