Rename a Back End Table

#1 (**permalink**) 28-Jul-2006, 08:10 AM

I have a Front and back end Database and need to rename a table in the back
and a field within that table. I do this as follows:

Dim dbsUpdate As Database, wrkDefault As Workspace
Dim tdfUpdate As TableDef

Set wrkDefault = DBEngine.Workspaces(0)

Set dbsUpdate = wrkDefault.OpenDatabase(strBackEnd, True, False, "MS
Access;")
dbsUpdate.TableDefs("tbltemptable1").Name = "tblControl"
dbsUpdate.TableDefs("tblControl").Fields("Field1").Name = "PatchVersion"
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10148-rename-a-back-end-table.html

My question is how do I then rename the table in the front-end without
breaking the link?

Many thanks.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10148

#2 (**permalink**) 28-Jul-2006, 08:10 AM

When you rename the table in the back end, you've already broken the link.

Your best bet, after renaming the table in the back end, is to delete the
link in the front end and then use transferdatabase to re-link the table,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10148
using the new table name as the source and any name you like for the link
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10148
name.

Check out "DoCmd.TransferDatabase acLink"

#3 (**permalink**) 28-Jul-2006, 08:10 AM

thanks for the reply, I decided in the end it was easier to create a new
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10148
table in both and set the source for the front end to the table in the back
end.

"Rick Wannall" wrote:

> When you rename the table in the back end, you've already broken the link.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10148
>
> Your best bet, after renaming the table in the back end, is to delete the
> link in the front end and then use transferdatabase to re-link the table,
> using the new table name as the source and any name you like for the link
> name.
>
> Check out "DoCmd.TransferDatabase acLink"
>
>
>

#4 (**permalink**) 28-Jul-2006, 08:11 AM

That's pretty much what TransferDatabase acLink does.

"N. Cotton" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10148
news:4843BF67-F3C0-4A07-A94A-006556CA7C9C@microsoft.com...
> thanks for the reply, I decided in the end it was easier to create a new
> table in both and set the source for the front end to the table in the
> back
> end.
>
> "Rick Wannall" wrote:
>
>> When you rename the table in the back end, you've already broken the
>> link.
>>
>> Your best bet, after renaming the table in the back end, is to delete the
>> link in the front end and then use transferdatabase to re-link the table,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10148
>> using the new table name as the source and any name you like for the link
>> name.
>>
>> Check out "DoCmd.TransferDatabase acLink"
>>
>>
>>