Access database locking

[gottagetcodin]

Hi

I am running a website off an access db with cf code. I have a couple of pages
which can get ~500 users day and have noticed that since using a hit counter
with code
<cfoutput>
<cftransaction>
<cfquery name="storehits" datasource="xx">
insert into hits(hitpage,hituser,hitvar,hitdate)

values('#attributes.page#','#attributes.loginid#', '#attributes.var#',#attributes
..date#)
</cfquery>
</cftransaction>
</cfoutput>

i am quite frequently (say ~10 times/day) getting errors saying

Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC
Socket][Microsoft][ODBC Microsoft Access Driver] Could not update; currently
locked by user 'admin' on machine

Surely Access shouldnt fall over so quick or is it my code. Any suggestions
please?

Tim

[jorgepino]

I would recomend to move away from access database if you wanted to use it for your website
Choices
MYsql free
MSsql 4k
Oracle lotmore

[JMGibson3]

Are you sure nobody's opening it in Access or a scheduled Compact is running?
The only time I've EVER seen that exact message (and often, silly me) is when I
have the table open in Design View in Access or in the middle of a Compact
Files command.

[TWG]

Did you ever figure out the culprit on this problem? I've been recently having
the same issues, although I'm getting the error much more frequently than you.
I haven't been able to put my finger on the real issue at all, so I just wanted
to see what your thoughts were.