Database updating

For more information about distributing a database to people who do not have Access installed, see the article Deploy an Access 2007 application.

If the UPDATE statement does not have a WHERE clause, all rows in the table are modified by the UPDATE.

The main command used in one of the tips is OPENROWSET.

This has been beneficial for us because in our environment because our business users provide data to us in the form of Excel spreadsheets.

It also provides links to more detailed information about each method.

This article assumes that the people who will share the database all have Access installed on their computers.