Hi, when i´m designing in reamweaver mx my database is locked. This means when i prewiew the file in a browser, it wont work. It says that the database is used by another progress.
Here is my connection string: <font color=red>MM_sfff_STRING = "Provider=Microsoft.JET.OLEDB.4.0;Data Source=C:\inetpub\wwwroot\sfff\db\dbsfff.mdb"</font id=red>

And here is the opening of the database:
<font color=red>
Dim rsMembers
Dim rsMembers_numRows

Set rsMembers = Server.CreateObject("ADODB.Recordset"
rsMembers.ActiveConnection = MM_sfff_STRING
rsMembers.Source = "SELECT * FROM Medlemstabell"
rsMembers.CursorType = 0
rsMembers.CursorLocation = 2
rsMembers.LockType = 3
rsMembers.Open()

rsMembers_numRows = 0
</font id=red>

Some of the openings of the same database have locktype=1. Can this have anything to do with this?
<img src="karlgrens-it.se/sfff/ldb.jpg" border=0>

Any help appriciated.

//Stellan

If you are testing/running from your local machine, looks like your database is open, in MS Access that is. Close MS Access and you'll see that .ldb file go away.

~~~~~~~~~~~~~~~
Chris Charlton

Sr. Developer - www.fingerprintMedia.com