Uncategorized

What I’d love to see in the next version of Access

It's that time of the year again folks, where the Access team is debating what to include, fix or remove from the next version of Microsoft Access, and if past history is any notion of what to expect, don't expect anything to change on the client side: no new IDE tools, no new coding tricks, nada. * [...]

2013-06-10T20:32:32-05:00June 6th, 2013|

Migrating Access backend to SQL Server in the cloud

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 [...]

2022-03-14T10:28:21-05:00May 29th, 2013|

10 things every Access developer who works with SQL Server should know

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 [...]

2013-05-14T21:38:32-05:00May 14th, 2013|

Why the Project Kickoff Meeting is your most important step

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 [...]

2013-05-05T06:01:50-05:00May 5th, 2013|

Exploring Amazon’s free tier service – EC2 (Free servers in the cloud)

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 [...]

2013-03-25T19:40:51-05:00March 25th, 2013|

I’ve started a new LinkedIn group: “MS Access with SQL Server”

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 [...]

2013-03-18T01:58:14-05:00March 11th, 2013|

A new domain, a new look, same great content

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 [...]

2013-03-05T10:20:34-06:00March 5th, 2013|
Go to Top