Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Rename table
Message
From
11/09/2003 15:50:57
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00828238
Message ID:
00828300
Views:
13
Ok Nadya! Your code works fine here :)

Below code in VFP:

oAdoX = CREATEOBJECT('ADOX.Catalog')
CurrentTableName = 'OldNameTable'
ChangeTableNameTo = 'NewNameTable'
DatabaseLocation = 'Location of ur MDB'
oAdoX.ActiveConnection = 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=' + DatabaseLocation
oAdoX.Tables(CurrentTableName).Name = ChangeTableNameTo
RELEASE oAdoX

--
Best Regards!

Vinicius Ribeiro
"In this part of the world is 04:56pm"
Atenciosamente,

Vinicius Ribeiro
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform