Skip to content

Annual steps for S williams access DB

April 20, 2016

Perform these steps each april, until one of us retires.

constraints:  Using only MS Access 2003, not the much newer version of 2010 or 2013.  opening in newer version corrupts the db.

  1. copy the current year billing db from network home space to local folder called /old billing
  2. rename the db in network home space to following year
  3. kill the old shortcut on the desktop pointing to the previously named db
  4. create a new shortcut – browsing to the newly named db in network home space
  5. open the DB
  6. remove records from the transactions table
  7. update the date on the main form
  8. update the other form, not report, form – a form that loads when clicking on the Reports button – semantics!  Anyway, change the dates on the unbound form controls.

The end.

 

Advertisements

From → Uncategorized

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: