Update db constraints with SQL script on live database?

A

AndyK

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.
 
T

Tim Ferguson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with MS Word paragraph and character styles: format getting messed up 2
constraint???? 3
Office 365 for Business vs Office Home - 'Save to' & Other Questions 0
Display Constraint Names 0
Access2007 &SQL server 2008 - problems 4
Q.) Jet DB error: Multiple Users able to write to MS Access DBsimutaneously? 3
SQL Scripts and run SQL in Batch Mode 4
Advice - SQL DB 12

Top