CODEWITHSUNDEEP
c#databaseoledbadox
OrangeWall
OrangeWall

Reputation: 79

Is it possible to create a MS Access database using OLEDB?

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

Upvotes: 2

Views: 722

Answers (1)

SQL Police
SQL Police

Reputation: 4196

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.

Upvotes: 1

Related Questions