We have an access application using a SQL Server database back-end. Connection to the database is via ODBC. We are setting up a Dev environment - Dev Access front-end and a dev SQL Server database. ODBC has been created pointing to the Dev database. How do we now update the table link so that they are pointing to the Dev database and not the original production DB? I clicked External Data--> ODBC Database and it prompts me to 2 options -
1) Import the source data into a new table in the current database
2) Link to the data source by creating a linked table.
It seems that I need to select option 2. Then it will prompt me to the Data Source which will allow me to select the Dev database. Then prompts me to select tables.....Am I doing the right thing??? I've never worked with Access before.