Has Any Member Tried to MS Access with the below Example

https://help.tallysolutions.com/art...gration_capabilities/using_odbc_interface.htm

Does the Given example is working ?

 

Yes.. it works..

apart from driver specification, nothing is different in it from excel integration

 

Thanks for reply, Is Driver statement "ODBC : "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\Masters.mdb;Uid=;Pwd=;" correct ?
Since, a week I tried all possible settings and 32 os, etc., but, no success. Requested your help to open and access .mdb file in Tally.

 

There may Tally ODBC driver problem in your PC

Clean tally program folder and re install a fresh copy

 

Thanks for your Tip. The code is working fine in win32 OS, But Not Working in Win 10 64 bit OS, Trying to find the Driver Issue.

Note : As soon you create Database, Access create auto create ID Field, Hence, you have to access the Fields with $_2, $_3, etc., ..........

 

Update : After Uninstalling Office 32bit, then installing MS Access 64 Runtime, It is working fine. Still Not Found Solution for 64 bit Os and 64 bit Tally and 32bit Office.

 

Tally 64 bit (Installing Regodbc32.exe and Tallywin32.dat)
Office is 64 bit
and
OS is 64 Bit

I spent alot of time

in the last "Run As Administrator" Works.