Visual basic 6

Question

How to open a Microsoft Access Database (.accdb) 2010 file in VB 6.0 preferably using visual data manager?

Answer 1

It sounds to me as if you want to work with the records in an Access table (as opposed to running an Access application) from a VB6 project).

You can use the DAO library appropriate to the database version to do that.  Your VB6 code can then use queries, recordsets, etc. to retrieve records from the table and do whatever with the fields in you VB6 project.

You would be better served by asking specific questions about details of doing that in a VB6 forum.

Answer 2

Hey, would you please explain how to use SHELL, Actually am a novice in this field and.

     I have copy all data from a Microsoft (2010) Excel Worksheet (.xlsx) file and paste in a Microsoft (2010) Access Database (.accdb) file. And want to use this file as the database for a VB 6 project. How to do this or how to change the file in compatible one?

    Using Add-ins --Visual Data Manager--   I think I have to input data one by one, but this is problematic, I have data for some 90 machine .

Answer 3

This is a matter of VB coding, not really Access. So I suggest asking in an VB help forum.

Answer 4

I'm not sure about VDM, but I would use ShellExecute API with the OPEN verb.

Answer 5

Do you mean launch an MS Access database?

Have you try using SHELL?