ODBC connection

[bflan0524]

helloI have a new work computer and Microsoft access DB (2010) wont work now because it needs an ODBC connection. I still have my old laptop, is there anything I can view looking at the database on my old computer that would show me how to get the connection set up on the new one?

 

[Micron]

Not sure I understand the problem or the question. On the ribbon, Get External Data > More... ODBC is listed as a data source. Your choices are to link or import the data.
At least I presume you're talking about tables that were linked but have now moved to a different server, hence needing the ODBC connection.

 

[HiTechCoach]

helloI have a new work computer and Microsoft access DB (2010) wont work now because it needs an ODBC connection. I still have my old laptop, is there anything I can view looking at the database on my old computer that would show me how to get the connection set up on the new one?

First, you nee to install the ODBC driver for the database.

For example, if an MS SQL Server then you will need to install something like this:

Microsoft® ODBC Driver 11 for SQL Server® - Windows


You could chek working PC's Control Pane under Add/Remove Programs to see what is installed.

Next, you will need to see if there is a DSN set up. On the working PC, you will find this in the Control Panel under ODBC Data Sources.


Also, make sure the Access database is trusted. You might need to set up a trusted location.