PC Review


Reply
Thread Tools Rate Thread

In Access I am unable to link to an ODBC database??

 
 
=?Utf-8?B?c2ltYmVy?=
Guest
Posts: n/a
 
      23rd Feb 2006
I have created a new database in Access and I am trying to link to my
Timberline database thru ODBC. When I click in Files of Type and click on
ODBC nothing happens. I go back to the original window. I have gone thru
Repair - I've uninstalled and reinstalled using Custom and selecting every
option. I was able to do this in Access 2000 but not now in Access 2003.

Any Ideas?
 
Reply With Quote
 
 
 
 
Arvin Meyer [MVP]
Guest
Posts: n/a
 
      23rd Feb 2006
Most likely, the Timberline DSN has gotten corrupted. Since Timberline uses
Pervasive SQL, security sometimes renders the DSN inoperable. I've never
spent much time trying to find out why. What I always do is just delete the
existing DSN and recreate it, then reconnect tables if necessary. That
process hasn't failed me yet.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

"simber" <(E-Mail Removed)> wrote in message
news:A3923B58-BCFD-4EF5-860E-(E-Mail Removed)...
> I have created a new database in Access and I am trying to link to my
> Timberline database thru ODBC. When I click in Files of Type and click on
> ODBC nothing happens. I go back to the original window. I have gone thru
> Repair - I've uninstalled and reinstalled using Custom and selecting every
> option. I was able to do this in Access 2000 but not now in Access 2003.
>
> Any Ideas?



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a table link via ODBC in another ACCESS database sailor_123 Microsoft Access VBA Modules 1 8th May 2008 10:22 PM
Unable to import or link tables through odbc in Access SP2 =?Utf-8?B?RGF2ZSBKZW5raW5z?= Microsoft Access External Data 5 2nd Dec 2005 04:37 PM
MS Access ODBC link to another Access database outside of my netwo =?Utf-8?B?S2F0aWUgQg==?= Microsoft Access External Data 4 18th Jan 2005 12:23 PM
Access ODBC Database Link Problems With XP Professional Jeff Gregory Microsoft Access External Data 2 15th Jul 2004 02:10 PM
Access FE link to two SQL database using ODBC... Paul Microsoft Access Forms 3 12th Jun 2004 12:41 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:04 PM.