If you didn't find what you were looking for, try a new search!
SQL Server Update Breaks Microsoft Access Application UPDATE 12/3/14: Please visit Darren's blog for the latest on this issue, than come back here to see some solutions to this problem. You can visit Darren's blog here. My inbox has been flooded by reports around the world of Access suddenly being s [...]
We're happy to announce yet another event for all of you SQL Experts! On September 11th, Juan Soto, President of Access Experts, will be presenting to Chicago’s SQL Server User Group. Just one week away! Join fellow SQL experts for Juan Soto's presentation “Wish You Could Live the Glamorous Compute [...]
Please join Ben Clothier on Tuesday August 12th at 6.30pm CDT for our monthly meeting. We are excited to have monthly meetings to discuss Access with SQL Server topics! We meet every second Tuesday of the month at 6:30 PM Central Daylight Time (CDT). Topic: Managing large files with Access and SQL S [...]
Lately I've been getting calls from people suffering from performance issues with SQL Server, in particular with the 2012 version. My first question these days is: "Which SQL Server client are you using?" A good Access developer would know the answer to that question, but if you don't, open control [...]
Check out the SQL Stairway Series for some great training on SQL Server: http://www.sqlservercentral.com/stairway/ Enjoy! [...]
We are specialists in creating Access to the cloud solutions using SQL Server. We therefore maintain a number of databases and our clients are constantly asking us for improvements. Of course, we require that those go through a full cycle of testing and deployment: We copy an existing database using [...]
Here's a great way to learn more about SQL Server, Azure, Windows Server and other Microsoft technologies with this collection of Free ebooks: UPDATE: Here's a more recent list of free books from Microsoft: http://blogs.msdn.com/b/mssmallbiz/archive/2012/07/30/another-large-collection-of-free-micro [...]
What does "moving Access application to the cloud" mean? It means you are moving your data to a hosted SQL Server database on the web. You no longer have the data locally and you are still running the Access frontend locally. You may or may not have some tables local, but for the most part, all of t [...]
Working with SQL Server and Access can be challenging, here are 10 things you should know about SQL Server and Access: Using a pure Access solution, (no SQL Server), is almost impossible over VPN, but not a problem at all with SQL Server as your backend. Every table should have a timestamp field, bu [...]
For some time now I've been posting articles on LinkedIn MS Access groups. The posts vary the gamut, from Access topics to management posts. I've enjoyed the discussion and feedback on the boards, and now I've decided to create a new group: The reasons why I've decided to create my own group on this [...]
