Access Forms "Write Conflict"

[PRLIT]

I'm using Access to create forms with a SQLExpress backend.

My form is for logging purchases. I have a date ordered and a date delivered. (I know the write issue comes from the date)

I've tried adding a TS colum to all of my tables with a timestamp data type (allow nulls). - Still get the error.

My recordset type is "updateable snapshot".

Not sure what else to try. I've looked at all the others with this issue but have yet to find a solution that works for me.

Thank you so much.

[PRLIT]

I've also tired this: http://support.microsoft.com/kb/304181 but still no luck.

[PRLIT]

Sorry to keep replying to my own post - does the timestamp field need to be part of the form as well?

[MMcCarthy]

I'm using Access to create forms with a SQLExpress backend.

My form is for logging purchases. I have a date ordered and a date delivered. (I know the write issue comes from the date)

I've tried adding a TS colum to all of my tables with a timestamp data type (allow nulls). - Still get the error.

My recordset type is "updateable snapshot".

Not sure what else to try. I've looked at all the others with this issue but have yet to find a solution that works for me.

Thank you so much.

This may be a formatting issue. Access stores dates as numbers and this can sometimes cause problems with conflict in date formatting. You may be trying to store dates the invalid numbers representing months as 09/23/06 in mm/dd/yy format has been translated as dd/mm/yy and there is no month 23. To get around this and see if it is the problem change all the date formats to dd-mmm-yyyy. This should stop the confusion.

Mary

[PRLIT]

Should my SQL be Datetime or shortdatetime? What format exactly should the access form be? Thanks!

[MMcCarthy]

Should my SQL be Datetime or shortdatetime? What format exactly should the access form be? Thanks!

It won't matter what the sql is because access will pass it as a number. The access format needs to be medium date time. Access is the problem here not the sql.

Mary

[PRLIT]

dd-mmm-yyyy

Do you mean dd-mm-yyyy?

[PRLIT]

dd-mmm-yyyy

Do you mean dd-mm-yyyy?

Changed Access to "short date" dd-mm-yyyy

Still get error.

Thank you so much for helping me with this. I've posted on 4 forums now and seems like everyone is stumped.

[MMcCarthy]

dd-mmm-yyyy

Do you mean dd-mm-yyyy?

No I mean dd-mmm-yyyy (23-Jan-2006)

Access can switch between UK and US date formats so ...

23/01/2006 can be changed to 01/23/2006 which is an invalid date value under dd/mm/yyyy. Using the above format in Access prevents this problem.

Mary

[PRLIT]

hmmm still nada. I really thought I had it. Changed access to "medium date" dd-mmm-yyyy and still got write conflict. I really think this does have something to do with SQL though.

[MMcCarthy]

hmmm still nada. I really thought I had it. Changed access to "medium date" dd-mmm-yyyy and still got write conflict. I really think this does have something to do with SQL though.

Post the actual VBA code you are using maybe something will jump out.

Mary

[PRLIT]

Option Compare Database
 
Private Sub Command23_Click()
On Error GoTo Err_Command23_Click
 
 
    DoCmd.GoToRecord , , acNewRec
 
Exit_Command23_Click:
    Exit Sub
 
Err_Command23_Click:
    MsgBox Err.Description
    Resume Exit_Command23_Click
 
End Sub
Private Sub Command24_Click()
On Error GoTo Err_Command24_Click
 
 
    DoCmd.GoToRecord , , acNewRec
 
Exit_Command24_Click:
    Exit Sub
 
Err_Command24_Click:
    MsgBox Err.Description
    Resume Exit_Command24_Click
 
End Sub
 
Private Sub Form_Activate()
Dim rs As ADODB.Recordset
Set rs = Me.Recordset.Clone
rs.Bookmark = Me.Bookmark
DoCmd.RunCommand acCmdRefresh
Me.Bookmark = rs.Bookmark
rs.Close
Set rs = Nothing
End Sub
 
Private Sub Form_Deactivate()
DoCmd.RunCommand acCmdSaveRecord
End Sub
 
Private Sub Office_ID_AfterUpdate()
    Me.Office_Name = DLookup("[Office_Name]", "Office", "[Office_ID]=" & Me.Office_ID)
 
End Sub

[MMcCarthy]

1. Are your tables linked to the Access database through odbc?
2. Is the form bound to one of these tables?
a) If so why are you running a save command in the form deactivate event?
b) If not how are the records being saved to the backend?

Mary

[PRLIT]

1. Are your tables linked to the Access database through odbc?
2. Is the form bound to one of these tables?
a) If so why are you running a save command in the form deactivate event?
b) If not how are the records being saved to the backend?

Mary

If it helps, I'm opening an ADP file in access. I connected to the server and all my tables, data was there.

Is the form bound to one of these tables? - I use the form Wizard at frist and it lets me choose from the existing tables. If I enter directly into the tables, it all updates just fine.

[MMcCarthy]

If it helps, I'm opening an ADP file in access. I connected to the server and all my tables, data was there.

Is the form bound to one of these tables? - I use the form Wizard at frist and it lets me choose from the existing tables. If I enter directly into the tables, it all updates just fine.

Just out of curiousity remove any formatting or masks from the date controls and see if you still have the problem.

Mary

[PRLIT]

Just out of curiousity remove any formatting or masks from the date controls and see if you still have the problem.

Mary

Any just make them varchar?

[MMcCarthy]

Any just make them varchar?

Just change the formating on the ADP form not in the data.

Mary

[NeoPa]

I've been trying to look through this thread today and I find that there is simply not enough correct information. It is impossible to find an answer because fundamental information is only provided many posts after it is needed.
If you are still interested in getting an answer to this then please re-post from the beginning, paying particular attention to the instructions in POSTING GUIDELINES: Please read carefully before posting to a forum.

Table MetaData is likely to be required in this case (see example provided below for the format of this info) :

Table Name=tblStudent
 Field; Type; IndexInfo
StudentID; Autonumber; PK
Family; String; FK
Name; String
University; String; FK
Mark; Numeric
LastAttendance; Date/Time

Please don't misunderstand, we do want to help. It is simply that the information you're providing is not adequate for understanding your problem via a website.

MODERATOR.