Computing.Net > Forums > Database > Linking icon to Access db

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Linking icon to Access db

Reply to Message Icon

Name: rohnds
Date: June 15, 2007 at 15:19:26 Pacific
OS: WinXP
CPU/Ram: 1
Product: Intel
Comment:

I have a small database that I created using MS Access and I want to distribute this among my friends (aquarium enthusiasts). So I created EXE file using WinZip 11.0.

When the users unzip the files, database and other files (such as photos, icon and help file) are written to a new sub directory.

I want to make this a little more professional. I want to be able to create a icon on my desktop and link that to the database automatically when they unzip. How can I accomplish this?



Sponsored Link
Ads by Google

Response Number 1
Name: Razor2.3
Date: June 17, 2007 at 18:29:23 Pacific
Reply:

Can you run a program when the unzipping finishes? If so, save this .vbs and have the unzipper run it:

With CreateObject("WScript.Shell")
With .CreateShortcut(.SpecialFolders("Desktop") & "\Database.lnk")
.TargetPath = "database.mdb"
.WorkingDirectory = CreateObject("Scripting.FileSystemObject").GetFolder(".").Path
.IconLocation = "icon.ico"
.Description = "I'm a shortcut, yo"
.WindowStyle = 1
.Save
End With
End With


0
Reply to Message Icon

Related Posts

See More


SQL 2005 upgrade from tri... OCP - anwar khan auctions



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Database Forum Home


Sponsored links

Ads by Google


Results for: Linking icon to Access db

Importing from Excel to Access DB www.computing.net/answers/dbase/importing-from-excel-to-access-db/246.html

How to access local database? www.computing.net/answers/dbase/how-to-access-local-database/273.html

c program to access mysql - failed www.computing.net/answers/dbase/c-program-to-access-mysql-failed/411.html