I recently split an Access 2002 database. The data is in a seperate database and is linked to the other with the code. The problem is I had a SQL statement that alters one of the tables (DoCmd.RunSQL "ALTER TABLE tblInvoice ALTER COLUMN InvoiceNumberCounter COUNTER (" & InvoiceNumber & ",1)"). The problem is that now that the database is split in two, I am getting the following error: "3611 Cannot execute data definition statements on linked data sources.".
Any suggestion on how to acheive the alter statement abouve on a lined table?