Compatibility of mdb Format Over Ms Access 2010, Office 2010

[ashok4814]

While adding any simple command button (having 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."

This way i am not able to add any control on mdb format using MS Access 2010. Could anyone help me out how it can be possible?

[alansidman]

My understanding (although I am using 2007) is that any mdb file updated in 2010 is not backwards compatible to earlier versions. So I am guessing that you need to make the file an accdb file. This is one of the reasons that I have not moved to 2010 as I still have a need to maintain mdb files.

Alan

[ashok4814]

Thanks for your reply Alan!! it's not good that MS Access 2010 doesn't have backward compatibility. It should be actually. Atleast there should be some workaround. In my one of the client there are about 5000 users and everybody is not willing to work on 2010.

[alansidman]

I wasn't entirely correct. However, here is a link to MS that clarifies.

http://office.microsoft.com/en-us/ac...010341553.aspx


I think this thread here explains the compatibility issue

http://answers.microsoft.com/en-us/o...e-dfe7908f07ed


Alan

[1eye1vision]

In access 2010, you can save the mdb format,
when saving goto Save and Publish, this will allow you to save in the mdb format....

[ashok4814]

I am talking about different issue. I am trying to open mdb file over MS 2010 and try to add a command button on form and then try to save it within mdb format and getting error over there.

[ashok4814]

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.

[rpeare]

What is the code you're trying to run?

[boblarson]

Ashok:

Are you using Access 2010 64 bit? If so, I think that may be your problem.

[ashok4814]

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.

[ashok4814]

Ashok:

Are you using Access 2010 64 bit? If so, I think that may be your problem.

Bob,

I am using MSA Version 14.0.4760.1000 (32 bit)

[boblarson]

Bob,

I am using MSA Version 14.0.4760.1000 (32 bit)

Then you might want to go change your profile here because it looks to me that you are using Office 2010 64 bit from this:

[ashok4814]

Then you might want to go change your profile here because it looks to me that you are using Office 2010 64 bit from this:

Thanks Bob

[nicknameoscar]

Could this be the infamous "Trusted locations" issue?

[ashok4814]

Could this be the infamous "Trusted locations" issue?

nope..it's not related to trusted location