VB 6
-
I made a simple database program. I wanted to use it at work. I used MS Access as my database. I have finished everything and made the .exe file for the program that i made. I'm wondering if you guys could help me connect my program to my database (MS Access), without going into like using the ODBC. I just want to connect my program to my database using some codes. jct
-
I made a simple database program. I wanted to use it at work. I used MS Access as my database. I have finished everything and made the .exe file for the program that i made. I'm wondering if you guys could help me connect my program to my database (MS Access), without going into like using the ODBC. I just want to connect my program to my database using some codes. jct
Well, you've given us no details about what you want other than 'connect'. Besides, if you've already got the database done in Access and you've already written the VB code, what's the problem? You should have been testing the code against the database already...?? You can start with this[^] for a guide on how to connect to various data sources and use them. Your connection string will probably look something like this:
Dim strConnect as String
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=C:\Documents and Settings\username\My Documents\dbFile.mdb"RageInTheMachine9532
-
I made a simple database program. I wanted to use it at work. I used MS Access as my database. I have finished everything and made the .exe file for the program that i made. I'm wondering if you guys could help me connect my program to my database (MS Access), without going into like using the ODBC. I just want to connect my program to my database using some codes. jct
:) Try Planet-source-code.com
-
Well, you've given us no details about what you want other than 'connect'. Besides, if you've already got the database done in Access and you've already written the VB code, what's the problem? You should have been testing the code against the database already...?? You can start with this[^] for a guide on how to connect to various data sources and use them. Your connection string will probably look something like this:
Dim strConnect as String
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=C:\Documents and Settings\username\My Documents\dbFile.mdb"RageInTheMachine9532
Thanks so much for the reply. And to give you a bit of details on the simple program that i have created, well, i usually used ADO as my mediator between my program and my database (connection). The program is working fine. But when i try to create the .exe file and run it to my computer at work, it won't run since it tries to seach for msstdfmt.dll and i can't just install the dll file cause my computer has admin rights and i don't have access on it. So, i'm wondering if i could connect my program to my database without using ADO and just use codes to have it connected. ;)
-
Thanks so much for the reply. And to give you a bit of details on the simple program that i have created, well, i usually used ADO as my mediator between my program and my database (connection). The program is working fine. But when i try to create the .exe file and run it to my computer at work, it won't run since it tries to seach for msstdfmt.dll and i can't just install the dll file cause my computer has admin rights and i don't have access on it. So, i'm wondering if i could connect my program to my database without using ADO and just use codes to have it connected. ;)
Well, from what I can find, msstdfmt.dll is the Data Format object library. You could TRY recoding the app to use DAO, but I think without that file, you're out of luck as Access installs it when you install Office and I think no matter how you go about getting to the database, the Jet Database engine still needs this dll to do it's work. RageInTheMachine9532
-
Well, from what I can find, msstdfmt.dll is the Data Format object library. You could TRY recoding the app to use DAO, but I think without that file, you're out of luck as Access installs it when you install Office and I think no matter how you go about getting to the database, the Jet Database engine still needs this dll to do it's work. RageInTheMachine9532