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
Asked
Active
Viewed 505 times
2
-
Is it creating or using or both – Drew Jun 30 '15 at 19:18
-
Which version do you want – Drew Jun 30 '15 at 19:40
-
any versio will be enough – OrangeWall Jun 30 '15 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 Jun 30 '15 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 not – Drew Jun 30 '15 at 21:10
1 Answers
1
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.
SQL Police
- 4,127
- 1
- 25
- 54