linked table in access

[ebiscaro]

Hi,

I link 4 tables from an SQL database into access using the access wizard and choosing the relevant ODBC connection to link to the sql database and pick the table I need.

My problem is that I would like the access db user to decide which SQL database (there are multipe dtabase into ,my SQL server) link to.

Is there a way to dynamically choose the database and always link only the 4 tables I am interested to?

Thank you.

 

[Pat Hartman]

Use the Linked tables manager and check the box at the bottom that says "always prompt".

 

[ebiscaro]

That worked

Great,

Is there a way for access to scan the odbc present on a machine? And present result in a table?

Thank you

 

[Pat Hartman]

No. You would need to code your own version of the Link Table Manager to do this.

 

[smallfry]

linked Table Wizard and Timeout

Hi
I have a Access application that is running in a development server and I can use terminal services from home to access this application. While using the Linked Table Wizard in MS Access to linked to a MS SQL server table, the connection is working good and it created a .odc file and once I open the .odc file and select the table I want to connect to I received a timeout error. I thought it was the terminal access problem, so I run the application on my local pc at home, it still give me the same problem. I have tried changing the QueryTimeout value in the registry to 0, it did not work either. I checked my permission on my SQL table, it is good too.

Any idea why this is happening???

Thanks
Your help is greatly appreciated