please how can i create a database and link it to my VB6 application. i designed a VB application to hold bio-data that will be updated from time to time but am finding it difficult to create the access back-end for it. please any urgent help will be most welcomed.
There a few ways of using MS-Access databases with VB6, depending on whether you want to always use the same database or you want to choose which database at run-time. If you are always connecting to the same database, create a new Database project and connect to the database you created using MS-Access (Jet engine only). This will be the easiest way because you get all sorts of GUI help from the IDE.
If you want to decide which database you want to use at run-time, you can use DAO or ADO. DAO (Data Access Objects) is easier to use when directly connecting with an Access database. You can work with tables and queries in the database, but you can not use anything else, like forms and reports, that might be stored in the database as well. ADO (Advanced Data Objects) is better if you are using another type of database or going through ODBC.
Include a reference to DAO in your project. Create a module and put a Database object there; this way, all your VB6 forms can use the Database.
Public dbsProject AS Database
Also, it can be a good idea to create a Sub Main in this module which sets this to nothing.
Public Sub Main
Set dbsProject = Nothing
frmMain.Show vbModeless, Me
Once you link in the DAO library, there is lots of information available in the help system. To add tables to your database, starting looking at CreateTableDef. To use the tables, look at OpenRecordset. For working with queries, look at CreateQueryDef. This can get you started working with DAO.
Edited 3 Years Ago by Nutster: Add a little more detail.
please how can i create a database and link it to my VB6 application. i designed a VB application to hold bio-data that will be updated from time to time but am finding it difficult to create the access back-end for it. please any urgent help will be most welcomed
This is less information about what makes you hard to code it?
How far you doing this? Post your code and we'll trying to help it.
You can use ADODB to linked vb6 with access.
Write a C program that should create a 10 element array of random integers (0 to 9). The program should total all of the numbers in the odd positions of the array and compare them with the total of the numbers in the even positions of the array and indicate ...
I have a 2d matrix with dimension (3, n) called A, I want to calculate the normalization and cross product of two arrays (b,z) (see the code please) for each column (for the first column, then the second one and so on).
the function that I created to find the ...