Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kamii47
Constraint Violating Yak Guru
353 Posts |
 Posted - 2009-08-19 : 15:15:09
|
| We can easily update sql server database by creating script in which we can change database, stored procedures, function, add, update delete records e.t.cNow how can I update existing MS access database which is in used in production.I may want's to add table, add new column in tables, add queries,Update some queries e.t.c.Please suggests me any good solution.Kamran ShahidSr. Software EngineerAssurety Consulting inc.(MCSD.Net,MCPD.net) |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-08-19 : 15:32:39
|
| Access 2007 support SQL commands similar to SQL Server, like CREATE/ALTER TABLE. I don't know about other versions though, and I don't know if there's a way to generate scripts for the objects though. |
 |
|
|
kamii47
Constraint Violating Yak Guru
353 Posts |
Posted - 2009-08-20 : 00:10:20
|
| Thanks robvolk, Can you please refer to any good link of using it for updating MS access DBKamran ShahidSr. Software EngineerAssurety Consulting inc.(MCSD.Net,MCPD.net) |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-08-20 : 06:45:07
|
| First place I looked was the Access Help file. After that try Microsoft.com, MSDN, and then Google. |
|
|
|
|
|
|
|
|
Update MSAccess DB structure, queries, tables