Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ODBC for MS Access database

Status
Not open for further replies.

sharonc

Programmer
Joined
Jan 16, 2001
Messages
189
Location
US
I'm trying to use a ODBC for an MS Access database. This is my connection: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\SEIMS\projects\ApacheProjects\Apache Projects Database.mdb;Persist Security Info=False"

I receive the following error: not a valid path.

Can someone tell me what I'm doing wrong?

Thank you.
 
Well if the database is in the same directory as the call above just use:

Code:
Data Source=Apache Projects Database.mdb;

By the way... file names with spaces in them are never good. I would add an _ between the words. It will make your life much easier.

Hope it helps.

Wow JT that almost looked like you knew what you were doing!
 
Thank you, I'll give this a try. I agree with you about the spaces in database names, but this someone else's database, so I left it alone.
 
someone else's database" not when you are working on it. educate them to never use spaces in any file names

Cheech

[Peace][Pipe]
 
Good Point. I will. Thanks.
 
also,u might look up ServerMapPath AFTER the name change

:--------------------------------------------------------------------------:
fugitive.gif

ok,ok...I did shoot the deputy but he told me he was the sheriff!
:--------------------------------------------------------------------------:
 
Thank you. I couldn't get it to work, so I moved the data to SQL Server and it works great.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top