create ms access database via asp.net?

[Sidro]

Hi,
Is it possible for asp.net to create an ms access database on the fly? And also, can asp.net create a new ms access field on the fly? thankx in advance.

 

[jtgurkin]

As far as i know the best way to create databases on the fly is to create an empoty database and write a file to copy it and rename it. Access can handle SQL commands like ALTER to ammend tables.

 

[Sidro]

hi,
So basically, I create a master copy of a data base and create something like a batch file to make another copy of the master copy.

Now suppose in the master copy I have 3 fields. What if i want to add more fields in the copied database, can asp.net create additional fields? If yes, could you please give an example?

thankx in advance.

 

[onpnt]

I had the same need a few weeks ago and used ADOX. I'm still in the research stages of finding a more efficient method though

ADOX

___________________________________________________________________
[sub]
onpnt.com
SELECT * FROM programmers WHERE clue > 0
(0 row(s) affected) -->faq333-3811
[/sub]