sivasubramaniam_it
asked on
SQL Queries to create,delete,rename a column column
sir,
how to create,delete,rename a filed in MS-ACCESS database by using SQL Queries. i am using visual basic 6.0 as a front end. The database is in Access 97 format created by using Visual dataManager in Visual basic 6.0. i feel great if the Queries are in VB example.
how to create,delete,rename a filed in MS-ACCESS database by using SQL Queries. i am using visual basic 6.0 as a front end. The database is in Access 97 format created by using Visual dataManager in Visual basic 6.0. i feel great if the Queries are in VB example.
http://experts.about.com/q/Visual-Basic-1048/Connecting-multiple-access-tables.htm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Go with dmitryz6's suggestion and use ADOX.
Leon
Leon
ASKER
i have get the solution for add and delete but i need how to rename.
for add
alter table table_name add field_name type
for delete
alter table table_name drop [column] field_name
for add
alter table table_name add field_name type
for delete
alter table table_name drop [column] field_name
Try this, not sure It supported,if not use adox or DAO
ALTER TABLE table_name
RENAME COLUMN field_name to field_name1
ALTER TABLE table_name
RENAME COLUMN field_name to field_name1
ASKER
sir,
it is not woking(rename) visual datamanager.
it is not woking(rename) visual datamanager.
Yes, what way sugested to use ADOX or ADO.
if you don't like to do it.Youcan Put data in temprory table.
Use Alter drop statement to delete dat
Use Alter Add statment to add column
And return dat back.
But better use Adox or DAO
if you don't like to do it.Youcan Put data in temprory table.
Use Alter drop statement to delete dat
Use Alter Add statment to add column
And return dat back.
But better use Adox or DAO