What I need to accomplish. I am supposed to be basically recreating their reporting in SQL Server RS 2008 (will get installed in a couple weeks with SQL 2008 R2), but I am not that savvy in Access (used it a few times 6-7 years ago but not to this extent.). I cannot figure out how to find what is populating the Access tables from the SQL tables.
Access will either be looking at
"local" tables...these are tables that have been populated with data from SQL or
"linked tables"....the tables are linked thro an ODBC DSN connection.
where does the data in SQL come from?...is this a production (eg OLTP) SQL db ..or just a "reporting" db, in which case...how does the data get into SQL?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day