For Microsoft Access, SQL Server,
Visual Studio .NET, and VB6 Professionals
World Cup, heat. The humid summer weather has finally arrived in the Washington, DC
area. After our unusual, long, cold winter, I don't think anyone is complaining.
Last month, I had a wonderful time speaking and attending the
Access User Group Conference at Silver Falls State Park,
Oregon. It's always a wonderful time seeing the friendly faces
of the Access community with attendees from across the US,
Canada, and Australia to Russia. Jack Stockton, Geoff
Hollander and Nancy Sittig Smith do a wonderful job organizing
the event. Hope you can make it to next year's event in May.
Be sure to sign up early as it sold out faster than ever this
We are very pleased to release the Microsoft Access 2013 version of
Total Access Emailer, the most popular email program for
Microsoft Access. A
is available if you're not familiar with it. This joins our recent releases of Microsoft
Access 2013 versions of
Total Visual Agent and
Speller. Our development team is busy updating our other
products as well.
Meanwhile, Microsoft is undergoing a huge shift to the cloud.
We have been using Office365 for the past year and exploring
the Access Web platform now that it works with SQL Server. At
this point, Access web apps can only offer the most basic of
data sharing over the web with very limited automation
features. I'll be happy when it can build what could be done
in Access 1.1. By storing its data in a SQL Server database
that can be linked by Access desktop databases, hybrid
solutions are possible. We'll be covering more on Access web
apps in the near future. To learn more about Office365, we
free Office 365 trial links you can use and if you're part
of a non-profit organization, Microsoft is offering the
service for free. Recent videos from the Microsoft Access team
are included in this newsletter.
To keep track of the 22 year legacy of Microsoft Access, we've
created a new paper that documents all the Access versions,
service packs, and recent updates. Hope that helps.
This newsletter includes much of the news we've shared on our
feed over the past few months. We hope you've been able to
keep up with our various
activities and sharing of news.
Be sure to Like our
Facebook page for the most timely information.
All the best,
Total Access Emailer Ships for Microsoft Access 2013
Total Access Emailer
is the most popular email automation program for Microsoft
Access. It simplifies the sending of personalized emails with
Access data and reports to everyone on your list.
Total Access Emailer is now available for Microsoft Access
2013. Total Access Emailer 2013 includes many enhancements
since the prior release of Total Access Emailer 2010 and the
Version x.6 for pre-Access 2010 versions:
- Enhanced setup for Windows 8 and 64-bit installations
- Supports differences in VBA code between Microsoft Access
2013 and 2010
- Improved support for linked tables in SQL Server and
Access databases including situations when connections are
- User interface improvements to better manage editing and
duplicating email blast specifications
- Professional Version VBA library detects if the userís
machine has not run the runtime distribution EXE
- Improved display of record counts for repeating multiple
email blast broadcasts
- Improved error handing and reporting
user manual and help file
Here's a complete list of
free trial version and send your own
personalized emails from Microsoft Access.
Access Version Releases, Service Packs, Hotfixes, and Updates History
FMS has worked with Microsoft Access since it debuted in 1992. There have
been many Access versions since then with multiple service packs, hot fixes and
updates. This paper offers a list of what and when it was released, feature differences
between versions and additional details for the more recent versions.
To document all the versions and changes, we've written a new article
summarizing the evolution of Microsoft Access:
Microsoft Access Version
Releases, Service Packs, Hotfixes, and Updates History.
Here's a related article we introduced in the last
newsletter that is updated with a link to the new Microsoft
Access 2013 SP1 Runtime download:
Access Runtime Distribution and Free Downloads
Microsoft Access Developer Help Center for additional
articles with tips for creating great solutions.
Could Not Use Database; File Already in Use Message May Not be
Due to an Exclusive Lock
When you try to open a database, you may encounter this error message: Could not use [Database Name]; file already in use.
This error message may correctly explain that someone else
has the database opened exclusively. It can also occur if
that's not the case, but there's an incompatibility with the
system workgroup files among your users. Read our paper
Microsoft Access Error 3045 (Could Not Use Database; File
Already in Use) May Not be Due to an Exclusive Lock for
Avoid Using Decimal Field Size in Microsoft Access Tables
A Microsoft Access table allows you set a Number field to
Decimal Field Size. Unfortunately, there are problems with
this and you should stick to Double field size. Read
Avoid Using Decimal Field Size in Microsoft Access Tables
Microsoft Access Videos from the SharePoint Conference
Microsoft Access team has released videos of their
presentations at the SharePoint Conference from Las Vegas,
With Access 2013, Access web solutions are hosted in
SharePoint and rather than using SharePoint lists as they
did in Access 2010, they use a real SQL Server database
hosted in SQL Azure. The database can also be linked from
desktop copies of Access to create hybrid solutions that
serve both the web and Windows.
The Microsoft Access program managers presented these
Other FMS Videos
Trial Offers for Office365 and Dynamics
Have you been curious about Microsoft cloud offering of
Office365? No longer interested in hosting your own Exchange
Server? Want to have your infrastructure in a secure data
center with high reliability and resilience?
If so, we have
Free Trials for Office365. We also have trial links to
Microsoft Dynamics CRM. Test it out and see if you like it.
We switched to Office365 over a year ago starting with our
Exchange Server. We already had our email hosted offsite, but
moving it to Office365 was relatively smooth and made it
easier and cheaper to support different mobile devices. We then migrated our SharePoint platform to Office365. That
was a bit more challenging with the changes between SharePoint
Now with our hosted SharePoint site, we're
experimenting with Access 2013 Web Apps that are
integrated directly with SQL Azure databases for our internal
and external users. Since it's hosted on SQL Azure, you can
also link to the tables directly from your Access desktop
Try it out for free and see what you think.
Access Export to Microsoft Excel Tip
Here's a tricky problem we encountered. Introduced with Office
2007, the Excel XLSX file format supports spreadsheets with a million rows which is well
above the 64,000 rows of the XLS format.
It turns out that when exporting more
than 64,000 records to Excel, you can't do it from an Access
MDB file, even if you're using Access 2007, 2010, or 2013. It only works
if you do so from a database in the ACCDB database format. It
makes some sense in hindsight, but it took us a while to
figure it out.
Windows Tip: Rebooting a
Remote Desktop Computer to Restart It
Remote Desktop is a wonderful Windows feature that lets you
connect to a computer located elsewhere and run it as if you
were there. You may want to reboot that machine but the remote
computer's Start menu only shows options to "Log Off" and
"Disconnect". It does not offer the standard "Shut Down"
options: Log off, Shut down, Restart, Stand by, Hibernate. If
you press Ctrl+Alt+Del, the command is captured by the local
machine and not the remote one.
Read our paper
Rebooting a Remote Desktop Computer to Restart It for how
to do this.
8.1 Update Released
In case you are confused, Windows
8 was released in late 2012. It was upgraded to Windows 8.1 in
October 2013. Then in April, it was replaced by "Windows 8.1
Update". Microsoft expects you to migrate to the Update
version in order to receive future updates. Not sure why they
didn't name it 8.2. So if you're using Windows 8, make sure
you download the update for the
Windows 8.1 Update.
On a related note, here's an interesting retrospective from
ZDNet the recent history of Windows:How we got from Windows XP to Windows 8.1How we got from Windows XP to Windows 8.1
Created in Germany
Fellow Microsoft Access MVP and
FMS friend Karl Donaubauer created
AccessDevelopers.org for the Access community in Germany.
One of their
first features is FMS President Luke Chung's paper on
Microsoft Access within an Organization's Overall Database
Strategy. Check out their conferences. Good luck Karl!
Thank you for your continued support!
feed for our latest announcements