Visual Basic Access Network Connection?

[gav032]

Hey people

I wasnt sure which to post this in, the database development or the Visual Basic 6 forum because it covers both grounds, if any admin decide its best in the database development one then please move it.

My application dictates that I will be accessing an Access database (2000) over a network. The database will be updated via my application, and other users on the network will be able to read / search from it. At present i am using the following connection method

Dim adoRecordset As New ADODB.Recordset
 
adoRecordset .Open "[Data]", strConnectionString, adOpenForwardOnly, adLockReadOnly
 
adoRecordset .Close
Set adoRecordset  = nothing

The strConnectionString contains the provider, and location etc for the database. Whilst this method works fine i was wondering about the benefits of actually using an ADO connection object, and then setting this to the Connection object of the recordset, rather than passing it the connection string directly?

Furthermore, does anybody have any tips for concurrency / updating an Access database over a network.

Thanks

Gav