[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
>