Issues of Making MS-Access Schema

Rajesh Singh007

Hello Everyone, Actually I am facing one problem, please help me... How to create schema in ms-access database using C# code? Thanks in advance!!

Luc Pattyn

Your question isn't very clear to me, however this[^] could be the answer. :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

Rajesh Singh007

Actually I want to create ms-access database with some schema name with the help of c# code.

Luc Pattyn

Sorry, can't help you there; I have been using both Access and SQLServer, but always migrating away from Access, never creating one. :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

riced

Using Interop you should be able to do this. That assumes you know how to create databases, tables etc using Access objects. You might be able to do it running SQL queries in Access - again assuming you know the required SQL. You can pick up some of it in the Access designer for queries - just create a make table one then switch to SQL view.

Regards David R --------------------------------------------------------------- "Every program eventually becomes rococo, and then rubble." - Alan Perlis The only valid measurement of code quality: WTFs/minute.

SilimSayo

Here is my suggestion. IF you have a copy of access, use it create the tables and views that you need. After doing that, you can write your C# application to use the Access database. I think you will find it a lot easier to create the database within MS Access that try to create it using C#.