Renaming table in C#.

  • Thread starter Thread starter trialproduct2004
  • Start date Start date
T

trialproduct2004

Hi all
I ma having application in C# which is using MS Access as a bckend.
i want to rename table of mdb file.
i don't know how to do it.
Can some one help me.
Please help me.
Thanks in advance.
 
Hi,
I think that you ought to sql statment: CREATE new table and INSERT in new
tables data from first table. After copy you can DROP old Table.
This operation you can write as ODBCCommand.

This is my suggestions about your post, but I belive that this help resolve
your problem.

PawelR
 
I would also go with Pawel's suggestion. The Access object model does not
support the creation of new AccessObjects directly. If you don't want to use
ADO.NET, you can create tables programmatically, but you'll have to use DAO.
--
Kai Brinkmann [Microsoft]

Please do not send e-mail directly to this alias. This alias is for
newsgroup purposes only.
This posting is provided "AS IS" with no warranties, and confers no rights.
 
Back
Top