Auntiejack56
Registered User.
- Local time
- Today, 22:28
- Joined
- Aug 7, 2017
- Messages
- 175
Hi, I'm just starting to use Access 365 and a newly downloaded SQL Express. The LTM is confusing. My tables are all connected to a Prod server on a different machine, and I'd like to relink them to my test SQL Server. In the old LTM I'd select 'Prompt for new location', and I would browse for the DSN on my machine which points to my test SQL Server. But with the new LTM, I click the 'relink' button and I get a popup box allowing me to edit the connection string.
I've worked around this: Link one of the tables from the test SQL Server by doing an import via the connection wizard and DSN builder. Edit that table in the LTM to get the connection string. Click 'Relink' and enter the new connection string.
Is there a way to just refresh the tables after being prompted to browse for a DSN, like in the good old days?!
Thanks,
Jack
I've worked around this: Link one of the tables from the test SQL Server by doing an import via the connection wizard and DSN builder. Edit that table in the LTM to get the connection string. Click 'Relink' and enter the new connection string.
Is there a way to just refresh the tables after being prompted to browse for a DSN, like in the good old days?!
Thanks,
Jack