lothos12345 Posted September 19, 2003 Posted September 19, 2003 I am trying to run a report created in Microsoft Access from VB.NET. However every time I try to run the report it tells me that the Access Database is missing or I do not have access to it. Which is funny because I was able to populate a DataGrid using the same database off of a OleDbConnectionString. The error is occuring on the line that I pasted below: appAccess.OpenCurrentDatabase("\\<ip address>\database folder\DailyFloorOpps\AllStoresDB\DailyFloorOpps.mdb") Any help with this would be greatly appreciated. And yes I do close the OleDb connection before running the above code. Quote
Gladimir Posted September 20, 2003 Posted September 20, 2003 Possible problem with escape characters... You may want to consider putting the @ character in front of your path string: appAccess.OpenCurrentDatabase(@"\\<ip address>\database folder\DailyFloorOpps\AllStoresDB\DailyFloorOpps.mdb") This will prevent those back-slashes from being seen as special characters. I hope this helps. Quote Never ascribe to malice that which is adequately explained by incompetence. - Napoleon Bonaparte
lothos12345 Posted September 20, 2003 Author Posted September 20, 2003 Unforunately when I tried to use the @ symbol as you suggested it gave me the error "Invalid character". Is there anything else I could possibly try. And again thank you for your help. Quote
techmanbd Posted September 23, 2003 Posted September 23, 2003 I am not 100% sure why, but i just tried using oleDBconnection to open my database in ACCESS and got an error so I used the odbcconnection and it worked. Quote Live as if you were to die tomorrow. Learn as if you were to live forever. Gandhi
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.