Update tabledef field on linked table?

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

I have an Access 2000 DAO application where I need to change the
..DefaultValue of a field in a linked table.

The following code returns a runtime error '3057' saying this operation is
not supported on linked tables.
Is there another way? Thanks.

Dim dbsBIO As DAO.Database
Dim tdfClients As DAO.TableDef
Set dbsBIO = Application.CurrentDb
Set tdfClients = dbsBIO.TableDefs!tblClients
With tdfClients.Fields!OtherChildren
.DefaultValue = 0
End With
 
hi,
this
Set dbsBIO = Application.CurrentDb
you have to change to database with tables
you can get path to it from linked table connect property
and then open it using:

Set dbsBIO = dbengine.OpenDatabase(strBackendPath)

--
Best regards,
___________
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com
 
Back
Top