Use Microsoft SQL Server Native Client 11.0 for the Best Performance [Update] There is a newer version of this post here. In our experience in using linked tables with Access, we get the best response using Native Client 11.0 with DSN-less tables. You could use ODBC 11 for SQL Server but then you wo [...]
Free Online Microsoft Access Tutorials in August August is here! Summer is winding down, but we still have some great MS Access User Group webinars. We’re also happy to announce that we’re launching a new chapter – the Canada Access User Group. If you haven’t attended one of our webinars before, the [...]
Create Delete and Update Audit Tables in Microsoft SQL Server This is a modification to an earlier tip I wrote, whereas this code will only record delete changes, my earlier article will record delete and update changes to the data. I found code online by Brett Kaiser and I modified it for my purpos [...]
9 Microsoft Access Developer Interview Questions A few weeks back, I created a post called 9 Interview questions to ask Microsoft Access Developers, and I challenged my loyal readers to try and answer them. Below are the questions and answers. 1. What is a collection? Answer: A group of objects held [...]
Recently we've been interviewing a lot of Microsoft Access Developers, we don't like to ask your run-of-the-mill questions like, ''Tell me your three strengths and three weaknesses,'' or ''What's your dream job?'' Aside from our vacancy actually being your dream job, we're less interested in the flu [...]
Google to Purchase Microsoft Access! Have you heard the big news with Access? FOR IMMEDIATE PUBLICATION: Google Inc, the search engine giant from Silicon Valley, announced today the purchase of Microsoft Access from Microsoft Corporation, headquartered in Redmond Washington. Larry Page, CEO of Googl [...]
Microsoft Access Seminars in Denmark and Spain [EN] We are excited to announce two big events that we are honored to present to you all. This summer Juan Soto, Access MVP and President of IT Impact, will be touring Europe and presenting a one-day MS Access Seminar, Discover the Power of Your Data. I [...]
How to Open Your MS Access Application Like a Custom Application Level of Difficulty Easy Applies to MS Access Versions Access 2000+ Overview: Sometimes, when we create a full blown application, utility, or departmental tool, we only want to see the opening form pop up on the screen and leave the fu [...]
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 [...]
Microsoft Access User Group Webinars for November We are happy to announce not one but four Access User Group (AUG) meetings this month. This is a wonderful opportunity open to novice and professional developers to learn new tricks. Each webinar is free and you don’t have to be a member to participa [...]
We’re Hiring: Senior Microsoft Access Consultant IT Impact Inc. is a world leader in developing Microsoft Access solutions, and we are looking for a Senior Microsoft Access Consultant. Notice this is a consulting position and not a developer position. We need someone who understands business, who ca [...]
