N
Nathan Truhan
All,
I have a SQL Server with numerous databases/tables. some of which we need
for mail merge. I created an MS Access Front-End with linked tables to the
SQL tables we need. I have two databases, one has only a couple of links, the
other has the ones in the first database plus numerous more totaling 44
linked tables (not all needed for mail merge, but some for updates,etc...)
These tables are from multiple DSN Sources.
When I open the smaller Access DB from a mail merge, it tells me that there
are no visible tables. I have to then click ok, go into the options button
and select system tables, then they appear. First question, what is causing
this, and how can I get those tables to appear each time instead of going
into options?
Secondly, when I open the larger database, it doesn't give me an opportunity
to select a linked table, but instead automatically opens the first linked
table in the entry and displays the data/field selector dialog. When looking
in the Access database, it is not exactly the first table, but the third,
however if sorted by DSN names instead of table names, it would be the first
table. This is why I had to create the smaller one. Why would it do that,
and is there a work-around for this as well?
Thank you,
Nathan
I have a SQL Server with numerous databases/tables. some of which we need
for mail merge. I created an MS Access Front-End with linked tables to the
SQL tables we need. I have two databases, one has only a couple of links, the
other has the ones in the first database plus numerous more totaling 44
linked tables (not all needed for mail merge, but some for updates,etc...)
These tables are from multiple DSN Sources.
When I open the smaller Access DB from a mail merge, it tells me that there
are no visible tables. I have to then click ok, go into the options button
and select system tables, then they appear. First question, what is causing
this, and how can I get those tables to appear each time instead of going
into options?
Secondly, when I open the larger database, it doesn't give me an opportunity
to select a linked table, but instead automatically opens the first linked
table in the entry and displays the data/field selector dialog. When looking
in the Access database, it is not exactly the first table, but the third,
however if sorted by DSN names instead of table names, it would be the first
table. This is why I had to create the smaller one. Why would it do that,
and is there a work-around for this as well?
Thank you,
Nathan