Nu11Byt3 Posted July 2, 2011 Posted July 2, 2011 (edited) Hi,This is my first post here.I hope i will get the solution. I am making a GUI based app and i need to insert data into table .I am using MS Access for database. This is my code which i ma trying: $_dbname = "C:\Autoit files\auto\sample.mdb" $tblname = "login" $query = "insert into login values(GUICtrlRead($file1),GUICtrlRead($file2),GUICtrlRead($file3))" $adoCon = ObjCreate("ADODB.Connection") $adoCon.Open("Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & $_dbname) $adoCon.Execute($query) $adoCon.Close Edited July 2, 2011 by Nu11Byt3
spudw2k Posted July 5, 2011 Posted July 5, 2011 (edited) do a search for ADO or ADODB in the forum and you will see tons of examples of how to interface with an access (jet) db (i have one I made in my signature). Someone has even made an Access UDF for automating the application (or COM) itself. Edited July 5, 2011 by spudw2k Spoiler Things I've Made: Always On Top Tool ◊ AU History ◊ Deck of Cards ◊ HideIt ◊ ICU ◊ Icon Freezer ◊ Ipod Ejector ◊ Junos Configuration Explorer ◊ Link Downloader ◊ MD5 Folder Enumerator ◊ PassGen ◊ Ping Tool ◊ Quick NIC ◊ Read OCR ◊ RemoteIT ◊ SchTasksGui ◊ SpyCam ◊ System Scan Report Tool ◊ System UpTime ◊ Transparency Machine ◊ VMWare ESX Builder Misc Code Snippets: ADODB Example ◊ CheckHover ◊ Detect SafeMode ◊ DynEnumArray ◊ GetNetStatData ◊ HashArray ◊ IsBetweenDates ◊ Local Admins ◊ Make Choice ◊ Recursive File List ◊ Remove Sizebox Style ◊ Retrieve PNPDeviceID ◊ Retrieve SysListView32 Contents ◊ Set IE Homepage ◊ Tickle Expired Password ◊ Transpose Array Projects: Drive Space Usage GUI ◊ LEDkIT ◊ Plasma_kIt ◊ Scan Engine Builder ◊ SpeeDBurner ◊ SubnetCalc Cool Stuff: AutoItObject UDF ◊ Extract Icon From Proc ◊ GuiCtrlFontRotate ◊ Hex Edit Funcs ◊ Run binary ◊ Service_UDF
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now