When moving from earlier versions of Microsoft Office programs (Access, Word, Excel, PowerPoint, Outlook) to Office 2007, the new Ribbon can be very difficult to get used to. One common complaint is that it takes up so much space. However, did you know that the ribbon can be easily collapsed to give you extra vertical space?
Total Access Detective makes it easy to find differences between any two Microsoft Access databases or objects. Know exactly what changed with your properties, fields, indexes, controls, sections, macro lines, VBA module code, and data! Find new, deleted, and modified records. You can even merge data from two tables into a new one.
New features in Version 12 include support for Access 2007 and the new ACCDB database format with multi-value fields, data comparison between two queries, enhanced data comparison options, improved support for ADP comparisons, ignoring case between modules, a more modern user interface, and much more!
Version 11.7, is also available as a new version for Microsoft Access 2003.
Total Visual Agent is the system administration tool for professionally maintaining your Microsoft Access databases. Our seventh major release, Total Visual Agent 2007 is now shipping with full support for Access 2007 including the Access 2007 ACCDB database format. It incorporates many new features including improved support of Windows NT Service options, ADPs, and a more modern user interface.
Microsoft Access Jet Databases (MDB and ACCDB formats) need to be periodically compacted and repaired for optimal performance. You also need to make regular backups or multiple backups for disaster recovery. Schedule these database chores, manage entire folders or disk drives, and ensure tasks are executed consistently and audited. If something goes wrong, Total Visual Agent can actually send you an email. You can also schedule your own tasks such as running a macro in a database, which can perform all sorts of work such as printing reports, downloads, file transfers, and other processes you want on a regular basis. Tasks can be run monthly, weekly, daily, hourly, or just one time. Schedule your tasks and confidently know they’ll be executed according to your plan.
Total Access Admin offers real-time monitoring of users entering and exiting any Microsoft Access database across your network. An update of Total Access Admin 2007 was recently released. All registered customers were notified of the update via email with download instructions. A free trial version is available if you are not familiar with Total Access Admin.
I participated on this panel at the Microsoft TechEd Conference to explore the different reasons and approaches for migrating applications to Microsoft SQL Server. In addition to moving the data to SQL Server, ideas are presented for transforming applications to offer additional features while maintaining budgets. (43 minutes)
At the Microsoft TechEd conference. Microsoft’s Mary Chipman conducted a one-on-one interview about the history of FMS and how we’ve survived the economic and technical cycles over our 23 years of existence. Learn more about FMS, our successes and challenges over the years and today. (28 minutes)
Watch this video from my panel discussion at the Microsoft TechEd Conference. Hear me share my experiences at FMS with fiver other developers, and different ways we’ve survived over our careers. Entitled The World Turned Upside Down: Development Strategies for Lean Times, the video is 51 minutes.
Discover how Total Access Emailer can support a table driven system to continuously send emails from your Microsoft Access application. With an instance of Microsoft Access running Total Access Emailer’s programmatic interface, you can automatically send emails from a table. Create a custom email in your application and simply add it as new record to a table. The email is automatically sent without interrupting your application. Read the article for more information on how easy this is to implement.
When creating queries in Access, you may have noticed the query properties “Unique Values” and “Unique Records”. Are you familiar with the difference between these properties?
“Unique Values” and “Unique Records” correspond with the DISTINCT and DISTINCTROW statements (respectively) in the query’s SQL. Although they sometimes provide the same results, there are significant differences in how they work:
- DISTINCT checks for unique values only in the fields selected for output, and eliminates duplicate rows. Results are not updatable, since they do not necessarily correspond with a unique record.
- DISTINCTROW checks for unique values in all fields in the table that you are querying, not just the fields listed for output. If the table is keyed, the results are updatable, since they correspond with a single record in the underlying data.
Learn more and view an example of the differences in our new paper on Microsoft Access Queries: Distinct versus DistinctRow.
Visit our Microsoft Access Query Help Center for more query tips.
Microsoft’s annual TechEd conference is being held in Los Angeles next week. Microsoft has invited me to participate on a few panels including:
Let’s Talk about Software Consulting as a Business
Migrating Your Data Tier to SQL Server: Strategies for Survival
The World Turned Upside Down: Development Strategies for Lean Times
For more information, times and rooms, please visit our Upcoming Events page. Be sure to find me up if you are there.