Sorry but i thing that with query in Access is not possible ( i never can do it...), but you can create a temporal table with and autonumeric field and take the data from that table, after run the query remove the table for the next time.
Yes you can use a pass-through query in Access to do this.
Create the pass-through query, and set it's ODBC connection string. The connection string MUST include a pointer to the database you wish to use. Currently, MySQL doesn't support multiple statements separated by semicolons, but will very soon...
For the query's SQL, enter something like:
CREATE TABLE `Installations` (
`ID` mediumint(8) unsigned NOT NULL auto_increment,
`MyStamp` timestamp(14) NOT NULL,
`ComputerID` mediumint(8) unsigned NOT NULL default '0',
`LicenseID` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`ID`)
Note the timestamp field. If you don't use it, Access won't be able to get hold of the table properly.
Run the query, and the table will be created. You can then link the newly created table in Access.
Personally, I would do the above ( creating a table ) via ADO. But I suppose a pass-through query is a valid way of doing it too.