Problem moving Access 2007 Database from win XP to Win 7 64 bit machine

I have a split access 2007 database that has been running fine on a xp machine. I have recently tried moving the database开发者_Python百科 to a new hosting machine that is running win 7 64 bit, but I'm having a few problems.

I have installed office 2010 small business (word, excel, PowerPoint) and the access 2007 runtime on the new machine.

My problem is that I can open the database but only as a read only. I also get the error message on some forms "Error: 3326: This recordset is not update-able".

I have checked (and double checked) that the database . Accdb file is read only and removed the read only attributes at the command prompt. Also all users have full control set in permissions.

I must admit I expected there to be teething problems but I'm at a loss as to how I can't even get the database to be editable.

I couldn't get this working in Office 2010. I did however simply cut and paste the db files in different locations on the main computer and promptly pasted them back in the original location. I also reverted back to using office 2007. This seems to have resolved the issue, albeit not in a very satisfactory manner.