Creating an Access table in VB

[harrisw]

How can I create an access table using purely vb6.

I want the user to be able to specify how many columns the table will be in the vb app

I also need to be able to sort an existing table in the access database by a certain column.

2 questions in one.

Any ideas?

 

[Pat Hartman]

1. You can build DDL in code and run it as a pass-through query. Look up CREATE TABLE for syntax. You could also use ADO.

2. Add an Order By clause to your query.

 

[harrisw]

AM using ADO but can't find a command to create table. I've also tried MS Knowledge base