add new column to access 97 table.

Dianne Ice

Delphi Developer

Sat, 15 Jan 2005 00:55:55 GMT

add new column to access 97 table.

I need to made changes to an old D3 application using the Diamond Access
components and add a new column to an access 97 table.

All ideas on the best way to do this are appreciated.

Thanks,

Dianne

Vassiliev V.V

Delphi Developer

Sat, 15 Jan 2005 15:01:19 GMT

Re:add new column to access 97 table.

You can execute

Alter table [TableName] Add Column [ColumnName] Varchar(50)

Regards,
Vassiliev V.V.
http://www.oledbdirect.com

"Dianne Ice" <dia...@pcsonline.com> ???Y/???Y ????? ???Y??:
news:3d457246_1@dnews...

Quote

> I need to made changes to an old D3 application using the Diamond Access
> components and add a new column to an access 97 table.

> All ideas on the best way to do this are appreciated.

> Thanks,

> Dianne

Other Threads

1. How do I add an new BLOB or MEMO column to remote table

2. Accessing Access 97 Tables from Delphi3

3. Add column to an Access table ?

4. adding columns to access table

5. D5-ADO-MS ACCESS 97 database-MS Office 97 Access ODBC driver-Autoincrement probs

6. Find text width in Word 97 table column

7. Access 97 and TTable 10-column limit

8. Repost: Access 97 and TTable 10-column limit

9. Adding to Access 97 DB using DAO

10. Problem adding a table in Word 97 - range problem