How to hide database
-
Development tool: Visual Studio 2005
Language: Visual Basic .NET
ISSUE: Package database into program
-
DETAILS:
I have a windows forms application that uses an Access Database. I am new to windows forms applications, so there is still a LOT for me to learn.
Currently the only way I can figure out how to map out the connection string for the database is to place the file on the users C: drive in the program folder of the application. So my connection string looks like "C:\Program Files\MyApplication\access_db\MyDB.mdb"
Then when I create the setup and deploy on an "end-user" machine, the setup creates that directory and places the file in that folder.
I am used to web development and we have the luxury of using "Server.MapPath("MyDB.mdb")" to create a dynamic connection to the database.
How can I package this database into the .exe and make it so that when the user installs the program, they cannot dig into their Program Files folder and get to the database? It is pretty important that the users cannot find thier way to this data.
--
Your help is appreciated,
KJAK
