Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Viewing ODBC tables when not connected

Status
Not open for further replies.

PCX

Technical User
Dec 17, 2000
54
US
Can anyone tell me how to see ODBC linked tables when not connected to the server? (I am using MS Access.)

I have a rather large database that I would like to be able to view from home and not at the office (server). This server is not connected in anyway to the internet or a dialup connection.

The fact that the tables would not be up-to-date is not important. I only want to see the structure and the data that was there when I was connected so that I can review the table information.

When I try to create a new Access database and export the tables to it, the only type of table I get is a 'linked' table and the data is not there when I am not connected to the server.

Thanks,
 
Guess I just needed a little breather to start thinking straight. I figured out how to accomplish this. Seems so DUH!!! now.

All I needed to do was to IMPORT the data files into a new database instead of LINK. Then I can see all the data and it stays with the Laptop even when not connected to the source.

Sorry to bother you guys.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top