ODBC connection error

[Guest]

HI,

I am completely stumped by this problem so any ideas would be appreciated.
I have an application that creates an Access DB for each day and stores data
in a table in the DB. I also have a number of front end Excel workbooks where
users can import and look at data for a particular day and if they want to
look at the data at a greater granularity they can press a button that
executes an external database query that queries a table in the Access DB for
that day.
I have full access rights to the directory where the Access DBs are stored,
the users have read-only access rights. This works fine but for some reason,
all of a sudden one of the users can no longer execute the external database
query. It comes up with the message: "ODBC driver login failed. Could not
find file 'filestring\filename.mdb'". Same error no matter what DB they are
trying to query.
The string for the DB is fine and besides if the string was incorrect then
it should come up with a run time error (1004). If the application is run
from another PC under another login (same rights) then there is no problem.
The users I am dealing with have Japanese PCs (both the ones that work and
ones that don't).
As it happens only sometimes could there be a profile issue?
Anyone have any ideas?

Thanks

 

[Guest]

Some quick guesses would be:
1. The user does not have rights to the folder
2. If you are using a DSN for your ODBC connection then maybe the user's PC
does not have that DSN defined?
3. Maybe if it is using a UNC mapped drive, maybe the drive is not mapped on
the user's PC or it is under a different letter?
4. Make sure the user has the latest MDAC.

jmonty

 

[Guest]

Thanks forthe ideas.
It turns out that it was a date issue so it really was a simple case of
incorrect file string. The users PC, although set to dd/mm/yyyy was reading a
day as mm/dd/yyyy in the VB code and as the date string yyyymmdd is used in
the database name is was not finding it.
Why this has just changed for one of the users and not the others is still a
mystery but at least I can fix this one.

Thanks again

Dave