Alter Linked Table

[Vulcan1500]

I have to modify one of the tables of the backend once the frontend opens. Is this possible and how do I have to change the code?

strSQL = "ALTER TABLE MyTable IN 'C:\MyDir\MyDB_backend.mdb' " & _
             "ALTER COLUMN BackupFolder TEXT(250) " & _
             "ADD COLUMN BackupAantal DEFAULT(10);"
DoCmd.RunSQL (strSQL)

 

[pbaldy]

I don't use DDL that often, but I don't think you can combine the add and alter. Try 2 stand-alone queries.

 

[Vulcan1500]

Eventualy I found my stupid error. I still had the recordset open! Sorry for that!