Update db constraints with SQL script on live database?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am shipping a new version of my VB program to my client - it uses an Access .mdb file for data storage. The new version requires changes to some of the db constraints, eg some mandatory fields are now optional. Is there any way I can script these changes rather than apply them one at a time on the client's site using the Access GUI?

thanks for reading this and for any pointers.
 
Is there any way I can script these changes rather than apply them one
at a time on the client's site using the Access GUI?
Click to expand...

check out the help files for ALTER TABLE

Tim F
 
Back
Top