connecting to an access databse on a server

[knaya]

this sound so simple but its driving me crazy.. i'm trying to connect to an access database on a server using oleDB connection but its not working.. it either says it cant connect to the server or the database is already open by someone else etc.. i'll appreciate any help, i've already spent hours searching google but nothing is working.. Thanks ... i read somehwere you can only connect to an access databse if its located on the c drive.. that cant be true, can it?

 

[Joulius]

Here's a simple example on how to connect to an Access database:

dim oCon as OleDbConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("yourDB.mdb"))

From my experience, any operation that you do on your database shold be placed inside a try ... catch ... end try statement like this:

Din Err As String
Try
 oCon.Open()
 .... 'your code
Catch ex As Exception
 Err = ex.Message()
Finally
 oCon.Close() 'even if you're having an error, your 
End Try       'connection gets closed

 

[Joulius]

And it's not true ... your .mdb file can be anywhere! Just make sure that your using Server.MapPath correctly.