Problem with Docmd.Remane Docmd @ acTable not declared

[gparl]

I have searched for a long time to solve this issue all I can get is the is the code which give me the error. I should be able to find the answer by microsoft but there sites are less than helpful

Here is my complete code what is wrong or what am I missing ( what referrance or what import is required) all I want to do is change an accdb table name with vb.net and a textbox or inputbox.


Private Sub btnCHGName_Click(sender As System.Object, e As System.EventArgs) Handles btnCHGName.Click
On Error GoTo Err_ErrorHandler
Dim Con As OleDbConnection
Dim strTable As String

strTable = InputBox("Please enter the new table name.", "Table Name")

If strTable = vbNullString Then
MsgBox("No table name entered.", vbExclamation)


Else
DoCmd.Rename("NameNewTable", acTable, "strTable") ' (also tried to use acDefault in place of acTable with same error)
MsgBox("Table successfully renamed.", vbInformation)
End If

Exit_ErrorHandler:
strTable = vbNullString
Exit Sub

Err_ErrorHandler:
MsgBox(Err.Description, vbExclamation, "Error #" & Err.Number)
Resume Exit_ErrorHandler

End Sub



I don't care what the code is I just want to change the friken name Why the hell does microsoft make every thing so complicated. This should be an easy procdure.

[June7]

If you are doing from VB.net, then sounds like a VB.net issue, not Access.

Why do you want to change table name with code?

You might try SQL Alter Table action http://www.techonthenet.com/sql/tables/alter_table.php

[gparl]

If you are doing from VB.net, then sounds like a VB.net issue, not Access.

Why do you want to change table name with code?

You might try SQL Alter Table action http://www.techonthenet.com/sql/tables/alter_table.php

I have also tried to use alter from the above mentioned site but have had issues also more explaination on this site would be helpful.

As to why I am creating an app for my own use and just wish to create a new table and name the table without going to access

I will try other method.

[dr91075]

What error are you receiving? Have you stepped through and identified the line at which it fails?

[gparl]

What error are you receiving? Have you stepped through and identified the line at which it fails?

Yes errors are Docmd is not declared & acTable is not declared

[June7]

This might be relevant http://social.msdn.microsoft.com/For...9-7563bc6ffa67

Indicates issue with 64-bit (4th post)

Still looks like a VB.net, not Access, issue.

[dr91075]

Try changing acDefault to acTable.

[June7]

dr91075, OP stated tried both parameters without success.

[dr91075]

Oops! My apologies to the OP. You are correct.

[dr91075]

This method worked for me on my 64bit:

Sub RenameTable()
CurrentDb.TableDefs("oldtablename").name = "newtablename"
End Sub

[gparl]

Oops! My apologies to the OP. You are correct.

I do believe that it is a 64 bit issue and although I have debug and compile set for x86 I think that the only solution will be to change this in access itself thank you all for the info it is appreciated.