I've got a Split database, where there a lot of back-end databases. There is one Backend-database for each customer. And there is also only one back-end linked at a time.
Now I want to update all of these back-end databases for the release of a new front-end version.
when I try this:
Expand|Select|Wrap|Line Numbers
- DoCmd.TransferDatabase acLink, "Microsoft Access", Text1.Value, acTable, "Analyses", "Analyses"
- CurrentDb().Execute "ALTER TABLE analyses ADD Column Caption1 MEMO;"
Is there an easy solution for this?
I guess copying the whole table from BE to FE, alter it and copy it again to BE is possible, but that doesn't look very efficient.
thanks,
Stijn