I am working on a project in VB 6.0, Access 2000 in Germany. As this is my first project in Visual Basic and i dont have much knowledge about Access i am facing many problems. I hope you will reduce my strain to some extent.
The company where i am working manufactures water meters and test them for water flow, heat etc etc...so all these data was stored in different formats because of different development periods. The data in Access 97, dBase 3, and Ascii(text) formats. Now all these should be converted to Access 2000.
They need a software to be developed in Visual basic 6.0 to convert these format into one single Access 2000 format. So how can I convert them into one. PLease guide me. If you have any sample programs with code please send me.
Hope you will do it for me.
Thanks in advance.
Solution of VB
Posted by spida
on 07/09/2004 12:42pm
You can write the code to open database in VB using connection object i.e. Dim cn as new ADODB.Connection...write the code to open access 97 database...write the logic using OpenRecordset method to insert in the new database table. similarly open for DBASE
I need to develop a datareport in VB which diplays data from more than 100 fields of 6 tables from Oracle server.
Using a dataenvironments command recordset set to a select query with many relations to connect the table (it is time comsuming ), Please do suggest the procedure to write a stored procudere to access the same 100 fields using more than 1 select query.
As i need to achieve Master/Detail relation form, i'm using header and detail section for the header i'm using dbcombo list box which will contain the data from one of the master table and acts as a primary key and for the detail i'm using True dB grid7 and placed one drop down combo box as of the field which will populate records from one of the master file and the placed the foreign key also but made visible property false.
If some one having the same type of problem please try to send me a source code with screens or guide me in completing this program properly
Thanks in advance
I am developing a software using VB as frontend and Access as backend.
I have problem of join query for more than one tables. If I'm using Access-97 the query doesnot work, but if I'm using Access-2000 the query works. That is, I am not able to insert records in 97 version, but I am able to view the records and navigate the record set.