Re: finding location of ODBC source in Access
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Sat, 16 Aug 2008 14:16:41 -0400
JASelep wrote:
Is there a way to list/display the source location/properties of an
ODBC link in an Access DB?
An Access MDB was backed-up before a computer was re-imaged
I'm trying to find information on the ODBC source location to
re-establish the links in the restored MDB so it will work
I got this great query from this discussion group to list regular
linked table souces in an access DB
SELECT [Name], Database, ForeignName
FROM MSysObjects
WHERE [Type]=6
ORDER BY [Name];
ODBC DNSs are external to the Access database, so those properties are not
stored anywhere in the database. To get those properties, you have to go to
the Registry of the machine on which those DSNs were created. From the
sounds of it, you are out of luck, unless you can restore a backup of the
Registry that was done before the computer was re-imaged. I don't know
off-hand where the DSN information is stored in the Registry (especially
since this will be OS and OS version-specific), but a quick google search
should reveal it for you.
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
.
- References:
- finding location of ODBC source in Access
- From: JASelep
- finding location of ODBC source in Access
- Prev by Date: finding location of ODBC source in Access
- Next by Date: Re: finding location of ODBC source in Access
- Previous by thread: finding location of ODBC source in Access
- Next by thread: Re: finding location of ODBC source in Access
- Index(es):
Relevant Pages
|
