[AccessD] error & structure: Please Help!!

Hi Pedro:

I have run across similar situations before. Everything will remain sable
until a station or the server goes down in the middle of a data operation
between the FE and BE. If this happens often enough, the databases will be
corrupted. In most cases this database will have to be brought back from the
last night's backup.

The last time this situation happened on a client's site they ended up
losing two weeks worth of work. From then on I have never used the bound
database model except for small sites.

You should be able to restore the data, by creating a blank BE and exporting
one table at a time from the old to new.
 
Jim   

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Pedro Janssen
Sent: November 23, 2005 11:09 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] error & structure: Please Help!!

Hellp Gary,

the backend of the database is on one server.
The frontends are on the C: drive of about 10 pc's.

To my knowledge there are no network problems.
I always thought that it could be a problem when more then 1 user is working

in the same table, but this is just an idea.

Gary, i will send you the database of line. The error you can find in the 
accessd mail i returned to Scott Marcus.

Thanks

Pedro Janssen


----- Original Message ----- 
From: "Gary Kjos" <garykjos at gmail.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Wednesday, November 23, 2005 7:46 PM
Subject: Re: [AccessD] error & structure: Please Help!!


> Hi Pedro,
>
> Do you have other people using this database??? Is it shared over a
> network?? Do any of the users have any network connectivity issues??
> It is my experience that database corruption is almost always caused
> by a flakey network connection. Fix that and you will fix the real
> cause of the problem. I don't think you database structure has
> anything at all to do with the problem.
>
> You are welcome to send me your stripped database and I will have a
> look at it though. You can send it to be at garykjos at gmail.com
>
> Gary
>
> On 11/23/05, Scott Marcus <marcus at tsstech.com> wrote:
>> Pedro,
>>
>> What is the error?
>>
>> Scott Marcus
>> IT Programmer
>> TSS Technologies Inc.
>> www.tss.com
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Pedro Janssen
>> Sent: Wednesday, November 23, 2005 11:46 AM
>> To: Access Developers discussion and problem solving
>> Subject: [AccessD] error & structure: Please Help!!
>>
>> Hi,
>>
>>  is there really no one who can help me with this?
>>
>>
>> Last week i posted an error message, but became no answer that gave me
>> an
>> explanation for the error.
>> Is there someone who could look at the databasestructure ( i will send
>> the
>> stripped database ofline) and see why this error can appear, and give me
>>
>> some tips to prevent the error and for improvement of the structure.
>>
>>
>> Pedro Janssen
>>
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>
>
> --
> Gary Kjos
> garykjos at gmail.com
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com