Joel,
It's definitely a locking issue. I'll bet there's an Access .ldb file in
the same directory as your database file when this happens. I ran into
this myself. Access started to lock my DB file all by itself. Turns out
that the database had grown beyond Access capabilities and I had to move
to an enterprise platform (Oracle) If the cause is not someone
physically having the database file open, you might want to check the
integrity of your Access file.
>Everyone:
>
>I got this error today. It just started. And I haven't a clue why. Here's
>what I get:
>
>ODBC Error Code = S1000 (General error)
>
>[Microsoft][ODBC Microsoft Access 97 Driver] The Microsoft Jet database
>engine stopped the process because you and another user are attempting to
>change the same data at the same time.
>
>And here's the code:
>
><cfquery name="get" datasource="bayhealthDS">
>select * from JobApps
></cfquery>
>
>It doesn't get much simpler then that. I appreciate your input. And there
>are no files included.
>Just this and a <cfoutput> statement.
>
>Thanks.
>
>===================
>Joel Firestone - Developer
>Delmarva Online
>http://www.dmv.com/
>
>
>--------------------------------------------------------------------------
>----
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
