database not working after go to window 7

[lovedieer]

I have a database build with access 2007 with window xp and it works well in my office, it also worked well with window 8 on my home computer. but recently my office computer was updated to window 7 and office 2010, and my database were not working since then. it keep saying there are compile error. The visual basic module contains a syntax error. check the code and then recompile it.
i tried several different coworkers computers in our office, it looks like doesn't matter which version of access, only related to window system. Does anybody have experience with solving this problem?

 

[spikepl]

I am really curious: the system tells you what the problem is, and even suggests what to do about it. And yet here you are, asking a question . Do you expect us to outwit Microsoft and come up with some alternative suggestion or what exactly are you asking for?

 

[lovedieer]

Ok. I think i am not clear on my question. I mean the database are working well on window xp and window 8 system, but it's only not working on window 7. Actually my database was developped based on a access 2007 template (projects template), the code has compile error was not written by me, it's from the template, i don't even touch that pieces. and not one or two pieces codes has error, almost all the froms and queries did not working under window 7, but no problem with other window system.
What i am looking for is not how to fix the code, because i did not see any problems with the codes. instead i want to see how to fix the version un-compatible problem. If somebody has the experince, please help.

 

[lovedieer]

Re: update solved. database not working after go to window 7

I did several research yesterday, and found some solution, probably it will give a clue when anybody has the issues
1) try to decompile the database with the below steps: (source: http://www.fmsinc.com/MicrosoftAccess/Performance/Decompile.asp )

1. From the Windows, Start, Run command line, type: msaccess.exe /decompile
   where msaccess.exe includes the complete path. For example, for Access 2010:
   C:\Program Files\Microsoft Office\Office14\MSACCESS.EXE /decompile
2. From Access open the database you want to decompile (with trusted authority for Access 2003 or later)
3. Open up any module. Compile it via Debug, Compile.., then File, Save.
4. Go back to the database and Compact it. The location of the Compact command varies by Access version.

2)Try to find the missing reference. source: http://www.techonthenet.com/access/questions/compile_error.php

"Compile error.in query expression"I've seen this function work in other Access databases. How come it does not work in mine?
Answer: This error can occur when there is a broken Reference in your Access database and you've tried to use one of the built-in Access functions such as Left, Instr, Len, Year, Mid, etc.
To correct the problem, you need to open your Access database. Press Alt-F11 to open the Microsoft Visual Basic window. When the Microsoft Visual Basic window appears, select References under the Tools menu.

 

[lovedieer]

I think my problem is the database was based on 32 bit system and my new system is 64 bit system. some code do not really supported by the new system.
thank you for everybody to give me the response.

 

[pr2-eugin]

I thought that might be a case.. Try declaring all Library functions that you use in your code as PtrSafe.

 

[lovedieer]

I thought that might be a case.. Try declaring all Library functions that you use in your code as PtrSafe.

You are absolutely right. I forgot to mention i also did this change. Thanks.

 

[pr2-eugin]

So you got it working ?