Update tabledef field on linked table?

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
 
A

Alex Dybenko

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
 
Top