Hi All,
Recently upsized Access Db to SQL Server.
One issue we have is if somebody added a new drug to the access database it creates a new column in the Access table.
Problem is now the table is linked to SQL Server this won't work.
Had a read around and seems should only change SQL from back end, but each time a new drug needs to be added I don't want this to have to be done manually. Big risk, turnaround time etc..
Is there a way to update back end SQL table from front end Access VBA?
Any help appreciated.
Many Thanks
Recently upsized Access Db to SQL Server.
One issue we have is if somebody added a new drug to the access database it creates a new column in the Access table.
Code:
CurrentDb.Execute ("ALTER TABLE tblDrugListOral ADD COLUMN " & DrugNameWithOutSpace & " Number;")
Had a read around and seems should only change SQL from back end, but each time a new drug needs to be added I don't want this to have to be done manually. Big risk, turnaround time etc..
Is there a way to update back end SQL table from front end Access VBA?
Any help appreciated.
Many Thanks