Monday, 19 August 2013

Dynamic Data Connection to Access Database files C#

Dynamic Data Connection to Access Database files C#

For the past three days, I've been struggling to get dynamic access to
.accdb files for a little program I am tinkering with. I'm at wits end on
how to do it, I've scoured StackOverflow, MSDN, Youtube spent well over
$100.00 on C# books and I still can't find it.
I know it's in bad taste to ask a question here without code, but I am
just so tired after two and half days with little to no sleep of trying to
figure it out.
My goal, is to have a file in the root directory of my program called
userData, within it are three other files, customData, openData and
propData. Each one will contain anywhere between 0 and 10 .accdb files in
the same format when manually added by the user outside the application.
(openData is an exception, it will always at least contain one .accdb
file)
I have no idea how to get this type of dynamic access set up. I've been
fighting with the OleDB library trying to manually generate connection
strings with zero success. I do know how to work with the access database
once it's loaded, I'm not asking for it to be done for me; but if anyone
knows a tutorial or can link me to an example I can take it from there.
Sorry to break decorum, but it's kind of disheartening when you spend a
week learning a language with no hiccups and one concept is seemingly
beyond your reach...

No comments:

Post a Comment