MS Access 2007 -2010 & 32bt to 64bt Issues

Asked By Green Scott 50 points N/A Posted on - 10/22/2012

Hi

I have recently upgraded MS office 2007 to MS office 2010.

When I tried to open an application that I made in MS access 2007 in MS office 2010, I got an error.

Actually the application was made in MS access 2003 that I later converted into MS access 2007.

Now it is not converted into MS access 2010.

The screenshot of the error message is attached below:

Compile Error

The code in this project must be updated for use in 64 bit systems. Please review and update Declare statements and then mark them with the PtrSafe attribute.

OK Help

Any help in this regard will be highly appreciated?

Looking forward to your comments

Kindest regards

• Status: Open
• Question Views: 919
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Access

Best Answer by Gazelle Eliza

Go To Solution

Answered By Anthony Pepito 0 points N/A #191762

MS Access 2007 -2010 & 32bt to 64bt Issues

Hi

Ms Office is backward compatible. You need to open ms access file in ms access2007 and save to its native format. The reason for this is new 64bit architecture of machines. The old version of ms acess2007 was saving application for 32bit architecture now which is transform in 63bit. You need to compile you application again in ms access 2007 and then save.

Thank you

 

About Anthony Pepito

Questions
4

Answers
104

Best Answers
25

• Vote Up 0 Vote Down

• Posted on - 10/22/2012
• Question Category: MS Access

Best Answer

Best Answer

Answered By Gazelle Eliza 0 points N/A #191763

MS Access 2007 -2010 & 32bt to 64bt Issues

 

 

 

If you have updated to MS Office 2007 64Bit from a 32bit version then you are heading the wrong way, but the error message “the code in this project must be update for use on 64bit systems….” Also emphasize the solution you are looking for, the line “…marks them with the PtrSafe attribute” is your solution. In your API and function declaration add the line “PtrSafe” as like the following “PrivateDeclare Ptrsafe Function….” In order to make your code compatible between 64bit and 32bit in MSACESS always add the PtrSafe to it. 

About Gazelle Eliza

Questions
3

Answers
30

Best Answers
10

• Vote Up 0 Vote Down

• Posted on - 10/23/2012
• Question Category: MS Access