Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem with start-up file on shared drive 1

Status
Not open for further replies.

houstonbill

Technical User
Nov 6, 2006
92
Hopefully I am posting on the right forum. For all my applications that are on a shared drive, I set up a "Start" notepad file that sets the desktop icon and puts a copy of the DB on the users "D" hard drive that downloads to the shared drive. Below is the first line of that code. At one time I was told that when setting up your code to do this, Access did not like to have spaces or certain characters in the file names. I also thought that it had been corrected with XP or Access 2003. Below is the first line of code on my Start file. As you can see, the shared drived name this department gave their folder is long, has spaces, as well as special characters within it. Using this with the balance of my code, it is setting the icon or file copy on the D drive. All names have been verified for spelling.

Is this folder name as it is set up going to prevent me from setting up my Startup file?

Copy\\Snt217\Wmiasvc\Leadership Folder-Mgr & Team Leads Only\VirtualAssist\Install\MVirtualAssist.lnk "d:\documents and settings\%username%\Desktop\
 
Try wrap the long names with space inside quotes
Code:
Copy "\\Snt217\Wmiasvc\Leadership Folder-Mgr & Team Leads Only\VirtualAssist\Install\MVirtualAssist.lnk" "d:\documents and settings\%username%\Desktop\"

Duane MS Access MVP
Now help me support United Cerebral Palsy
 
Thanks Duane, that did the trick. I thought there was a way to work around the spaces but just couldn't recall. I am currently on a medical and using this time to clean up my databases for 2008 and I can knock this off my list now.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top