[AccessD] error & structure: Please Help!!

Hi Pedro:

One thing you can do is when you get the BE recovered. Check to see how
database is being used. Some of the problems that I had were:

1. Some users never logged off and just left everything running.... result
in extra exposure and halted backups.
2. One user simply used the off and on button when ending for the day.
3. One of the local IT guys would re-boot the server without getting
everyone logged off. 

I am not suggesting that these are the issues at your site but a similar set
of problems that that physically affect database I/O would continuously
corrupt your BE.

HTH
Jim


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

Hi Jim,

even exporting the tables in a blanc database sometimes didn't work.
In two cases i had to copy and past al the data in tables from backup's.
This is a lot of work. Last time it took me about 5 hours to restore al the 
data.

Pedro Janssen



----- Original Message ----- 
From: "Jim Lawrence" <accessd at shaw.ca>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Wednesday, November 23, 2005 11:03 PM
Subject: Re: [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
>
> -- 
> 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