I've seen a few answers to this, but all of them use ADOX which I don't exactly know how to use. Is it possible to do it entirely with OLEDB? If so, how? Thanks in advance
5
-
Is it creating or using or bothDrew– Drew2015-06-30 19:18:41 +00:00Commented Jun 30, 2015 at 19:18
-
Which version do you wantDrew– Drew2015-06-30 19:40:25 +00:00Commented Jun 30, 2015 at 19:40
-
any versio will be enoughOrangeWall– OrangeWall2015-06-30 19:43:32 +00:00Commented Jun 30, 2015 at 19:43
-
Everything I see is ADO and msoffice foobar'd many peoples devboxes mine included for OLEDB 12.x or 14 I forget. Not much focus out there on c# OLEDB.Drew– Drew2015-06-30 21:08:25 +00:00Commented Jun 30, 2015 at 21:08
-
Perhaps you can describe the big picture (like flexibility on the fly). No lack of ADO examples out there. Maybe if you had a stub of an MSACCESS db skeleton you would be all set. Maybe notDrew– Drew2015-06-30 21:10:39 +00:00Commented Jun 30, 2015 at 21:10
Add a comment
|
1 Answer
The database itself (i.e. the empty .accdb file) cannot be created via OLEDB.
But once you have an empty access file, you can connect to it via OLEDB, and then you can create tables, views, etc. by executing create table statements.
I once did a solution where I packed an empty database directly into my resources and copied it at runtime into a user's directory.
