How to rename Access tables and field names?

[Marshal]

Jet SQL doesn't support any kind of rename statements
directly. I figured this can probably be handled through
ASP but I'm not sure how to go about it. Any help would
be appreciated...thanks.

[Bob Barrows]

Marshal wrote:

> Jet SQL doesn't support any kind of rename statements
> directly. I figured this can probably be handled through
> ASP but I'm not sure how to go about it. Any help would
> be appreciated...thanks.

Nope. You have to create new objects with the names you want and delete the
old ones.

Bob Barrows

[Marshal]

I found a way to do it if you want to check it out.

[url]http://www.4guysfromrolla.com/webtech/tips/t030802-1.shtml[/url]

>-----Original Message-----
>Marshal wrote:

>> Jet SQL doesn't support any kind of rename statements
>> directly. I figured this can probably be handled

through

>> ASP but I'm not sure how to go about it. Any help

would

>> be appreciated...thanks.

>
>Nope. You have to create new objects with the names you

want and delete the

>old ones.
>
>Bob Barrows
>
>
>.
>

[Bob Barrows]

Sorry - I did not realize those properties were read/write. When I first
read about ADOX, they weren't (IIRC). This must have changes when the Jet
4.0 engine was released.

Bob Barrows

Marshal wrote:

> I found a way to do it if you want to check it out.
>
> [url]http://www.4guysfromrolla.com/webtech/tips/t030802-1.shtml[/url]
>

>> -----Original Message-----
>> Marshal wrote:

>>> Jet SQL doesn't support any kind of rename statements
>>> directly. I figured this can probably be handled through
>>> ASP but I'm not sure how to go about it. Any help would
>>> be appreciated...thanks.

>>
>> Nope. You have to create new objects with the names you want and
>> delete the old ones.
>>
>> Bob Barrows
>>
>>
>> .