Help using Access database connection

[weelco]

I am using access, but when it connects using the supplied driver in CF MX7
suddenly I can see the full path name under for instance my tables in stead of
just the table name. The problem is that I can nolonger see the specific names
of the tables when I make a record set, it just shows me the complete pathname
from the pull-down menu.
Does anyone know how to solve this, I've tried using the access with unicode
driver but then my site doesn't work right but it does solve the initial
problem.
Thanx for the help

[sbsmithfl]

Greetings,
I'm having the same problem! Can you tell me if you found the solution?

Thanks,
Stephen

[sbsmithfl]

This problems was solved by erasing DSN in the cfmx administrator, and then
remaking the same datasource connection, exception choosing "Access with
Unicode", instead of just normal "Access".

Thanks,
Stephen
Tallahassee, FL

[weelco]

Correct however when I do that my code doesn't work anymore the way it's
supposed to, ie when I want to write to my database it then gives me an error
message which I don't when I use Access without Unicode

[weelco]

Any other suggestions??? Anybody??