We have about a dozen inherited Access programs written 10-12 years ago. The author is not here now.
We are having to add functionality to the Access code. I have never developed in Access.
I am just learning as I go.
The problem right now with an Access 2010 database (.accdb) on Win 7:
The VBA runs a query, which is linked to Database 1, which selects some fields of records in tables in Database 1, which is a SQL Server 2008 database.
(The Access linked query selects from about a dozen tables, all in Database 1. This may be
why the author linked the query instead of linking all tables and then using them in an un-linked query. Does anyone know of any other reason?)
The same query inserts new records into a global temporary table, "##ABC". My impression
is that since this is a linked query, all tables referenced in the query are in Database 1. Therefore ##ABC is in Database 1, NOT the Access .accdb file. Is that accurate?
If that is the case there might in some other scenario be an advantage of the linked query.
However, in this case it would be much better for the ##ABC table to be in the Access database file.
I need to combine some records from another SQL Server database (2000), Database 2, with the records in the ##ABC table, which is apparently in Database 1.
I know I could get records from Database 2, using a table linked to it, into a table "DATA" in the .accdb file with a SELECT statement. However, is there a way in the Access program to select the records from table ##ABC into the table DATA in
the .accdb file?
Thanks.
We are having to add functionality to the Access code. I have never developed in Access.
I am just learning as I go.
The problem right now with an Access 2010 database (.accdb) on Win 7:
The VBA runs a query, which is linked to Database 1, which selects some fields of records in tables in Database 1, which is a SQL Server 2008 database.
(The Access linked query selects from about a dozen tables, all in Database 1. This may be
why the author linked the query instead of linking all tables and then using them in an un-linked query. Does anyone know of any other reason?)
The same query inserts new records into a global temporary table, "##ABC". My impression
is that since this is a linked query, all tables referenced in the query are in Database 1. Therefore ##ABC is in Database 1, NOT the Access .accdb file. Is that accurate?
If that is the case there might in some other scenario be an advantage of the linked query.
However, in this case it would be much better for the ##ABC table to be in the Access database file.
I need to combine some records from another SQL Server database (2000), Database 2, with the records in the ##ABC table, which is apparently in Database 1.
I know I could get records from Database 2, using a table linked to it, into a table "DATA" in the .accdb file with a SELECT statement. However, is there a way in the Access program to select the records from table ##ABC into the table DATA in
the .accdb file?
Thanks.
