Run-time error 3611???

[NJudson]

I've recently split a database and when I try to run one of my subroutines I get the following error:

run-time error 3611

"Cannot execute data definition statements on linked data sources."

The line this is erroring on is:
DoCmd.RunSQL ("ALTER TABLE WizardCatsLayersFile ADD COLUMN SiteId TEXT(80)")

Is there a way around this or do I have to go back and use my database before I split it? I'm using Access 2000. Thanks for any help.

 

[Travis]

You can only alter the Local (vice Linked) tables. You can add the subroutines that alter the table to the backend mdb file and run them from there. (Alter Table routines are not normally something that the general user should be running)

 

[NJudson]

Thank you for your quick reply Travis. I think I may just go back to my backup database before I split it. The only people using the dbase will be me and a couple other co-workers and most likely none of us would need it at same time so considering this I may not really benifit much from splitting.

Just curious, but you say that altering tables isn't something the general user should do. The tables I'm altering aren't involved in any table relationships so does this matter? I've been having some database bloating problems, so would this be a major source of my bloat?

Thanks again.