If you Could Ask the MS Access Team Any Question, What Would it Be? Next month Ben and I are once again traveling to the MVP Summit at Microsoft headquarters for our annual pilgrimage to the mothership. It's a wonderful affair were we get wined and dined and fawned over by Microsoft, and of course m [...]
The Evolution and Future of Microsoft Access Mark your calendar for next Tuesday October 11th at 6.30pm central time! AccessUserGroups.org was founded by Access MVPs Juan Soto and Ben Clothier in order to foster virtual Access user groups nationwide. This month the meeting of SQL Server with Access [...]
dBase Support is Back in Microsoft Access! After an overwhelming outcry from the user community, Microsoft has again added support for dBase import into Access! The feature will only be for Office365 users but they plan on rolling it out to everyone eventually. Check out the official announcement he [...]
Note: I'll be presenting on this topic at the Access with SQL Server group online. Please join me on September 13th at 6:30 PM CST, join the group to get an email with all of the meeting details, it’s free!
Find All Queries That Use a Particular Table We just completed a massive 39 database conversion to SQL Server for a client in Tennessee which was quite challenging, we had to not only upsize all the tables, but switch the system from importing/exporting between databases to using linked tables inste [...]
Insert CreatedBy and CreatedOn in Any Missing Data Tables in SQL When we design Access with SQL Server solutions we almost always add CreatedBy and CreatedOn to all of our tables, allowing our clients to see who created records in the Access frontend. Script to add CreatedBy and CreatedOn Automatica [...]
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 [...]
How to Conduct Test Cases and Ensure Software Quality Software quality is an subject that has become more prominent in the software development industry over time because companies have placed more importance on offering quality products to different types of customers in the market. Nowadays softwa [...]
Effective Communication Using FogBugz Effective communication between team members is of utmost importance when it comes to achieving quality software; however, the quality of the software is almost never perfect. For this reason, it is common for clients to report errors in applications to its supp [...]
