This is a multi-part message in MIME format.
------=_NextPart_000_000F_01BF9594.BAF85AC0
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
Everyone:
Thanks. Unfortunantly, this is a client we host. So I'm having check=20
the db on their end and re-upload. Once that happens, I'll try again.=20
But I know it's not a overload issue, as this site gets dismal page=20
views.
Thanks again, guys.
Joel
"Alexander Lamon" <[EMAIL PROTECTED]> wrote in message =
news:<[EMAIL PROTECTED]>...
> Joel,
>=20
> It's definitely a locking issue. I'll bet there's an Access .ldb file =
in=20
> the same directory as your database file when this happens. I ran =
into=20
> this myself. Access started to lock my DB file all by itself. Turns =
out=20
> that the database had grown beyond Access capabilities and I had to =
move=20
> to an enterprise platform (Oracle) If the cause is not someone=20
> physically having the database file open, you might want to check the=20
> integrity of your Access file.
>=20
>=20
>=20
>=20
> >Everyone:
> >
> >I got this error today. It just started. And I haven't a clue why. =
Here's
> >what I get:
> >
> >ODBC Error Code =3D 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=3D"get" datasource=3D"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.
> >
> >=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> >Joel Firestone - Developer
> >Delmarva Online
> >http://www.dmv.com/
> >
> >
> =
>------------------------------------------------------------------------=
--
> >----
> >Archives: http://www.eGroups.com/list/cf-talk
> >To Unsubscribe visit=20
> =
>http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dlists/cf_t=
alk or=20
> >send a message to [EMAIL PROTECTED] with =
'unsubscribe' in=20
> >the body.
> =
-------------------------------------------------------------------------=
-----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit =
http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dlists/cf_ta=
lk or send a message to [EMAIL PROTECTED] with =
'unsubscribe' in the body.
------=_NextPart_000_000F_01BF9594.BAF85AC0
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Dwindows-1252" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.3013.2600" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DVerdana size=3D2>Everyone:</FONT></DIV>
<DIV><BR><FONT face=3DVerdana size=3D2>Thanks. Unfortunantly, this is a =
client we=20
host. So I'm having check </FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2>the db on their end and re-upload. =
Once that=20
happens, I'll try again. </FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2>But I know it's not a overload issue, =
as this=20
site gets dismal page </FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2>views.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DVerdana size=3D2>Thanks again, guys.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DVerdana size=3D2>Joel</FONT></DIV>
<DIV><BR>"Alexander Lamon" <<A=20
href=3D"mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]</A>>=
wrote in=20
message <A href=3D"news:<">news:<</A><A=20
href=3D"[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]">20000324144=
[EMAIL PROTECTED]</A>>...<BR>>=20
Joel,<BR>> <BR>> It's definitely a locking issue. I'll bet there's =
an=20
Access .ldb file in <BR>> the same directory as your database file =
when this=20
happens. I ran into <BR>> this myself. Access started to lock =
my DB=20
file all by itself. Turns out <BR>> that the database had grown =
beyond=20
Access capabilities and I had to move <BR>> to an enterprise platform =
(Oracle) If the cause is not someone <BR>> physically having =
the=20
database file open, you might want to check the <BR>> integrity of =
your=20
Access file.<BR>> <BR>> <BR>> <BR>> <BR>> =
>Everyone:<BR>>=20
><BR>> >I got this error today. It just started. And I haven't =
a clue=20
why. Here's<BR>> >what I get:<BR>> ><BR>> >ODBC Error =
Code =3D=20
S1000 (General error)<BR>> ><BR>> >[Microsoft][ODBC =
Microsoft Access=20
97 Driver] The Microsoft Jet database<BR>> >engine stopped the =
process=20
because you and another user are attempting to<BR>> >change the =
same data=20
at the same time.<BR>> ><BR>> >And here's the code:<BR>>=20
><BR>> ><cfquery name=3D"get" =
datasource=3D"bayhealthDS"><BR>>=20
>select * from JobApps<BR>> ></cfquery><BR>> =
><BR>>=20
>It doesn't get much simpler then that. I appreciate your input. And=20
there<BR>> >are no files included.<BR>> >Just this and a=20
<cfoutput> statement.<BR>> ><BR>> >Thanks.<BR>>=20
><BR>> =
>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<BR>> =
>Joel Firestone -=20
Developer<BR>> >Delmarva Online<BR>> ><A=20
href=3D"http://www.dmv.com/">http://www.dmv.com/</A><BR>> =
><BR>>=20
><BR>>=20
>---------------------------------------------------------------------=
-----<BR>>=20
>----<BR>> >Archives: <A=20
href=3D"http://www.eGroups.com/list/cf-talk">http://www.eGroups.com/list/=
cf-talk</A><BR>>=20
>To Unsubscribe visit <BR>> ><A=20
href=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3D=
lists/cf_talk">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&=
;body=3Dlists/cf_talk</A>=20
or <BR>> >send a message to <A=20
href=3D"mailto:[EMAIL PROTECTED]">cf-talk-request@houseof=
fusion.com</A>=20
with 'unsubscribe' in <BR>> >the body.<BR>>=20
-------------------------------------------------------------------------=
-----<BR>>=20
Archives: <A=20
href=3D"http://www.eGroups.com/list/cf-talk">http://www.eGroups.com/list/=
cf-talk</A><BR>>=20
To Unsubscribe visit <A=20
href=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3D=
lists/cf_talk">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&=
;body=3Dlists/cf_talk</A>=20
or send a message to <A=20
href=3D"mailto:[EMAIL PROTECTED]">cf-talk-request@houseof=
fusion.com</A>=20
with 'unsubscribe' in the body.</DIV></BODY></HTML>
------=_NextPart_000_000F_01BF9594.BAF85AC0--
------------------------------------------------------------------------------
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.
