Connect to DB with space in name?

[karenpc]

I have an access database named Inservices Data.mdb Is there any way to specify this so my connect will work? VB does not like this...
data1.databasename = c:\Inservices\Inservices Data.mdb

thanks!

 

[WoodLark]

Have you tried enclosing it in quotes?

data1.databasename = "c:\Inservices\Inservices Data.mdb"

 

[karenpc]

Yes I have tried this with quotes, but it doesn't work.

 

[lovell811]

you could just change the name of the db so there isn't a space
----------------
Joe

 

[karenpc]

That thought had crossed my mind. But since numerous people are using it on a server, I don't think they would appreciate that.

 

[fvsj33a]

If you are using this on a server the problem might be that you are referencing the C: drive for this database.

 

[RiverGuy]

Make an ADO object, and use the connection string wizard to bind to it. Then cut out the path part of it, delete the ADO object, and paste that path in your code. Give it a try anyways.

 

[rtshort]

I have some DB's with a space. I just put brackets around the name and it works OK. I use SQL though. Try it like this:


c:\Inservices\[Inservices Data.mdb]


Rob
Just my $.02.

 

[karenpc]

Thanks very much Rob. The brackets worked!