Oh dear, I seem to have acquired an entirely undeserved notoriety in
this newsgroup :-)

Let me try to make amends.

rasha_cs_99 wrote:

Do you mean that your Java program works when you run it on the same
machine that your Access database is on? And that it no longer works
when you try to run the same Java program on a different machine i.e.
running your program on machine A to connect to the Access database on
machine B?

rasha_cs_99 wrote:

I'm not an Access or ODBC expert, but I'm guessing that the data source
name that your program uses to refer to the Access database is only
valid on the machine where the database lives, the one I called machine
B previously.

Basically, only machine B knows that this data source name corresponds
to a particular Access database, and this is why you get the error
message on machine A.

Alternatively, if you have in fact configured machine A so that it knows
about the Access database on machine B, perhaps your firewall software
(you *did* upgrade Windows XP with Service Pack 2, didn't you?) is
preventing programs on machine A from making network connections to
machine B.

However, judging from the error message you quoted, it seems more likely
that machine A doesn't know about the Access database on machine B.

I use MySQL on Linux myself, so I can't offer any advice on how to fix
this kind of problem with Access. Sorry.

David Harper (not really a curmudgeonly old fart, honest!)
Cambridge, England