This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 75%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBV%3C/text%3E%3C/svg%3E)
I wrote a small application in VB.NET (VS 2022), and it worked well with the connection string without white space. When I put it in the folder with spaces and that is where I have issues with it. How do I solve this issue with the white space?
I do not have issues with the following connection string
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Work\Project\mydb.mdb"
I do have issues with the following connection string
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Work\Project\mydb.mdb"
I tried with single quote around the directory path but it did not work
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source='C:\Program Files\Work\Project\mydb.mdb'"
This is where the database will be. How do I solve this issue with the white space?
In VB try this:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=""C:\Program Files\Work\Project\mydb.mdb"""
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
you need to use double quotes. so the string should be:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source="C:\Program Files\Work\Project\mydb.mdb";
or as a c# literal:
var cs = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=""C:\Program Files\Work\Project\mydb.mdb"";";
Bruce,
Thank you very much for answering my question.
I did. I put it in double quote for entire connection string, but it did not work.
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Work\Project\mydb.mdb"
That did not work. I then tried with the single quote around the directory path with double quote in place of the entire connection string and that did not work either.
I should mention that this is VB.NET
Thank you. I just tried it, and it did not work.
I have been looking at Microsoft website this morning and could not find anything regarding to white space in connection string.
To make sure that the problem is not caused by some specific issues (such as permissions), try to put the data file to a location like C:\Work\My Project\mydb.mdb and check if spaces are accepted. If possible, show the error details.
Hello,
Does anyone know how to solve the issues with the white space in connection string?
Thanks.
It seems to work with and without quotation marks and apostrophes. Maybe you should describe in more detail what “does not work” means.