|
|
|
date: Thu, 8 May 2008 19:26:01 +0530,
group: microsoft.public.access.multiuser
back
Re: Curruption of Database
Hi,
I am using BeginTransaction & CommitTransaction method of ADO Connection
Object to ensure that data has written perfectly. But then also it corrupts
data.
Will RefreshCache method of Jet Engine will help me ?
If yes then where do I have to put it, before BeginTransaction or After
CommitTransaction because I am confused with JRO Help Description & it's
example.
Thanks,
Sanjay Shah
"Alex Dybenko" wrote in message
news:O7ECCDasIHA.5472@TK2MSFTNGP06.phx.gbl...
> Hi,
>
> could be that this is network issue, look here for more info:
> http://www.granite.ab.ca/access/corruptmdbs.htm
>
> --
> Best regards,
> ___________
> Alex Dybenko (MVP)
> http://accessblog.net
> http://www.PointLtd.com
>
> "SANJAY SHAH-MICROBRAIN COMPUTERS PVT. LTD." wrote
> in message news:OTwN%23MRsIHA.3680@TK2MSFTNGP05.phx.gbl...
>> Dear Sir,
>>
>> I am using Access 2000 with VB6, ADO 2.5 & Microsoft.Jet.OLEDB.4.0 in my
>> application.
>>
>> In my application all Inserting / Deleting & Updating process is within
>> BeginTransaction & Commit Transaction.
>>
>> All tables of database is having primary key & required other indexes.
>>
>> All tables of database is related with parent table and enforce
>> referential integrity.
>>
>> I am using INSERT, UPDATE, DELETE Query to manipulate data.
>>
>> I am not binding recordset with any control.
>>
>> Then also in multi-user environment my data gets corrupted in some of
>> Local Area Network when any of machine is having problem or hangs while
>> saving.
>>
>> Can any one explain me why this ?
>>
>> Thanks in advance for support.
>>
>> Sanjay Shah
>>
>>
>
date: Wed, 14 May 2008 15:44:35 +0530
author: SANJAY SHAH-MICROBRAIN COMPUTERS PVT. LTD.
Re: Curruption of Database
hi,
using or not using transactions does not affect corruption, corruption
happens when you get problem with media used to access mdb file, in most
cases - network
--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
"SANJAY SHAH-MICROBRAIN COMPUTERS PVT. LTD." wrote in
message news:OR4ZTtatIHA.5580@TK2MSFTNGP04.phx.gbl...
> Hi,
>
> I am using BeginTransaction & CommitTransaction method of ADO Connection
> Object to ensure that data has written perfectly. But then also it
> corrupts data.
>
> Will RefreshCache method of Jet Engine will help me ?
>
> If yes then where do I have to put it, before BeginTransaction or After
> CommitTransaction because I am confused with JRO Help Description & it's
> example.
>
> Thanks,
>
> Sanjay Shah
>
> "Alex Dybenko" wrote in message
> news:O7ECCDasIHA.5472@TK2MSFTNGP06.phx.gbl...
>> Hi,
>>
>> could be that this is network issue, look here for more info:
>> http://www.granite.ab.ca/access/corruptmdbs.htm
>>
>> --
>> Best regards,
>> ___________
>> Alex Dybenko (MVP)
>> http://accessblog.net
>> http://www.PointLtd.com
>>
>> "SANJAY SHAH-MICROBRAIN COMPUTERS PVT. LTD." wrote
>> in message news:OTwN%23MRsIHA.3680@TK2MSFTNGP05.phx.gbl...
>>> Dear Sir,
>>>
>>> I am using Access 2000 with VB6, ADO 2.5 & Microsoft.Jet.OLEDB.4.0 in my
>>> application.
>>>
>>> In my application all Inserting / Deleting & Updating process is within
>>> BeginTransaction & Commit Transaction.
>>>
>>> All tables of database is having primary key & required other indexes.
>>>
>>> All tables of database is related with parent table and enforce
>>> referential integrity.
>>>
>>> I am using INSERT, UPDATE, DELETE Query to manipulate data.
>>>
>>> I am not binding recordset with any control.
>>>
>>> Then also in multi-user environment my data gets corrupted in some of
>>> Local Area Network when any of machine is having problem or hangs while
>>> saving.
>>>
>>> Can any one explain me why this ?
>>>
>>> Thanks in advance for support.
>>>
>>> Sanjay Shah
>>>
>>>
>>
>
>
date: Wed, 14 May 2008 14:34:39 +0400
author: Alex Dybenko
Re: Curruption of Database
> I am using BeginTransaction & CommitTransaction method of ADO Connection
> Object to ensure that data has written perfectly. But then also it
> corrupts data.
Unlike with SQL-Server; on JET (Access), transactions don't ensure data
integrity at all. With JET, your network must be rock solid and the
machines must not hang; otherwise you'll end-up with corruption; with or
without transactions.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"SANJAY SHAH-MICROBRAIN COMPUTERS PVT. LTD." wrote in
message news:OR4ZTtatIHA.5580@TK2MSFTNGP04.phx.gbl...
> Hi,
>
> I am using BeginTransaction & CommitTransaction method of ADO Connection
> Object to ensure that data has written perfectly. But then also it
> corrupts data.
>
> Will RefreshCache method of Jet Engine will help me ?
>
> If yes then where do I have to put it, before BeginTransaction or After
> CommitTransaction because I am confused with JRO Help Description & it's
> example.
>
> Thanks,
>
> Sanjay Shah
>
> "Alex Dybenko" wrote in message
> news:O7ECCDasIHA.5472@TK2MSFTNGP06.phx.gbl...
>> Hi,
>>
>> could be that this is network issue, look here for more info:
>> http://www.granite.ab.ca/access/corruptmdbs.htm
>>
>> --
>> Best regards,
>> ___________
>> Alex Dybenko (MVP)
>> http://accessblog.net
>> http://www.PointLtd.com
>>
>> "SANJAY SHAH-MICROBRAIN COMPUTERS PVT. LTD." wrote
>> in message news:OTwN%23MRsIHA.3680@TK2MSFTNGP05.phx.gbl...
>>> Dear Sir,
>>>
>>> I am using Access 2000 with VB6, ADO 2.5 & Microsoft.Jet.OLEDB.4.0 in my
>>> application.
>>>
>>> In my application all Inserting / Deleting & Updating process is within
>>> BeginTransaction & Commit Transaction.
>>>
>>> All tables of database is having primary key & required other indexes.
>>>
>>> All tables of database is related with parent table and enforce
>>> referential integrity.
>>>
>>> I am using INSERT, UPDATE, DELETE Query to manipulate data.
>>>
>>> I am not binding recordset with any control.
>>>
>>> Then also in multi-user environment my data gets corrupted in some of
>>> Local Area Network when any of machine is having problem or hangs while
>>> saving.
>>>
>>> Can any one explain me why this ?
>>>
>>> Thanks in advance for support.
>>>
>>> Sanjay Shah
>>>
>>>
>>
>
>
date: Thu, 15 May 2008 00:55:49 -0400
author: Sylvain Lafontaine sylvain aei ca (fill the blanks, no spam please)
Re: Curruption of Database
Please visit www.atnas20@hotmail.com/blog
I am starting up a business and need new customers. Any help that you could
give me, I would really appreciate it. Im not spaming anyone, so please let
me know if there are anyone you know who lives in the london area and would
be interested in the purchase of medical uniforms.
Im trying to get as many customers as i can. i need help tho. Please pass
this email on to whom ever you know who would be interested. I would really
appreciate it.
Here is a little about it:
We are a business that makes Medical Uniforms which are made for Nurse's,
Doctors, and any Medical team that there is out there like PSW's.
You can find more out about it at: www.atnas20@hotmail.com/blog
We have flexible plans to accommodate growth. All size's, styles and colors
that you can think of
We are located in London, Ontario
Thank you for your time.
Margaret
"SANJAY SHAH-MICROBRAIN COMPUTERS PVT. LTD." wrote in
message news:OTwN%23MRsIHA.3680@TK2MSFTNGP05.phx.gbl...
> Dear Sir,
>
> I am using Access 2000 with VB6, ADO 2.5 & Microsoft.Jet.OLEDB.4.0 in my
> application.
>
> In my application all Inserting / Deleting & Updating process is within
> BeginTransaction & Commit Transaction.
>
> All tables of database is having primary key & required other indexes.
>
> All tables of database is related with parent table and enforce
> referential integrity.
>
> I am using INSERT, UPDATE, DELETE Query to manipulate data.
>
> I am not binding recordset with any control.
>
> Then also in multi-user environment my data gets corrupted in some of
> Local Area Network when any of machine is having problem or hangs while
> saving.
>
> Can any one explain me why this ?
>
> Thanks in advance for support.
>
> Sanjay Shah
>
>
date: Sun, 6 Jul 2008 11:57:26 -0400
author: Margaret
|
|
