Changing Field type from Text to Memo in Linked Table.

[RobH]

I need to change the field type in a linked table from Text to Memo.

Any thoughts?

[Rabbit]

I need to change the field type in a linked table from Text to Memo.

Any thoughts?

You're going to have to open up the original database. You can't modify table structure of a linked table while it's open in another database.

[RobH]

Actually I have since found you can..

On Error GoTo Err_RunDDL_DAO
 
Dim dbBackend As DAO.Database
Dim strBackend As String
Dim strDDL As String
 
strBackend = "Path\Fileaccdb"
strDDL = "ALTER TABLE [TableName] ALTER COLUMN FieldName MEMO"
 
Set dbBackend = OpenDatabase(strBackend)
dbBackend.Execute strDDL, dbFailOnError
 
End_RunDDL_DAO:
On Error Resume Next
dbBackend.Close
Set dbBackend = Nothing
Exit Sub
 
Err_RunDDL_DAO:
MsgBox Err.Number & ": " & Err.Description
Resume End_RunDDL_DAO
 

[Rabbit]

Good to know. I wonder why they don't let you do it by opening it in design view then.

[MMcCarthy]

In this case you are actually opening an instance of the backend database.

[Rabbit]

True, although I thought you would have to close the linked database before opening the backend to make the changes.

[MMcCarthy]

True, although I thought you would have to close the linked database before opening the backend to make the changes.

Good point. Haven't actually tried it this way so who knows :D