Problem accessing a database from a remote site

Asked By gregorywelts 1230 points N/A Posted on - 06/19/2011

Hi,

I am in a remote site, and I want to access the database located in another site. We call site A by means of ODBC.

I already set up the ODBC with the username, password, path of data, path of schema, path of logon and saved it.

But an error message appeared that says Reserved error (-7778).

Reserved error (-7778); there is no message for this error.

I am wondering what I missed in my setup. I am using MS Access 2000, and I am not familiar with this error code.

My first impression is my data link towards site A. I checked my connection, and I am connected to the network.

I also checked my outgoing, it's also up.

If someone has encountered this error message,

Please help me figure out the solution.

Thanks.

• Status: Open
• Question Views: 1075
• Answer Count: 2
• Vote Up 20 Vote Down

• Answer Accepted: Yes
• Question Category: MS Access

Best Answer by qaser

Go To Solution

Best Answer

Best Answer

Answered By qaser 0 points N/A #123280

Problem accessing a database from a remote site

Hello,

I have read your query and researched on it. I have found the following solutions for you and I will try my best to give all information about your problem.

The error you are facing comes when the FDS (File Data Source) is selected from Access. If you select data source from Access MDS (Machine Data Source) tab then you will not face this kind of error. The data source define user DSN and File DSN from Windows ODBC Admin. If data source is used with Access, then user must be created.

The easy way to use DSN is to create user DSN. Then create a File DSN that does not contain configuration info. The following steps show how to do this:

• Find where the File DSN are kept.
• Create new text file with wordpad in that directory and save it with DSN extension.
• Open and edit this file. The contents of file are as follows:

[ODBC] DSN=The_name_used_in_the_user_DSN

The portion following DSN= points the user DSN that has already created.

I am sure this will solve your problem.

About qaser

Questions
1

Answers
2

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 07/11/2011
• Question Category: MS Access

Answered By jewel uddin 0 points N/A #123281

Problem accessing a database from a remote site

Hi,

I would suggest you to reinstall your software.

About jewel uddin

Questions
0

Answers
31

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 07/30/2011
• Question Category: MS Access