vb database manager

[test1357]

hello all,

I would like to ask if you have in mind any database manager written in visual basic. What I want to do is to manage an ms access database through jet sql syntax. For example I would like to create a number of tables or other batch proccesses.

 

[TomKane]

VB6 comes with visual data manager - sorry if I'm pointing out the obvious. One thing I do like about it is that it can create forms for your tables.

 

[CCLINT]

Through JET DDL you can create/alter tables, fields, indexes, etc.

.Execute "CREATE TABLE TestTable...."

Look up help on the keywords "CREATE TABLE" "CREATE COLUMN" "ALTER TABLE"

You can also do this through ADOX. Add a reference to the "Microsoft ADO Ext. 2.5 for DDL and Security"