Nu11Byt3 Posted July 2, 2011 Share 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 Link to comment Share on other sites More sharing options...
spudw2k Posted July 5, 2011 Share 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 BuilderMisc Code Snippets: ADODB Example ◊ CheckHover ◊ Detect SafeMode ◊ DynEnumArray ◊ GetNetStatData ◊ HashArray ◊ IsBetweenDates ◊ Local Admins ◊ Make Choice ◊ Recursive File List ◊ Remove Sizebox Style ◊ Retrieve PNPDeviceID ◊ Retreive SysListView32 Contents ◊ Set IE Homepage ◊ Tickle Expired Password ◊ Transpose ArrayProjects: Drive Space Usage GUI ◊ LEDkIT ◊ Plasma_kIt ◊ Scan Engine Builder ◊ SpeeDBurner ◊ SubnetCalcCool Stuff: AutoItObject UDF ◊ Extract Icon From Proc ◊ GuiCtrlFontRotate ◊ Hex Edit Funcs ◊ Run binary ◊ Service_UDF Link to comment Share on other sites More sharing options...
Nu11Byt3 Posted July 9, 2011 Author Share Posted July 9, 2011 Thank you spudw2k Link to comment Share on other sites More sharing options...
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