tags:

views:

19

answers:

2
Q: 

Problem with shortcut when database is included in the project

Hi,

I made a setup project and added a folder for desktop shortcut. My application includes database file as well. When I installed the application and ran the shortcut from desktop, it gave Desktop's path and said ABC.mdb not found.

How can I make it so that when user accesses the shortcut, it finds the database in the folder where user installed the application instead of finding it on desktop.

Thanks a lot.

Furqan

A: 

You need to specify an absolute path to the database.

SLaks  2010-10-20 17:56:33
but how can i know where the user will install the application?
 2010-10-20 17:59:12
You should store your database in the user's Application Data, regardless of the install path. If you really don't want to, however, you can get the install path from `typeof(MyType).Assembly.Location`.
SLaks  2010-10-20 18:07:28
So you mean i add a folder, User's Application Data and add my database to that?
 2010-10-20 18:19:02
No; I mean that you should always put your database in `Path.Combine(Environment.GetSpecialFolder(Environment.SpecialFolderKind.ApplicationData), "Your App's Name\Database.mdb")`
SLaks  2010-10-20 18:20:41
I am sorry, I am quite new to vb.net. I used to use vb6. I am really not able to understand where to use the code you gave above. When I create Setup project, I only have a few folders. Where to put your code........ Thanks
 2010-10-20 18:42:11
Put that in your application as the path to the database.
SLaks  2010-10-20 18:59:41
A: 

Install the .mdb file to the same directory as the .exe, then have your .exe look for the .mdb in it's own directory.

Beth  2010-10-20 19:13:17
So you mean I write the code in the Menu Form (Startup form), in the load event?
 2010-10-20 20:03:32
yes, to find the .mdb file to open it in the code
Beth  2010-10-20 20:43:41

related questions

What are the most important functional differences between C# and VB.NET?
Setting Group Type for new Active Directory Entry in VB.NET
ASP.Net Datagrid: in Footer calculate Avg or Sum for column
Opening a file in my application from File Explorer
HTML Email Editor in a Windows Forms Application
Datatables, Dataviews and distincts! (ASP.Net/VB)
Naming convention for VB.NET private fields
Visual Studio - new "default" property values for inherited controls
Change the width of a scrollbar
Is String.Format as efficient as StringBuilder
Default Form Button in FireFox
VB.NET - IsNothing versus Is Nothing
'Break' equivalent keyword for VB
What is the best way to wrap time around the work day?
Best SVN Client Ignore Pattern for VB.NET Solutions?
Long-time LAMP Developer moving to VB.NET
What's the best way to find long-running code in a Windows Forms Application
What is the best way to deploy a VB.NET application?
'Best' Diff Algorithm
Setting Objects to Null/Nothing after use in .NET
CSV File Imports in .Net
How do you migrate a large app from VB6 to VB .net ?
Floating Point Number parsing: Is there a Catch All algorithm?
Decoding T-SQL CAST in C#/VB.net
Reliable Timer in a Console Application