[Question] Drop Changes

[papasilo]

Hi,

I just wanna ask if, what is the cause of this Drop Changes?..
I'm using MySQL as my BackEnd.

I already added a field timestamp and default it as Current_Timestamp
some records can be change but there are also records that cannot be change on a the same table due to an error called Drop Change because "a record is access at the same time".. thats why the record cannot be edited.

Any possible solution for this problem?

By the way.. what I did is.. I made a temporary table first then paste it to the master table.. after which I tried to edit the record but some records can't be edit. but some records can be edit..

I hope my question is understandable and I hope also i'm in the right thread..

Thanks!

 

[vbaInet]

You get a message box that asks you to Drop Changes or Save it to the Clipboard right?

That happens when you have two forms or queries bound to the same table and you edit both whilst they are open.

 

[papasilo]

Hi vbaInet!

Thanks for the reply, you said two forms or queries bound to the same table which make it drop changes.

But even thou i go directly to the table without other forms/queries/reports and edit the data still the Drop Changes or Save it to the Clipboard message appears and the data is non-editable.

But I like I said before, the are selected data that is editable and the are also data who non-editable in the same table.

Which is a really really big question why does it happen?

 

[boblarson]

But I like I said before, the are selected data that is editable and the are also data who non-editable in the same table.

What is non-editable in that table? If you go directly in the table EVERYTHING except autonumbers should be able to be edited (unless you have used a Calculated Field datatype). What version of Access are you using?

Which is a really really big question why does it happen?

That's what we're trying to figure out and sometimes it isn't easy to figure out when we're not right in front of it like you are. So we have to sometimes ask a lot of questions.

 

[papasilo]

Hi Bob,

Thanks for the quick reply, emm.. its not about the fields.. im using mySQL as my backend.. i didn't use autonumber as a datatype, what i mean is there are Rows that are editable / can be update or there are some who can't be update.

I hope this will be understandable ^_^

 

[papasilo]

I will give u sample vid of the situation ^^

 

[vbaInet]

Are you saying if you open the table on its own and edit a record, it will bring up the message.

Tell us the exact steps you take to get the error? A video might help as well.