I Need Help

[startnow]

Hi evrybody

I want to connect my vb.net application over the network to Ms Access database?

And can i change the my access database to foxpro with out effecting
in the source code of my vb.net application.

Thanks in Advance

[Hack]

And can i change the my access database to foxpro with out effecting in the source code of my vb.net application.

The source code would have to be modified as each database requires a different connection string.

[Ecniv]

I want to connect my vb.net application over the network to Ms Access database?

Is that a question or a statement?

Your mdb file would need to be in a shared folder that the users have read/write access to.

The VB.Net would need a connection string to that folder, so perhaps an ini file or a registry place holder. You'd need a form or a separate app to locate the back end mdb and store the path. Should work ok though once you have the path. Not sure if .Net allows a install to type thing? might be able to get it to ask the user where the back end should go...?

Read up on the distributing .net projects online?

[LinXG]

I want to connect my vb.net application over the network to Ms Access database?

If you are connecting over a LAN the answer is Yes. If by network you mean the internet then it is not possible to connect directly to an Access database. There are work arounds that will allow you to do this using other Microsoft products.

And can i change the my access database to foxpro with out effecting in the source code of my vb.net application.

At the very least you will have to create a new connection string for Foxpro. You could handle this in your code by giving the user a menu option or checkbox option to choose which database type you want.

Ecniv's suggestion that you create an ini type file is the one that I use most often.

When you talk about changing your Access DB to Foxpro do you mean converting your Access DB to Foxpro? You may run into issues with data types and how Foxpro distinguishes dates, numbers, text when running queries.

[startnow]

Ok am trying to connect over local LAN so how the string will looks like after
connecting is it like this:-
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\192.165.132.212\SaveTree.mdb

and yah i need to convert the data file from access to Foxpro so i did it but still shows me some error in the .Net

[LinXG]

As far as I know Access does not use IP addresses so your connection string should look something like...

yourDbConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=u:\someFolder\SaveTree.mdb;Persist Security Info=False"

I don't use Foxpro so I don't know what it's connection string will look like.

What error are you getting and where does it occuir in your code? Showing the code you are using would be helpful.