Query Access Database

[moscas]

can be queried to select, insert, update a database access?

[moscas]

nothing for access database? I managed to open only with SQL lite database in memory but not save as *. mdb

[GEOSoft]

Try the functions in this link

http://dundats.mvps.org/autoit/udf_code.aspx?udf=access

I forget what is in there and I don't support it any longer. As a matter of fact, you may be the last poerson that gets to download it, as well as many other bits of code from the site.

[moscas]

==> Error opening the file.: 
#include <AccessConstants.au3>

[GEOSoft]

That's probably because you didn't download the whole package. Download the zip file (Download button or download link at the bottom). and place both files in your AutoIt3\include folder

[l4tran]

Hi,

I'm having a problem just opening the database. I'm using Access 2000. What seems to be the problem?

#include <Access.au3>

Const $dbname = "C:\Khanh\naildata.mdb"

Const $tblname = "Services"

$cfields = _accessCountFields($dbname, $tblname)

Error message:

C:\Program Files (x86)\AutoIt3\Include\Access.au3 (689) : ==> The requested action with this object has failed.:

$oADO.Open ($adSource)

$oADO.Open ($adSource)^ ERROR

[GEOSoft]

See my previous reply and make sure you have the constants file in the include folder.

Also, this has never been tested on Office 2000 by me. I don't know if others have tried it or not.