fbpx

Check out the latest news on Microsoft Access, including Access 2022!

Check out all the BREAKING NEWS Ebo Quansah released at my last Access with SQL Server meeting: https://accessusergroups.org/blog/the-biggest-news-from-ebo-quansahs-march-9th-2021-presentation/ #msaccess Access MVP Summit This Week! March 29 through the 31st is the global MVP Summit, looking forward [...]

Check out the latest news on Microsoft Access, including Access 2022!2021-03-29T07:06:55-05:00

Avoid this common mistake when executing stored procedures

We love running stored procedures from our VBA code, but there is one issue you need to watch out for: Executing a procedure that affects data already loaded on your form. If you're not careful you will get the following message: Fortunately, it's an easy fix, here are some suggestions: Close the fo [...]

Avoid this common mistake when executing stored procedures2021-03-02T14:46:18-06:00

Easily convert your Access queries with this new tool!

AccessUserGroups.org launched a new tool that will convert your Access queries over to TSQL: https://accessusergroups.org/blog/accesssqltool/ As a firm that specializes in converting Access to SQL Server, this tool will be a real time saver! But it gets better with the ability to also create a strin [...]

Easily convert your Access queries with this new tool!2021-01-17T13:17:39-06:00

Where to download the runtime kit for Access 2016

If you ever need to download the runtime kit for Access 2016 you will find it here: https://www.microsoft.com/en-us/download/details.aspx?id=50040 If you expand the Details section you will see the following note: Note: There are multiple files available for this download. Once you click on the "Dow [...]

Where to download the runtime kit for Access 20162020-11-01T14:25:11-06:00

Writing readable code: Try* pattern

Lately, I've been finding myself using the Try pattern more and more. I really like this pattern because it makes for much more readable code. This is especially important when programming in a mature programming language like VBA where the error handling is intertwined with the control flow. Genera [...]

Writing readable code: Try* pattern2021-03-03T11:58:05-06:00

Ad-hoc connection strings and heterogeneous queries

Heterogeneous queries is the reason why connection strings, especially ad-hoc connection string are important. In previous articles of the series, you saw how you could customize the connection parameters for connecting to Excel and text files. In the case of the text files, you can also describe th [...]

Ad-hoc connection strings and heterogeneous queries2020-10-23T19:01:45-05:00

Connection string parameters for text file sources – saved specifications

Access provides a second method of describing text files' schema by using system tables MSysIMEXSpecs and MSysIMEXColumns to save the specifications. In the previous article, I covered how schema.ini can be used to describe a text file's structure. The schema.ini involved an external text file impli [...]

Connection string parameters for text file sources – saved specifications2020-10-24T10:43:16-05:00

Connection string parameters for text file sources – schema.ini

Making a schema.ini to open or link text files from Access is one of two possible methods that can be used to work with data contained in the files from Access. In the previous article, we looked at the text file's connection string parameters. We also discussed the need to have additional schema in [...]

Connection string parameters for text file sources – schema.ini2020-10-23T09:42:19-05:00

Connection string parameters for text file sources

In the previous article I covered the connection string parameters for Excel data sources. We will now focus on the text files. There are different methods for describing text files' schema and using the information during opening or linking in Access. While Excel spreadsheets had some resemblance o [...]

Connection string parameters for text file sources2020-10-23T09:40:12-05:00

Connection string parameters for Excel data sources

In the previous article, I discussed how we can treat Excel and text files as if they were a database using DAO, and how we can open them without linking. Because they do not use ODBC drivers, their connection string will be formatted quite differently from what you might be accustomed to seeing for [...]

Connection string parameters for Excel data sources2020-10-21T01:54:13-05:00

Opening or linking text or Excel as data sources in Access

Access is a phenomenal tool for working with many data sources. You may have long known that you can easily import or export data in a wide array of formats. However, we had a scenario where we needed to process data from external data sources. The processing runs frequently so importing data would [...]

Opening or linking text or Excel as data sources in Access2020-10-21T00:10:40-05:00
Go to Top