Access 2003 not permitting ODBC links

[Guest]

On a PC with Access 2002 I can use ODBC linking, but on another PC with
Access 2003 I cannot. Both PCs have Windows XP professional SP2. Any ideas?

 

[Douglas J Steele]

When you say you cannot use ODBC linking, what exactly do you mean?

Are you saying that when you go to File | Get External Data | Link Tables,
ODBC Databases() isn't an option (should be the last entry under Files of
type)?

Or are you saying that you're trying to open the same database that you
opened on PC A, and it's not working on PC B?

If the latter, does the DSN exist on PC B?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

On a PC with Access 2002 I can use ODBC linking, but on another PC with
Access 2003 I cannot. Both PCs have Windows XP professional SP2. Any

ideas?