ODBC links

[MurrayInfoSys]

I have inherited an application that uses Peer-to-Peer to run one app on several computers.

Systems are W2K or XP.

When I duplicate the shortcut on a new computer to the Access app and then start it - I get a ODBC error.

How do I drill into the woking apps to find the ODBC links?

Phil
Education can be a liability.

 

[DotNetGnat]

what is the exact error that you are getting...

-DNG

 

[MurrayInfoSys]

The DB is on an XP Pro.

There was no specific err no. I interpred the error as "ODBC not found". I went into ODBC Admin of the working App. There were no System DSN. There were Several File DSN. They have Crystal Reports installed.

The machine that I was trying to run the App from had no File DSN entries.

Am I correct, that I have to create the relation between:
Access Object > DSN > Driver > file (Very simply stated)?

Phil
Where there is smoke, someone may be thinking.

 

[ArtieChoke]

A file DSN can exist anywhere, since it is a file and not an entry in the registry.

Is the app totally in Access?

"I think we're all Bozos on this bus!" - Firesign Theatre

 

[MurrayInfoSys]

See, I told you Education is a liability ...

As far as I know it is. I have been told that it was developed before Crystal Rpts was installed. BUT, that does not mean it had been modified to use CR if that is possible.

It is a simple app.

Type in a SKU number, It gets info (Desc, Price, + other data) from the Inventory file and prints to a 1/2 page form = big sticky label.

Phil
What is that whiring sound? OH, someone is thinking.

 

[ArtieChoke]

Open the database in Access and select the linked tables manager (may be an add-on or in tools/database utilities, depending on the version you have). It should show you the ODBC connection info for each table.

If you look at the various DSN entries on a computer where the app runs okay, do you see an MS Access entry for this database?

"I think we're all Bozos on this bus!" - Firesign Theatre