Rename Access Table which is using a reserved name

Glenn Shukster

Delphi Developer

Sat, 27 Sep 2003 22:50:47 GMT

Rename Access Table which is using a reserved name

Hi
I am doing a conversion for a client. They have an Access database with
one of the tables in it called Catalog. I can open the Access database
and all other files except this one. I can see the list of all the
tables in this database, its when I try to open it that the Delphi
program bombs.
If I go into Access and rename the table then I can open it up and it
works perfectly.

Is there an easy way to rename a table in Delphi using Ado?
--
Cheers
Glenn Shukster of Gms Computing Inc. Thornhill, Ont. Canada
Phone:(905)771-6458 Fax:(905)771-6819 http://members.home.net/gms
President of TDUG http://www.tdug.com

Brian Bushay Team

Delphi Developer

Sun, 28 Sep 2003 11:19:12 GMT

Re:Rename Access Table which is using a reserved name

Quote

>I am doing a conversion for a client. They have an Access database with
>one of the tables in it called Catalog. I can open the Access database
>and all other files except this one. I can see the list of all the
>tables in this database, its when I try to open it that the Delphi
>program bombs.

How are you trying to open it? Catalog is a key work so Try using brackets
Select * from [Catalog]
--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Glenn Shukste

Delphi Developer

Mon, 29 Sep 2003 10:26:43 GMT

Re:Rename Access Table which is using a reserved name

Thanks Brian
That worked and is much easier than renaming the table.

Quote

> >I am doing a conversion for a client. They have an Access database with
> >one of the tables in it called Catalog. I can open the Access database
> >and all other files except this one. I can see the list of all the
> >tables in this database, its when I try to open it that the Delphi
> >program bombs.

> How are you trying to open it? Catalog is a key work so Try using brackets
> Select * from [Catalog]
> --
> Brian Bushay (TeamB)
> Bbus...@NMPLS.com

--
Cheers
Glenn Shukster of Gms Computing Inc. Thornhill, Ont. Canada
Phone:(905)771-6458 Fax:(905)771-6819 http://members.home.net/gms
President of TDUG http://www.tdug.com

Other Threads

1. Table Field name is a SQL Reserved Word !

2. Renaming Physical Paradox Table Name

3. Help - Create Table using reserved words

4. Rename the table in mdb file using SQL statement

5. which table am I using ?

6. SQL if field name reserved word

7. SAPI: COM interface method name is reserved word.

8. Column Names are Reserved Words after upgrade

9. how to convert reserve word to collumn name

10. Local SQL reserved word as column name