Just an idea - it's the ODBC driver on the PC that resolves this path,
and if the driver is more DOS than Windows, it might need an 8.3
character name format like C:\Docum~1\tyler\short.mdb. It may not be
able to parse the longer name.

Dennis Hassell
(941) 746-4919


-----Original Message-----
From: Tyler Erickson [mailto:[log in to unmask]] 
Sent: Wednesday, June 04, 2003 5:17 PM
To: [log in to unmask]
Subject: [HP3000-L] Error: -2147467259 [Microsoft][ODBC Driver Manager]
Data source name too long

 I am trying to open an access database and my code is crashing at the
very beginning when I try to open the DB with the following code.

cnn.Open "C:\Documents and Settings\tyler\short.mdb;"

the error message I'm getting is

Error: -2147467259 [Microsoft][ODBC Driver Manager] Data source name
too long

I've shortened the path name as much as I could, or is there another
problem that I am totally missing? (most likely)

Any ideas would be very helpful.
Tyler

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *