Connecting Access table to read/ create/delete table using .NET in multi user environment
Posted on 2008-06-17
I am connecting to acces table to read some info from tbl_Test and will fill the dataset using command object.
I have few concern on this method...
1) The .NET will be used by multiple user so what will be the best approach i should follow to avoid the common issues like he Microsoft Jet Database Engine cannot open the file ''\\svrPDM\master.mdb". It is opened in exclusive mode by another users. I do have some function which will
create and delete tables in master.mdb
2) Client user network domain account will not have privileges to access the master.mdb file as it is parked in secured server, what i best way i can code the domain username
and password while perform reading, creating,deleting tables. If possible ,how do i code in the connection string
Please share your thoughts.
Dim conn As New OleDb.OleDbConnection
Dim cmd As New OleDb.OleDbCommand
Dim oleDBAdapter As New OleDb.OleDbDataAdapter
Dim dsData As New DataSet
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\\svrPDM\master.mdb;Mode=read;", "test", "1111")
cmd.Connection = conn
cmd.CommandText = "SELECT * FROM tbl_Test"
oleDBAdapter.SelectCommand = cmd