Editing a Linked Table

[ajochung]

Okay, I think I've done enough due diligence to ask this question. I need to know if there is a way to edit a linked table like deleting a row.

I've done this to link the table:

DoCmd.TransferDatabase acLink

I've tried this to set the permission to ReadWrite:

Const ReadOnly = 1
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = objFSO.GetFile(selectedFile)
If objFile.Attributes And ReadOnly Then
objFile.Attributes = objFile.Attributes Xor ReadOnly
End If

But I can't do this:

Dim ChkRcrd As DAO.Recordset
Set ChkRcrd = Application.CurrentDb.OpenRecordset("PFL", dbOpenDynaset)
Dim row As Integer

row = 1

ChkRcrd.Move (row)
ChkRcrd.Delete

I checked the Microsoft support center and it says that I won't be able to :banghead:. BUT, I want to know if there is a workaround to this obstacle because it just doesn't make any sense. For instance, why can i manually delete a row in the linked table? If anyone has any suggestions it would be really appreciated.

 

[Tieval]

Delete a record, not a row as such.

You can remove data from a linked table, you just cannot change the design of the table.