Can run update query programmatically in windows 7

[Yance]

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

 

[Yance]

I have the answer for my self.

Oh... i've found the answer for my problem. Thanks for all that view my post.