🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.databases.ms-access
Article #359

Re: Record Locking problem in table

#359
From: Christophe Courtois
Date: Thu, 25 Feb 1999 00:00
16 lines
1674 bytes
> I've tried exporting the table to another file, and then reimporting 
> it - I can't do that, since 'someone else' is using it.

 Add this problem too twice. After many try-and-errors, I located THE index
which was problematic. Suppressing it, repairing and restoring it was enough.
I had not so big tables and it was not so long...

 Do you have an idea about how it occured ? I've seen it after having worked
in network on the database. But I don't want to happen again by the
customers...

-- 
Christophe Courtois
IPCES Europe SA - http://www.ipces.com
Tour S�bastopol - F-67080 Strasbourg - France
Tel : (33) 3 88 23 70 22  -  Fax : (33) 3 88 23 71 14
Technical Details
Message-ID: <36D513B0.809AFF26@ipces.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <7b0gpb$4qc$1@bignews.shef.ac.uk>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 101bdd,c34d39e6dedbcf54
X-Google-Attributes: gid101bdd,public
X-Google-Thread: 111a5a,c34d39e6dedbcf54
X-Google-Attributes: gid111a5a,public
X-Google-Thread: 102b1d,c34d39e6dedbcf54
X-Google-Attributes: gid102b1d,public
X-Google-Thread: ff0ac,c34d39e6dedbcf54
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 1143dd,c34d39e6dedbcf54
X-Google-Attributes: gid1143dd,public
From: Christophe Courtois <christophe.courtois@ipces.com>
Subject: Re: Record Locking problem in table
Date: 1999/02/25
Message-ID: <36D513B0.809AFF26@ipces.com>
X-Deja-AN: 448241220
Content-Transfer-Encoding: 8bit
References: <7b0gpb$4qc$1@bignews.shef.ac.uk>
To: Nick Farrell <nickfarrell@dial.pipex.com>
Content-Type: text/plain; charset=iso-8859-1
Organization: IPCES Europe SA
Mime-Version: 1.0
Newsgroups: comp.databases.ms-access,de.comp.datenbanken.ms-access,es.comp.bd.ms-access,microsoft.public.access.chat,microsoft.public.access.forms