[RESOLVED] multiuser system

[elixir_5000]

i have competed a vb .net and access project . in the codes i have given the database path as d:/purchase/database.mdb
now what i want is that i keep the database file on a system in the d drive and purchase folder and it can be accesed thruogh my project from other system so that all the change in the database are reflected to every user .
plz help
regard

[elixir_5000]

i have changed my coon string to

con1.Open("Provider=MS Remote;" & _
                           "Remote Server=http://192.168.0.100;" & _
                           "Remote Provider=Microsoft.Jet.OLEDB.4.0;" & _
                           "Data Source=e:\purchase\Database.mdb;Jet OLEDB:Database Password=emgee1")

now it is giving error internet client error connection reset
plz tell me what to do

[stanav]

You just can't put a file in to some location and expect that other PCs on the network can find and use it... The directory needs to be shared and security permission needs to be set.

1. Make the folder that contains your database a shared folder, and give it a sharename.
2. Set appropriate share and security permissions.
3. In your connection string, point the database location (data source =\\YourPCName\SharedFolderName\thedatabase.mdb)

[elixir_5000]

do the server need to have IIS installed for the above purpose

[stanav]

do the server need to have IIS installed for the above purpose

Nope... IIS is needed if you plan on making that server a web server, application server or terminal server only.

[dclonch1]

Also, it would be better to put that path into a variable and store it in an xml file or application setting. This way it can be changed without changing your code. I make it a practice of never hardcoding anything that is actually an environmental variable that could change based in the network setup of the customer. Even if you have to go back to storing settings in an INI file (lol) it would be better than hardcoding it.

Dustin
http://www.helpmehackyou.com

[elixir_5000]

Some one plz guide me i am using the following code to connect with my server but its giving eror cannot connect to server but i can manually connect to server. plz guide me what to do i am really stuck.
regards

con1.Open("Provider=MS Remote;" & _
                          "Remote Server=http:\\192.168.0.100;" & _
                         "Remote Provider=Microsoft.Jet.OLEDB.4.0;" & _
                        "Data Source=" & "\\server\purchase\Database.mdb" & ";Jet OLEDB:Database Password=emgee1")

[elixir_5000]

i want to connect to network computer where lies my ms access database plz guide to write connection string

[elixir_5000]

if i am connecting by using server name then it says error business object cannot be created plz help people

[elixir_5000]

if i use the folloing code as said bu si the geek in a different thread then it i giving error that " cannot start your application workgroup detail file is missing or is opened exclusively by someone"

Con1.Open("Provider=Microsoft.Jet.OLEDB.4.0;" & _
                "Data Source=\\Server\purchase\database.mdb;" & _
                "User Id=emgee;Password=6673;" & _
                "Persist Security Info=False")

[effekt26]

i think there could be an error in your connection string...

www.connectionstring.com will give u a great resource for any type of connectionstring you will need.

i beleive you are after this string. substitute your values into the string, and tell us how you go..

With password
This is the connection string to use when you have an access database protected with a password using the Set Database Password function in Access.
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;Jet OLEDBatabase Password=MyDbPassword;

Note, source can be \\server\purchase\Database.mdb

and if the share is ntfs drive, ensure that the user has access to that share (sharing and access permissions)

Thanks, Justin

[effekt26]

sorry, didnt read the other posts. Can u post a snippet of the error.

Thanks

[elixir_5000]

here is the screen shot of my error plz help

[elixir_5000]

the best way i found is that work a bit hard and use odbc

Con1.ConnectionString = "DSN=database;PWD=emgee1;"