Reserved error (-7778) There is no message for this error

[Ketaki]

Hi,

I am in USA and am trying to open a database in UK through
ODBC in MS Access 2000. after i save the DSN, and enter
its username, password, data path, schema path & logon
path in the pop-up window, it gives me this error message:
Reserved error (-7778) There is no message for this error!

please let me know what is happening.

Thanks,
Ketaki

 

[Joan Wild]

I believe this happens if you use a file DSN instead of a system DSN.
Have a look at

ACC2000: Using File DSN to Import or Link a FoxPro ODBC Data Source Causes
Reserved Error -7778
http://support.microsoft.com/?kbid=212886
and

ACC2000: Errors Occur When Using File DSNs in Access 2000
http://support.microsoft.com/?kbid=327268

Perhaps this link will help
http://www.mvps.org/access/tables/tbl0014.htm