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 [...]
On my Access with SQL Server group at LinkedIn, one of our members posed the follwoing question: ADO or DAO for new development work? Let's break it down The question implies DAO or ADODB are mutually exclusive, but they are not. You could easily create an Access app using just DAO that would work j [...]
I've talked about using a recordset with stored procedures before, but this time I wanted to emphasize the importance of always using a recordset when executing a stored procedure from Access VBA. Command Object does not cut it Usually a programmer will use a command object to execute a stored proce [...]
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 [...]
I LOVE integrating Access with Outlook, it's really easy to create a system that allows our clients to export reports as PDF attachments in an email. Objective: Email pdf invoice to a recipient using Outlook. Needed Option table to hold templates for the Subject and body of email. Make sure client t [...]
As I write this I'm on my way with Ben to the annual MVP conference at Microsoft's campus in Seattle. The annual summit last four days and all expenses but your flight and transportation on the first and last day are covered. (If you don't share a room with another MVP you do have to pay for half of [...]
Office 2013 has gone on sale and already I've seen posts online from people asking about the SQL Server Upsizing wizard not found in the tool. It's no longer available The wizard was a causality in Access 2013 and frankly I say good riddance. I for one thought it was barely usable when it worked, si [...]
10 Question you Should Ask your Access Developer Companies are constantly looking for quality Microsoft Access developers, here are some questions to help you evaluate one: Do you provide quotes or estimates? If the MS Access consultant does not provide estimates, it's a major red flag. Quotes an [...]