Re: Problem with MS Jet 4.0

Article View: comp.databases.ms-access

Article #268

Back to comp.databases.ms-access Previous Next

#268

From: JOSEPHDubio
Date: Sun, 07 Apr 2002 02:37

37 lines
2340 bytes

"Plamen Petrov" <plamen.petrov@grutzeck.de> wrote in message
news:3cac01a5$1@news.grutzeck.local...
> It's very easy to reproduce the problem.
> Create a table using the next statement:
>
> CREATE TABLE t1
> (
>     id  AUTOINCREMENT NOT NULL PRIMARY KEY,
>     name VARCHAR(50)
> )
>
> After that execute in transaction next 2 statements:
>
> INSERT INTO t1(name) VALUES('abc')
>
> CREATE TABLE t2
> (
>     id  AUTOINCREMENT NOT NULL PRIMARY KEY,
>     x  INT NOT NULL REFERENCES t1(Id),
>     name  VARCHAR(50)
> )
>
> The result is error: 0x80040E14L  -  DB_E_ERRORSINCOMMAND
> State  : 3211
> Native : -534316312
>
> The database engine could not lock table 't1' because it is already
> in use by another person or process.
>
> The same code works with SQL Server. Is it a bug in Jet,
> or I'm not doing it in the correct way?
>
>
>
>
>

Technical Details

Message-ID: <u8ww9zd3BHA.2524@tkmsftngp07>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!supernews.com!news.infoave.net!arclight.uoregon.edu!logbridge.uoregon.edu!feeder.via.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp07

References: <3cac01a5$1@news.grutzeck.local>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 1041a7,ea777802d348ae5c
X-Google-Attributes: gid1041a7,public
X-Google-Thread: 111a5a,ea777802d348ae5c
X-Google-Attributes: gid111a5a,public
X-Google-Thread: ff0ac,ea777802d348ae5c
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 109305,ea777802d348ae5c
X-Google-Attributes: gid109305,public
X-Google-Thread: 103569,ea777802d348ae5c
X-Google-Attributes: gid103569,public
X-Google-Thread: 1143a6,ea777802d348ae5c
X-Google-Attributes: gid1143a6,public
X-Google-ArrivalTime: 2002-04-06 18:41:10 PST
From: "JOSEPHDubio" <vze29dym@mail.com>
References: <3cac01a5$1@news.grutzeck.local>
Subject: Re: Problem with MS Jet 4.0
Date: Sat, 6 Apr 2002 21:37:42 -0500
Lines: 39
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <u8ww9zd3BHA.2524@tkmsftngp07>
Newsgroups: comp.databases.ms-access,es.comp.bd.ms-access,microsoft.public.access.dataaccess.pages,microsoft.public.access.tablesdbdesign,microsoft.public.data.oledb,microsoft.public.office.access.devtoolkits
NNTP-Posting-Host: pool-151-202-55-183.ny5030.east.verizon.net 151.202.55.183
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!supernews.com!news.infoave.net!arclight.uoregon.edu!logbridge.uoregon.edu!feeder.via.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp07

Reply to Parent Message