Run-Time Error 3611

[kshamloo]

Hello Everyone;


can someone please tell me how I can re-write the following in order not to get the ugly Error 3611.
As a good practice all my databases are splits between FE and BE, everything is linked.

this is what I have:
dbs.Execute "ALTER TABLE MyTable ALTER COLUMN MyField Counter(1,1)"

of course this very statement works perfectly if the tables are local, but as soon as I link my tables I get Error 3611.

thanks Guys

[ranman256]

you cannot alter design of linked tables.

edit the table as a local, then relink,
if that fails, remove the table and link it back in.

[CJ_London]

without spending time checking what error 3611 actually is I'm guessing its because your table is in another db - same effect if you try to go to design view of a back end table from the front end

[pbaldy]

You can make changes from outside, along the lines of:

  Dim strSql             As String
  Dim db                 As DAO.Database

  Set db = DBEngine.Workspaces(0).OpenDatabase("PathToBackEndFile")
  strSql = "ALTER TABLE ..."

  db.Execute strSql, dbFailOnError
  Set db = Nothing