Edit Record Error

Hot Topic

Question: How do I hide the Title Bar?
Avoid message boxes during macro?
SendKeys from Excel
Word: How to you determine the current cursor position
Automatically send attachment in email with a submit command button in word
Selection of only one object
find current path in VBA macro word
Restrict editing of activity based on date comparison
Adding a worksheet to the workbook
Converting text file to excel file macro - help needed

Microsoft ISV

Highlight Row depending on cell - Excel VBA -
vba create and add a macro for excel programmatically
Worksheet.Copy causes execution to stop
File open dialog in Outlook 2003
Variable declaration + assignment
Help !!!
Argument syntax problem
Executing code off of a cell update
Data Access Pages - FAO Chas
How can I store a merge field value as document metadata?

Edit Record Error


Bachground:I have an access data base front end, who's tables are linked to an sql server backend. In turn the tables are connected to the Forms Dinamically. For example: ME.recordSource = "SELECT * FROM tblCustomers WHERE loc = '" & location "'"

Theres one main form with about 5 Subforms connected to it all placed on tabs. About 3 of the forms record sources refer to the same table.

When I have the main form on the last record and I try to delete a record on one of the particiular subforms I get the following message.

***The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.***


In all other circumstances it deletes fine it only does this when the main form is on the last record. What can I do to fix this, or get around this. I don't mind long answers. Thanks in advance.




Answer this question

Edit Record Error

  • ksona

    Well what do know. I thank God for helping me find this answer. The answer is That on the SQL Server side you can't have a Bit field with a null value or it will lock that record. The key is to either on the Access/Client side have the form apply a default value to that specific field or to to enter in a default value on the SQL Server side. There are many things that can cause this error, But this was the correct solution for me.

  • Edit Record Error
Answer this question