Hi,
We have a set of 10 databases which can either run in SQL or MSAccess. We use a script to alter the SQL databases in one go,
e.g.
Use DATABASENAME
alter table tablename1 alter column columname1 varchar(55)
alter table tablename1 alter column columname2 varchar(20)
alter table tablename2 add columnname3 int
go
Our problem is updating the Access databases. How can we run these modifications in one go, at the moment we have to run each script line by line,
Any help would be much appreciated!
Thanks
Kate
We have a set of 10 databases which can either run in SQL or MSAccess. We use a script to alter the SQL databases in one go,
e.g.
Use DATABASENAME
alter table tablename1 alter column columname1 varchar(55)
alter table tablename1 alter column columname2 varchar(20)
alter table tablename2 add columnname3 int
go
Our problem is updating the Access databases. How can we run these modifications in one go, at the moment we have to run each script line by line,
Any help would be much appreciated!
Thanks
Kate