MS Access 2010 with mdb database

Question

I am trying to add a command button (having simple code) on Microsoft form created in MS Access 2003(mdb) and try to save it in MS Access 2010 in same db format (mdb), I am getting the following error  "This form or report contains changes that are incompatible with the current database format. The form or report was not saved." And when i tried same over MS Access 2003, there is no error. Seems that there is some compatibility issue. Can anyone suggest, how can i rid of above error? I want to work on mdb file on MS Access 2010.

Answer 1

the button is only on text mode and i again test this after compact and repair. Still the same error.

but i noticed one thing, i am try to add command button in tabbed form page where i am getting error. If i do it in simple form i am able to save the form without any error.

Answer 2

Two things to check. In Access 2010, buttons can have BOTH a graphic AND text. Maybe you have set it to display both and that's causing the incompatibility.

Make sure you compact and repair in 2003 before you open in 2010.

Answer 3

Thanks for your reply!

Here's the description what i am doing.

1. I opened already exist mdb file on MS Access 2010.
2. Then i add a command button on form layout
3. I added following line of code on click event of new command button.

If Me.Dirty Then    'Save any edits.

Me.Dirty = False

End If

If Me.NewRecord Then 'Check there is a record to print

MsgBox "Select a record to print"

Else

strwhere = "[ID] = " & Me.[ID]

DoCmd.OpenReport "qckprint1", acViewPreview, , strwhere

End If

4. when i click on Save icon button. I am getting the following error. Basically i am not changing the format i am trying to save it on mdb format.

"This form or report contains changes that are incompatible with the current database format. The form or report was not saved."

---

5. It's working fine when i tried the same on MS Access 2003.

I don't know if i can attach the file over here.

Answer 4

I am trying to add a command button (having simple code) on Microsoft form created in MS Access 2003(mdb) and try to save it in MS Access 2010 in same db format (mdb), I am getting the following error  "This form or report contains changes that are incompatible with the current database format. The form or report was not saved." And when i tried same over MS Access 2003, there is no error. Seems that there is some compatibility issue. Can anyone suggest, how can i rid of above error? I want to work on mdb file on MS Access 2010.

Not entirely clear. Are you trying to add a button using Access 2010, but saving the file as an MDB file? if you opened the file as an MDB then you shouldn't have to save it, just save the objects. If you are trying to save an ACCDB as an MDB then you will lose 2010 features.

I've worked on several MDB using 2010 and had no problem adding controls.