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 [...]
As Access Developers we deal with projects, both small and large, that may span hours or months. Our time is valuable, so it's important we are effective from start to finish with our client's projects, in particular with new and large ones. To that end we hold a Project Kickoff Meeting as our first [...]
This week's post is by Manuel Perez, a web developer working in our web division at IT Impact, Inc. Manuel has been experimenting with Amazon's EC2 cloud service and I asked him to document how to get started on the service, and pave the way for our readers to start experimenting with their own clou [...]
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 [...]
Today we launched a new domain and look for our site! We have moved all of our content over to AccessExperts.com and have redirected all content from our old site to our new one. The new design offers two great benefits to the older design: The new site uses Responsive WordPress theme that allows us [...]