I cant delete records - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

MS Access

I cant delete records

Author

Topic

TerryNL
Starting Member

21 Posts

Posted - 2008-04-04 : 09:39:57

Hi,

I have a database in MS SQL server
the database has been connected to MS Access 2007
when i insert a record in a table, no errors occur
but when i then try to delete the record the following message appear:
(this message was in Dutch, so I tried to translate it into English)
The Microsoft Office Access database engine has been stopped, because you and another user were trying to change the same record.

Anyone who understands this message?
And how can i fix this problem?

TerryNL
Starting Member

21 Posts

Posted - 2008-04-07 : 04:21:52

no one who understands this??

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2008-04-07 : 08:19:40

can you post the code you are using?
are you the only user active on the database?

TerryNL
Starting Member

21 Posts

Posted - 2008-04-07 : 10:24:44

this is the code from the table that gets the error
i've got some other tables that don't give errors but this table does..

create table CellLine
(
cellLineNumber int not null,
firstName varchar(20) null,
lastName varchar(40) null,
gender varchar(1) null,
dateOfBirth datetime null,
familyCode varchar(10) null,
disease varchar(10) null,
cellType varchar(20) null,
remarks varchar(255) null,
edta int null,
heparin int null,
sender varchar(5) null,
investigator varchar(5) null,
arrivalDate datetime null,
affectedNotAffectedCarrier varchar(2) null,
correspondence varchar(10) null,
neurologyNumber varchar(5) null,
liquidNitrogen varchar(10) null,
numberOfVials int null,
specificationsSender varchar(50) null,
culturingFormsCreated bit null,
transportDataFormCreated bit null,
probandRelative bit null,
mutationFormCreated bit null,
addressFormFilledIn bit null,
bloodWithdrawlDate datetime null,
radboudNumber int null,
dnaDiagnosticsNumber varchar(40) null,
cytogeneticsNumber varchar(30) null,
additionalInformation varchar(255) null,
specificationsDiagnosis varchar(35) null,
clinicalGeneticsNumber varchar(20) null,
informedConsentAtCellCulture bit null,
informedConsentWithSender bit null,
informedConsentWithInvestigator bit null,
noInformedConsent bit null
constraint pk_cellLineNumber_cellLine primary key (cellLineNumber)
)

i am the only active user
my MS SQL server is turned on, and i have imported the tables into Access
when i try to delete a record from this table in Access it gives an error
but when i delete the record in MS SQL server it doesn't give an error

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2008-04-07 : 10:48:58

do you have a primary key defined???

I've seen problems before when no proimary key is defined on tables...

TerryNL
Starting Member

21 Posts

Posted - 2008-04-08 : 08:39:30

quote:
Originally posted by AndrewMurphy

do you have a primary key defined???

I've seen problems before when no proimary key is defined on tables...

constraint pk_cellLineNumber_cellLine primary key (cellLineNumber)

yes i have
last line from the create table statement

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources