MS Access is a highly flexible, robust, and reliable database program. Microsoft Access is the leading relational database management system in the world. MS Access Solutions is your expert Microsoft Access programmer for Sacramento, California.
SQL Server is an enterprise relational database management system from Microsoft. We use SQL Server as the database server for data storage and data retrieval to and from Microsoft Access as well as other software applications, like ASP.NET and Azure.
Microsoft's application framework for web development produces dynamic web pages. ASP.NET provides web programmers with a platform for building dynamic web sites, web applications (web apps), and web services that require a web solution.
MS Azure is Microsoft's cloud computing service. It is used for development, testing and deployment as well as managing software applications through a global network data centers managed by Microsoft. Azure now features SQL Server called Azure SQL.
We Are Your Microsoft Access Database Experts
The Best Microsoft Access Database Solutions owner, consultant, and principal programmer is Alison Balter - a recognized expert Microsoft Access consultant. Alison is the author of 15 Microsoft Access training books and videos. She is a frequent guest speaker at MS Access conferences and has developed hundreds of applications for businesses of all types.
We know your business data is important; we listen to your concerns, ask questions, and gather information from all stake holders. We discuss your needs and requirements for your database. We find out what you want, why you need various features so we can obtain as much information as possible. Once we have the information we need, we work with you to design the proper database architecture, plus the dashboards, the questions (queries), forms, and reports you need for an excellent database system.
Your data is important to your business and you need both to enter and retrieve data rapidly. The data stored in your company's database must be clean, secure, and allow for maximum usage. Our Microsoft Access developer team will create your Microsoft Access database for optimum efficiency with all the features you need. After we program your MS Access and SQL Server database you will have the capacity to manipulate your data so you get the information you need for every day activities and for making critical business decisions.
We also create websites designed for speed to display your data accurately, using ASP.NET technology. Fast, secure, and robust, our ASP.NET web sites and web applications give you true business tool for finding and displaying information dynamically on the web.
Microsoft Access front-end and SQL Server back-end database
Access Forms Development
Access data entry form connecting to SQL Server back-end database
ASP.NET website with SQL Server back-end database
MS Access Report created with SQL Server database
Client Comments About Our Work
Sheldon Bloch, Oil and Gas Company
Alison from MS Access Solutions has provided both training and mentoring services to us over the past several years. Our developers use Alison Balter's books on programming with Microsoft Access as a desk reference. They have provided our staff members with much-needed training in Visual Basic, client/server development, SQL Server, and Microsoft Access. This has helped us to ensure that our employees can properly keep up with the ever-changing technologies. MS Access Solutions has also provided our staff with mentoring on an as-needed basis, providing expertise that helped our in-house programmers to overcome various hurdles. More Reviews
Lisa Dosch, Motion Picture Editors Guild - Local 700
Alison Balter at MS Access Solutions developed the application that helps us to properly service all of our members. This program handles billing, payments, tracking of jobs worked, available list, and other important data about our members. The system automates many tasks that were previously performed manually, allowing our employees to more cost-effectively use their time. This client/server system is used by employees in our Sacramento and New York offices. MS Access Solutions and their staff worked with us to develop the necessary specifications and design documents, and then programmed, tested, and implemented the application throughout our organization. More Reviews
When you need a truly expert Microsoft Access database development company to design and develop your mission critical custom database - Contact MS Access Solutions.
Microsoft relocated its Sacramento headquarters to a new office across the street from the California State Capitol. Microsoft celebrated the event with a grand opening open house on September 18. The public was invited for a light breakfast and along with a grand opening ceremony. Microsoft was very pleased to make this announcement since its new office was considered a state of the art workplace.
The Microsoft office address is: Microsoft - Sacramento Office 1415 L St, Sacramento, CA 95814 Phone: (916) 369-3600
The Microsoft office has good reviews, with most meeting attendees recording positive remarks. Some people feel the meeting rooms are a bit small.
A word of note: Microsoft does not provide direct technical support via phone at this location. Users are sometimes confused by the large number of Microsoft sub websites. In the past, Microsoft technical support was actually quite sparse. Often, you were required to create a Microsoft account online, then attempt to find the right location for help.
Microsoft product support is now located at their Support website.
Fixed - Automatic configuration of the current version of Microsoft Access has failed.
You may see the following error when starting Access after updating to Monthly Channel Version 1802 (Build 9029.2167 or greater): 'Automatic configuration of the current version of Microsoft Access has failed. Your database might not function correctly. This can occur if you do not have the necessary permissions to install Microsoft Access on this computer'.
STATUS: FIXED. This issue is fixed in Monthly Channel Version 1802 (Build 9029.2253) or higher. To get the latest update immediately, open Access and choose File > Account > Update Options > Update Now. This is an example of an error that comes up during version upgrades. They are usually corrected within days.
Errors do occur. These errors are typically not part of the Access program. They are errors that occur for updates and connections to other programs that occur when the program is updated. Usually, this is an oversite and is corrected promptly. We deal with these issues, and more complex issues with database development and Microsoft Access, every day. Because we work with Access every day, we always urge businesses to hire a professional who is very familiar with Access, SQL Server, Azure, and ASP.NET before attempting to create a business application with these tools.
Another issue that we see when businesses are still using Windows 7. Access may not be able to export objects as email attachments on PCs using the Windows 7 operating system. This occured with the Access update to Version 1806. The following error message would pop up: "Microsoft Access can't open the mail session." This situation was fixed in 2017 with the Monthly Channel Version 1807 (Build 10325.20118) or higher. It is unlikely that you will ever see this error unless you are using a very old version of Microsoft Access.
At MS Access Solutions, the software we use to develop your application is not perfect. Software glitches come with the territory. As true database programmers and professional Microsoft Access consult, we monitor Microsoft for updates continuously.
Every "out of the box" software package has issues when first released. As time goes by, users will find problems that the development team could not anticipate. Microsoft has stepped up its awareness and its capacity to correct errors and issues rapidly. Microsoft Access is designed for rapid relational database development. As Microsoft Access programmers, MS Access Solutions will push the limits of the Access program. We always test, test, then test again before we install any client program. Our goal is to deliver fully functional Microsoft database solutions that work properly from the first use.
Sometimes Queries seem to lose records. Here are some ideas about how to fix that situation.
Criteria with nulls can cause issues. Here's an example: You want to mail two distinctly different messages - one to your California clients and another to people in other states. So, you go ahead and create two separate queries. The first query has a criteria line under State read CA. The second query creates criteria line that reads Not "CA". Unfortunately, this does not handle the situation.
The problem comes from the manner in which Relational Databases, like Microsoft Access, work with 'Nulls.' If the data entry in the "State" field is completely blank, the record will not be returned (show up at all) in either of the two queries. Your query/queries should also specifically request that the Access program check for any Null records. This is accomplished by using a criterial like: "Is Null" or "Not CA" (without the quotes). For every query, it is likely that you will need to check for any Null records.
In many database situation you want to prevent creating Nulls records and Null fields. Since Microsoft Access Version 2 and newer, you can prevent Nulls by using Design View, clicking on a field, and in the Properties area, set the Required property to "Yes."
Sometimes you may find Nulls in Join queries. If you are attempting to join two tables, a Null field can cause problems. Here's an example that uses a "Customer" table that you might want to join with an "Invoice" table with the "CustomerID" field as your common 'join' field. For any cash sales, sometimes the Invoice table is not updated. This creates a blank CustomerID in the the Invoice table. When combining the Customer with the Invoice tables, the cash sales will be missing. In this case, create your join query using OUTER JOIN, so cash sales will be visible in both query and any reports you generate.
Material orignally seen in Allen Brown's Access Tips for Microsoft Access, which is no longer being updated.