For VB6.0, i would advice you create your projects and the database file in the C:\ drive. You can create a folder there to save projects so when you move your project folder to another system, the name and directory of the Access Dbase file remains the same.
Having said that, here is the code for MS Access connection:
Public conn As New ADODB.connection
Public rs As New ADODB.Recordset
Set conn = New ADODB.connection
conn.Open "Provider = Microsoft.Jet.OLEDB.4.0; Data Source=" & App.Path & "\data\DataBaseName.mdb"
thank u so much sir...it helps a lot...sir can you put a comments on your sample code especially line 5-7 so that i can understand it also...more power and God Bless sir...by the way sir i'll mark it now solve....
I am writing a java program that needs to execute shell commands, so I wrote a function that would take the command to execute as a string (ie: "mkdir ~/Folder1") and execute that command with the shell. Here is the function:
Runtime run = Runtime.getRuntime();
Process pr = ...
Hi, as I was told that my code doesn’t scale well at all, I thought perhaps I’d try to get a better understanding of interfaces/abstract classes and classes and the relationship between them.
I don’t want at this stage work on a big separate project as I've already got plenty ...
Hi. I have a form with list box : lst_product, datagridview : grd_order and button: btn_addline. lst_product has a list of product ids selected from database (MS Acess 2013) , grd_order is by default empty except for 2 headers and btn_addline adds rows to grd_order.