Creeating MS Access database dynamically

Article View: borland.public.cppbuilder.database.ado

Article #794

Back to borland.public.cppbuilder.database.ado Previous Next

#794

From: Eric Archer
Date: Wed, 27 Apr 2005 16:13

4 lines
1343 bytes

I'm using BCB 6 and am fairly new at working with databases.  I've been successful at interacting with my MS Access database using ADO, but I've got an issue that I haven't found any way to solve:

If someone "accidentally" deletes the database file, I'd like the application to check for its existence (if (!FileExists("data.mdb")), and to create a new database file, regenerate the fields, and populate it with a minimum of data hardcoded in the application.  Is this possible with ADO and MS Access?  Thanks!

Technical Details

Message-ID: <426fba1d$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!newsread.com!news-xfer.newsread.com!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,e15b10e8565000ef,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Eric Archer" <eric.archer@noaa.gov>
Sender: "Eric Archer" <eric.archer@noaa.gov>
Reply-To: "Eric Archer" <eric.archer@noaa.gov>
Subject: Creeating MS Access database dynamically
Newsgroups: borland.public.cppbuilder.database.ado
X-User-Info: 137.110.142.242     
NNTP-Posting-Host: 207.105.83.66
Message-ID: <426fba1d$1@newsgroups.borland.com>
Date: 27 Apr 2005 09:13:17 -0700
X-Trace: newsgroups.borland.com 1114618397 207.105.83.66 (27 Apr 2005 09:13:17 -0700)
Lines: 4
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!newsread.com!news-xfer.newsread.com!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail