Can run update query programmatically in windows 7

Y

Yance

Joined
Sep 11, 2009
Messages
2
Reaction score
0
Hi...i use microsoft Access 2003 with Windows 7 Ultimate OS. I have an application build in Microsoft Access 2003. I'm using update query in VBA code to update the record of the table:

Dim tSQL

tSQL = "UPDATE ipaket SET durasipaket = 2 WHERE kpaket='PK-01'"

DoCmd.RunSQL tSQL

It's running well on Windows XP but not in Windows 7. I've tried use the ADODB recordset and etc but doesn't work too. Any one can help me?

Regards,

Yance
 
Last edited:
I have the answer for my self.

Oh... i've found the answer for my problem. Thanks for all that view my post.
 
Last edited:
Back
Top