is it possible for me to raname my field name in my online database? i have some tables inside that i wish to reuse and i would like to rename them...
yah, sure it's possible. you might have to watch out for linked tables though.<BR>~~Chaotix
nope there aren't any linked tables..<BR><BR>can u tell me any tutorial sites for that so i could test it.<BR><BR>thanks!
The best you can do is add a new field, copy the contents of the old field to the new, and then drop the old field.<BR><BR>JET SQL simply doesn't have any way to rename a field.<BR><BR>
Apparently, according to the ADO help file "The Name property is read/write on Column" so I guess it could be doable.
... it does depend on the provider though. Oh well, might be worth a test...
did the poster mean through SQL or through Access' user interface? cause it can be done from access itself
He just said in his "online database". And I took that to mean a DB that was online on some ISP's web server. And he wanted to do it remotely.<BR><BR>I admit I assumed he would know he could do it with Access, locally.<BR><BR>