In Access, I linked to a SQL table where some of the column names begin with a number (i.e. 24K). When I run a Select query, Access populates all the rows for those fields with the number in the column name (24). Any solution besides renaming those columns in SQL?
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening. This article shows how to create and use them.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks.
Specify a start-up form through options:
Specify an Autoexec macro: