Count All the Objects in Your Database The other day our company was tasked to convert a lot of Access databases to multiple SQL Server backends. To get a sense for the tasks involved, we needed a way to count all the tables, queries, forms and macros in each database. I did a quick Internet search [...]
Reporting More Granularly Than Usual - Microsoft Access Typically, when we do reporting, we usually do it at a higher granularity. For example, clients commonly wants a monthly report of sales. The database would store the individual sales as a single record, so it's no problem summing up the figure [...]
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 [...]
7 Ways To Do Sequential Numbering in Microsoft Access Occasionally we come across project requirements that include the ability to do sequential numbering in Access on a set of data. We cannot just use the auto-number data type because there is no promise of sequentiality but only uniqueness. In oth [...]
Working With Console Tools - Microsoft Access We recently had a project that required us to interact with console tools. People might have different terms for those type of tools so when I speak of console tools, I'm referring to a program or script that opens a command prompt and output stuff to th [...]
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 [...]
Creating Custom Microsoft Access Formulas and Using Them Effectively MS Access has a very powerful support for using expressions in your forms/reports’ controls. For example, showing a sum of some column can be as simple as putting down: =Sum([SomeColumn]) and we’re done! Now, sometimes, we don’t ha [...]
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 [...]
