Include Access Database

[ajsatori]

I have a project with an access DB that I want to deploy. I have included the DB with the project and it gets included in the published folder but, when I install it on the other computer, the database is in some other folder. I have been tring to connect with this connection string.

"Provider=Microsoft.Jet.OLEDB.4.0;data source=|DataDirectory|\Database\Gymnasts.mdb;Persi st Security Info=False"

But it does not find the DB. I also need to see if I can get it working on a PC that may not have MS Access on it.

I have also tried to use the Deploy packages but nothing ever happens. The only files in the debug folder I get is the .msi and .exe. I read that I should have 5 total not 2. (3 .exe, 1 .msi and 1 .ini )

Going a litte crazy

Any help would be great
Thanks

[puteraindonesia]

->Ms access its not a reliable database that support multiple user connection, i suggest you use mysql or else next time.

->about db path :
First,save your mdb file in C:\Program Files\[your aplication name]\Support when you work with your vb. That makes conection string that you typed in your program, working after you package (and install in other PC) your app.

Two, other way... try to save your mdb file in persist path location in target PC. mdb file still works, even MsAccess not installed.

i wish it can help.

[debasisdas]

you need to have the acess file as part of the package or ca copy separtely and paste in a specific path to whih your code refers.

and to use access ,that need not be istalled in he target PC, you can access that from VB.