Access Help

Access with SQL Server – Import large datasets using a simple SSIS job.

Dying with an Access Insert Query If you’ve ever tried to insert a large amount of records into SQL Server using an Access insert query, (15,000 records or more), you’re in for a long wait, were talking coffee break time here, (from a few minutes to 15). It may even cause your database to hang if th [...]

Access with SQL Server – Import large datasets using a simple SSIS job.2019-02-07T08:30:31+00:00

Join me for the first of three Access with SQL Server Acdemy sessions September 11 2018

We kick off the new season of Access with SQL Server group meetings this year with three months of training: Introduction, Intermediate and Advanced topics on how to optimize Access with SQL Server. Part 1: Introduction On Tuesday September 11th 2018 I’m going to discuss: When you should or should n [...]

Join me for the first of three Access with SQL Server Acdemy sessions September 11 20182018-09-08T12:30:49+00:00

Getting “System Resource Exceeded” messages? Here’s one way to fix it

System Resource Exceeded Error Message Lately we've been seeing a barrage of clients getting "System Resource Exceeded"  when migrating to Windows 10, even though the system worked fine in prior versions of Windows. In some cases we've traced the issue to apps that use a lot of subforms in a tab con [...]

Getting “System Resource Exceeded” messages? Here’s one way to fix it2018-04-22T21:20:43+00:00

Meet Michal Bar and me at Microsoft Ignite!

This week Microsoft has invited me to speak at Microsoft Ignite along with Michal Bar from the Microsoft Access team! I'll be in Orlando all week learning about new technologies and on Wednesday afternoon present on how to plug Access into the modern Microsoft echo system in a 75 mins session.  If y [...]

Meet Michal Bar and me at Microsoft Ignite!2017-09-25T19:32:56+00:00

Drag and Drop In MS Access and Conditional Sorting

Drag and Drop In MS Access Doug was on a roll in January of 2004 when he wrote his article on drag and drop in MS Access. He tested it now using Access 2016 and it still works. This article shows you how to add drag-and-drop to your Access application using combinations of multi-value and single-val [...]

Drag and Drop In MS Access and Conditional Sorting2018-06-27T20:26:39+00:00

Official Access tech blog now online! Also, more improvements to Access!

Official Microsoft Access Tech Blog Launches! In addition to the blog on the Office site, the Access team has started a technical blog here. The new Access Tech Blog will be more technical in nature and oriented towards technical users instead of regular ones on the office blog. Accessibility Update [...]

Official Access tech blog now online! Also, more improvements to Access!2017-07-11T01:06:36+00:00

Tuesday April 11th: Learn how to spawn forms in memory, yes, you heard that right

Hi Everyone! This Tuesday I’m going to demo an amazing concept: How to spawn multiple copies of the same form in memory. Have you ever wanted to display multiple orders or invoices in your databases in separate forms using the same form design? One way of doing this would be to have multiple copies [...]

Tuesday April 11th: Learn how to spawn forms in memory, yes, you heard that right2017-04-10T13:46:05+00:00

The Evolution and Future of 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 group will include an interview with Luke Ch [...]

The Evolution and Future of Access2016-10-05T19:36:13+00:00

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 but did not like any of the code snippe [...]

Count all the objects in your database2016-08-25T22:16:23+00:00

Use SQL Server Native Client 11.0 for the best performance

In our experience in using linked tables with Access, we get the best response using Native Client 11.0 with dsnless tables. You could use ODBC 11 for SQL Server but then you would NOT be able to use ADODB, so we prefer the latter and not the former. Microsoft does a great job of hiding Native Clien [...]

Use SQL Server Native Client 11.0 for the best performance2015-11-11T21:43:33+00:00

Ways To Do Sequential Numbering in 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 other words, if someone creates a record then later delet [...]

Ways To Do Sequential Numbering in Access2015-07-30T20:51:20+00:00
Contact Us
close slider
  • This field is for validation purposes and should be left unchanged.