Apparantly my server "Can't Lock File" (Access db)

[jfrost10]

So frustrating

So, I upload my access db to my web host. First off, I get an error message on the page saying that the file is in use by another process. I change the permissions for the aspnet user, and now I get "Can't lock file"

Anybody have any ideas?

It all works properly on my dev machine (this is why I love sql server so much...)

thanks,

D

 

[Isadore]

D - I've uploaded dozens of mdb's over the last year to use in ASP.NET. I just compact them, send them up, and then connect -- no problems. Be sure that the location of the mdb is in a folder where permissions to write/delete/update, etc.. are given (on the server here at Auburn, only one directory is set up for this). Also, frontpage extensions need to be in order. Typical string I use to connect to an mdb (minus Try...Catch):

'open database...
Dim cmdSelect As OLEDbCommand
Dim dbconnSiteRecs As OleDbConnection = New OleDbConnection( _
"Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source=" & Server.MapPath(".\fpdb\Sites.mdb;&quot)
cmdSelect = New OLEDbCommand("SELECT County FROM tblALCounty", dbconnSiteRecs)
dbconnSiteRecs.Open()
ddCty.DataSource = cmdSelect.ExecuteReader()
ddCty.DataBind()
dbconnSiteRecs.Close()

 

[Isadore]

D-

This is a good article - might help.

http://aspalliance.com/PeterJohnson/JetAdvice.aspx