VBA and MS Access

[nilesh]

Hi, plea for help.

I have existing MS Access database,
I wants to add new records in existing table from other Windows based HMI
(human machine interface) application which is supporting VBA.

can i use that HMI VBA to add new records

can u please give me some suggestions how to do that

thanking you

nilesh

 

[Brendan Reynolds]

Check out the article at the URL below. It shows how to access a database
from Word, but should be easily adapted to any VBA host ...

http://msdn.microsoft.com/library/d...-us/dnoffpro01/html/GettingStartedwithADO.asp