Thanks for your reply all,
I resolved the issue on my end by changing the connection string replacing Jet Engine to ACE engine. I works on windows 7 , the issue appears after update the windows.
Thank you for your reply.
Yes, My macro code is connected to the table access rate.mdb called A which the access tables is linked to excel file (refresh by linked table manager).
Can you inform me how to check the status connection to the mdb file?
Thanks
Hello Everyone
Just wanted to introduce myself. My name is Marcho, and I'm an employee that wants to learn how to build the reports and automate my work.
I am new beginner and have little experience in excel VBA and still studying until now.
:)
Hi All,
Can anyone help me with these error warning on my macro code:
Run-time error ‘-2147217900(80040e14)’ :
Invalid SQL statement; expected ‘Delete’, ‘Insert’, ‘Procedure’, ‘Select’, or ‘update’
The code are:
Public Sub calculate()
Const Src = "DATA.mdb"
Const Dest = "OutputC.mdb"
Const...