Solved

write conflicts & Jet engine error messages on some records and not on others

Posted on 2011-09-23
8
283 Views
Last Modified: 2012-05-12
i've come across a problem on a linked table (from a SQL server 2k backend) in an MDB file.

for this particular table, the majority of the records can be edited, deleted and i can also add new ones as well. however, for a very small subset, i cannot with the write conflict and "Jet database stopped" messages.

i deleted and relinked the table, i checked the permissions on the SQL server, and made sure there was a unique identity on the table as well.

the interesting fact is that the records are uneditable and undeletable were created via a form, and each time each was created, the write conflict error would pop up, but the record would still be saved (each uneditable and undeletable).

any ideas? thanks!
0
Comment
Question by:ironpen45
  • 5
  • 3
8 Comments
 

Author Comment

by:ironpen45
ID: 36589170
update: if i copy an entire row and paste it on the table, i'm able to delete and edit this newly entered record. however, if i manually enter data in each field (column) from left to right, then the record is uneditable/undeletable in access. i can still edit and delete in SQL.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 36591029
>>and made sure there was a unique identity on the table as well.<<
An IDENTITY column does not mean that it is unique.  More important is:  Do you have a Primary Key on the table?

0
 

Author Comment

by:ironpen45
ID: 36591116
>>An IDENTITY column does not mean that it is unique.  More important is:  Do you have a Primary Key on the table?<<

yes, it also has a primary key which happens to be have an IDENTITY property.

another observation: i can remove those undeletable records with a delete query.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 36592776
If you have defined a Primary Key on the column with an IDENTITY attribute, then I have no idea what could be the problem.
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:ironpen45
ID: 36599112
>>If you have defined a Primary Key on the column with an IDENTITY attribute, then I have no idea what could be the problem. <<

i created a new MDB, linked the table in question and noticed the same thing (able to edit/delete older records, but not newer records).

generally, one would expected the same behavior for all records in a given table, but not some (newer) records and yes for the majority (older) records.

would constraints be an issue?

i think i've exhausted my search. please help!
0
 

Accepted Solution

by:
ironpen45 earned 0 total points
ID: 36599471
found the solution: http://support.microsoft.com/kb/280730.

the problem was a bunch of bit and float type fields with null values. what was confounding was the older records has data in them, allowing me to edit/delete whereas the newer ones had no default value and allowed nulls.

just added a date/time stamp field with timestamp and works like a charm.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 36654771
>>found the solution: <<
Excellent! Now please close the question.
0
 

Author Closing Comment

by:ironpen45
ID: 37130065
because it works
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now