Re: Creating a new Access database file (.mdb) in .NET/C#

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi. Thanks for responding. I'm sorry it took me so long to get back
to you.

On Mon, 29 Oct 2007 10:21:31 -0500, Cowboy (Gregory A. Beamer) <NoSpamMgbworld@xxxxxxxxxxxxxxxxxx> wrote:
You can create the file with the Office bits.

Um... did you have any particular "bits" in mind?

... If you want to avoid
this (as I have in the past), create an empty shell MDB file and you
can then run your DDL commands against it. If the database
"created" always has certain tables and seed values, I would make
the "shell" with those tables and that info already in it.

Sounds good. Up until now, all the databases (not many) have been
manually created using COPY or a GUI equivalent; this would simply
automate the process.

The "down" side, of course, is that if the "prototype" file goes
missing the user will need to recover it from some place. Hm... I'm
using an "MSI" install, so presumably he/she/it could simply run an
Add/Remove Programs "Repair" operation to recover it. (Note to self:
_Test_ this! <grin>)

To do this, copy the MDB file (shell) to a folder and run the DDL
against it to finish set up.

This only answers part of your issue, of course, but you can add
this method to the case where the file is missing or wrong, etc.

Well, if I can't create a new one "from scratch", a missing file
will present some problems, yes? <grin!>

Thanks again for the suggestion.


Frank
--
Cats are smarter than dogs. You can't get eight cats to
pull a sled through snow. -- Jeff Valdez
--
Frank McKenney, McKenney Associates
Richmond, Virginia / (804) 320-4887
Munged E-mail: frank uscore mckenney ayut minds pring dawt cahm (y'all)
.

Relevant Pages

  • Re: Problem with `big oh estimates in number theory
    ... >an open mind. ... My excuse for that is that last misunderstanding ... Perhaps I'm missing your point (although it ... the only "extra facts" to which Apostol could ...
    (sci.math)
  • Re: Video dedication: El Marabino
    ... You are missing some sweet points here. ... But for listener ... Hands must be slaves of mind, ... that you should base your actions on reality, you are too often led to ...
    (rec.music.classical.guitar)
  • Re: from the NYTimes
    ... You're right that they will probably find more missing, ... will commit embezzlement for surprisingly low sums. ... Keep in mind that this ... > have required an accomplice i suspect it will ...
    (alt.coffee)
  • Re: Video dedication: El Marabino
    ... You are missing some sweet points here. ... But for listener ... Hands must be slaves of mind, ...
    (rec.music.classical.guitar)
  • Re: Anti-Road protesters occupy Dept of Transport.
    ... > You are missing the point. ... hence why they are piss poor. ... Mind you its impossible to know how ... objective and accurate Indy Media are. ...
    (uk.transport)