Using SQL UPDATE command to update a field

[kwagner1]

Greetings - I'm new to using SQL with Access and i'm looking for some help with the following code.

- I want to update the "system" field in my table without any manual input on the UI. With the following code I am currently getting a pop-up msgbox (called "Enter Paramater Value") prompting me to enter the name of the value for the field. The "mynamehere" value is presented in the msgbox as what looks to be a label name for the input box.

My Code to update the "system" field is as follows:
DoCmd.SetWarnings False ' disables prompts
DoCmd.RunSQL "UPDATE [ML TF] SET [ML TF].SYSTEM = mynamehere"
DoCmd.SetWarnings True ' enable prompts



Thanks for your help!

 

[Norie]

Have you Compacted your database recently?

If you are adding/deleting Access objects it will increase the size of the database.

So goto Tools>Database Utiliities>Compact and Repair Database...

In later versions (after 97 I think) you can set an option to Compile on closing a database.