Access Help

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-05: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-05: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-05:00

Create Delete and Update Audit Tables in 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 purposes, with a mind to other Access developers I made some changes [...]

Create Delete and Update Audit Tables in SQL Server2015-10-26T19:43:02-05:00

How to Open your MS Access Application like a Custom Software 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 full MS Access application window at the bottom of the toolbar. In [...]

How to Open your MS Access Application like a Custom Software Application2015-02-05T00:21:11-05:00

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 participate. Interested in joining one of our virtual AUGs? [...]

Access User Group Webinars for November2014-11-19T23:06:01-05:00

Chicago Event: Stored Procedures in MS Access

Juan Soto will be presenting next week at the Chicago Access User Group (CAUG). This is a great opportunity to network with other software developers and Access users, as well as a perfect venue to share tips, techniques, and ideas. Join CAUG’s kick-off meeting with Juan Soto, Microsoft Access MVP, [...]

Chicago Event: Stored Procedures in MS Access2014-09-20T00:33:24-05:00

Inno Setup – Create a Professional Installation for MS Access Solutions

Omar Rodriguez is a Programmer at IT Impact, Inc. with over 16 years of experience and a proven track record in design, development, and implementation of complex projects and high-performance solutions. We hope you enjoy his first post on the Access Experts blog, and feel free to contact him here o [...]

Inno Setup – Create a Professional Installation for MS Access Solutions2016-02-03T00:50:18-05:00

Access User Groups

The purpose of this group is to create virtual chapters throughout the world, from beginning user groups to advanced topics such as SQL Server. Chapters can be organized around a language, such as Spanish, a region, such as Spain or a topic of interest, such as Access functions. We hold monthly meet [...]

Access User Groups2014-07-14T22:52:49-05:00

4 Reasons Why Your Data is More Secure on the Web

Cloud Data Security As a recognized leader in cloud enabling Microsoft Access, sometimes our firm comes across clients who are reluctant to place their data online, oftentimes due to the many stories they hear regarding data breaches or hackers obtaining data. Despite these common perceptions, cloud [...]

4 Reasons Why Your Data is More Secure on the Web2014-10-28T01:36:24-05:00
FREE CONSULT
close slider