Access Lunchtime – Change all object names, First Name to FirstName

Come join us on the last Tuesday of every month @ 12 noon CDT.  Maria Barnes will be your host and we will cover lots of interesting topics related to Microsoft AEventsccess.  This is a free webinar for 1 hour, we look forward to meeting you!


Tom van Stiphout admits to be a bit OCD about naming convention. For example the design of Northwind makes him cringe. Names with spaces and perhaps other funny characters may cause notational difficulties when writing queries or VBA.

What would it take to clean that up?

He decided to try it, and it got a bit out of hand but in the end he was able to clean up 97% programmatically; the rest by hand.

Each type of object needs its own approach. For some DoCmd.Rename is all you need, while others such as SQL, macros, and VBA code need entirely custom approaches.

In the end you have Northwind back, with everything following the convention. Code will be made available.

We meet every last Tuesday of the month at 12 noon CDT.

To join our meeting, please use the following link and phone number or use your computer’s speakers with audio:

Join Webex Meeting

Join by phone+1-510-338-9438 USA TollAccess code: 624 273 591Password: FmZhJ9yU