Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #10404 > unrolled thread

Access 97 empty database file

Back to article view | Back to comp.databases.ms-access

Contents

  Access 97 empty database file Pinco Pallo <tenentepincopallo@gmail.com> - 2015-02-24 01:01 -0800
    Re: Access 97 empty database file Patrick Finucane <patrickfinucanetx@gmail.com> - 2015-02-24 08:48 -0800
      Re: Access 97 empty database file Pinco Pallo <tenentepincopallo@gmail.com> - 2015-02-25 02:23 -0800
        Re: Access 97 empty database file Dave W <davewi11@yahoo.co.uk> - 2015-02-25 10:42 +0000
      Re: Access 97 empty database file Steve Hayes <hayesstw@telkomsa.net> - 2015-02-25 15:06 +0200
        Re: Access 97 empty database file Patrick Finucane <patrickfinucanetx@gmail.com> - 2015-02-25 06:19 -0800
          Re: Access 97 empty database file Steve Hayes <hayesstw@telkomsa.net> - 2015-02-26 05:15 +0200
            Re: Access 97 empty database file Larry Linson <larry.linson@verizon.net> - 2015-02-25 23:49 -0600
              Re: Access 97 empty database file Steve Hayes <hayesstw@telkomsa.net> - 2015-02-26 11:06 +0200
                Re: Access 97 empty database file "Joan Wild" <joanwild@xplornet.com> - 2015-02-26 17:46 +0000
                Re: Access 97 empty database file Larry Linson <larry.linson@verizon.net> - 2015-02-26 16:24 -0600
            Re: Access 97 empty database file Patrick Finucane <patrickfinucanetx@gmail.com> - 2015-02-26 06:51 -0800
    Re: Access 97 empty database file Ron Weiner <rw@domain.com> - 2015-02-25 19:06 -0500
    Re: Access 97 empty database file "Joan Wild" <joanwild@xplornet.com> - 2015-02-26 17:45 +0000

#10404 — Access 97 empty database file

Where can I download an empty access 97 database? I need such a file in order to export data from an old software that needs an existing mdb file.

[toc] | [next] | [standalone]

#10407

On Tuesday, February 24, 2015 at 4:01:52 AM UTC-5, Pinco Pallo wrote:
> Where can I download an empty access 97 database? I need such a file in order to export data from an old software that needs an existing mdb file.

Open up and create a new database

[toc] | [prev] | [next] | [standalone]

#10417

If I had an access 97 installation, sure I didn't ask. I have Access 2003 that is incompatible with 97.

On Tuesday, February 24, 2015 at 5:48:58 PM UTC+1, Patrick Finucane wrote:
> On Tuesday, February 24, 2015 at 4:01:52 AM UTC-5, Pinco Pallo wrote:
> > Where can I download an empty access 97 database? I need such a file in order to export data from an old software that needs an existing mdb file.
> 
> Open up and create a new database

[toc] | [prev] | [next] | [standalone]

#10418

On Wed, 25 Feb 2015 02:23:14 -0800 (PST), Pinco Pallo
<tenentepincopallo@gmail.com> wrote:

>If I had an access 97 installation, sure I didn't ask. I have Access 2003 that is incompatible with 97.
>
>On Tuesday, February 24, 2015 at 5:48:58 PM UTC+1, Patrick Finucane wrote:
>> On Tuesday, February 24, 2015 at 4:01:52 AM UTC-5, Pinco Pallo wrote:
>> > Where can I download an empty access 97 database? I need such a file in order to export data from an old software that needs an existing mdb file.
>> 
>> Open up and create a new database

I have both Access 2003 and 97. I see that 2003 has no facility for
saving as 97, although it can convert from 97 to 2003. Your old
software surely must require a particular table structure to export
to, not just any old mdb file?
-- 
Dave W

[toc] | [prev] | [next] | [standalone]

#10419

On Tue, 24 Feb 2015 08:48:50 -0800 (PST), Patrick Finucane
<patrickfinucanetx@gmail.com> wrote:

>On Tuesday, February 24, 2015 at 4:01:52 AM UTC-5, Pinco Pallo wrote:
>> Where can I download an empty access 97 database? I need such a file in order to export data from an old software that needs an existing 
>
>Open up and create a new database

What I'd like to know is how to empty an existing Access database.

I create a database, enter some data to test it, then, when I'm happy
that it's workling the way I want it to, I want to empty the test data
and begin using it for real data. 

It was easy to empty tables in Paradox, but I can't find how to do it
in Access. 


-- 
Steve Hayes from Tshwane, South Africa
Web:  http://www.khanya.org.za/stevesig.htm
Blog: http://khanya.wordpress.com
E-mail - see web page, or parse: shayes at dunelm full stop org full stop uk

[toc] | [prev] | [next] | [standalone]

#10420

On Wednesday, February 25, 2015 at 8:02:41 AM UTC-5, Steve Hayes wrote:
> On Tue, 24 Feb 2015 08:48:50 -0800 (PST), Patrick Finucane
> <patrickfinucanetx@gmail.com> wrote:
> 
> >On Tuesday, February 24, 2015 at 4:01:52 AM UTC-5, Pinco Pallo wrote:
> >> Where can I download an empty access 97 database? I need such a file in order to export data from an old software that needs an existing 
> >
> >Open up and create a new database
> 
> What I'd like to know is how to empty an existing Access database.
> 
> I create a database, enter some data to test it, then, when I'm happy
> that it's workling the way I want it to, I want to empty the test data
> and begin using it for real data. 
> 
> It was easy to empty tables in Paradox, but I can't find how to do it
> in Access. 
> 
> 
> -- 
> Steve Hayes from Tshwane, South Africa
> Web:  http://www.khanya.org.za/stevesig.htm
> Blog: http://khanya.wordpress.com
> E-mail - see web page, or parse: shayes at dunelm full stop org full stop uk

Well, you could create a new database.  Then select File/GetExternalData for 2003- or select ExternalData from the ribbon 2007+ and select the Access icon.   Select the file to import from, select import tables, press OK, then select all of the tables, press the Options button, and select Structure ONly.

[toc] | [prev] | [next] | [standalone]

#10422

On Wed, 25 Feb 2015 06:19:21 -0800 (PST), Patrick Finucane
<patrickfinucanetx@gmail.com> wrote:

>On Wednesday, February 25, 2015 at 8:02:41 AM UTC-5, Steve Hayes wrote:
>> On Tue, 24 Feb 2015 08:48:50 -0800 (PST), Patrick Finucane
>> <patrickfinucanetx@gmail.com> wrote:
>> 
>> >On Tuesday, February 24, 2015 at 4:01:52 AM UTC-5, Pinco Pallo wrote:
>> >> Where can I download an empty access 97 database? I need such a file in order to export data from an old software that needs an existing 
>> >
>> >Open up and create a new database
>> 
>> What I'd like to know is how to empty an existing Access database.
>> 
>> I create a database, enter some data to test it, then, when I'm happy
>> that it's workling the way I want it to, I want to empty the test data
>> and begin using it for real data. 
>> 
>> It was easy to empty tables in Paradox, but I can't find how to do it
>> in Access. 
>> 
>> 
>> -- 
>> Steve Hayes from Tshwane, South Africa
>> Web:  http://www.khanya.org.za/stevesig.htm
>> Blog: http://khanya.wordpress.com
>> E-mail - see web page, or parse: shayes at dunelm full stop org full stop uk
>
>Well, you could create a new database.  Then select File/GetExternalData for 2003- or select ExternalData from the ribbon 2007+ and select the Access icon.   Select the file to import from, select import tables, press OK, then select all of the tables, press the Options button, and select Structure ONly.

An "Empty Tables" function would be so much simpler. 


-- 
Steve Hayes from Tshwane, South Africa
Web:  http://www.khanya.org.za/stevesig.htm
Blog: http://khanya.wordpress.com
E-mail - see web page, or parse: shayes at dunelm full stop org full stop uk

[toc] | [prev] | [next] | [standalone]

#10423

On Thu, 26 Feb 2015 05:15:03 +0200, Steve Hayes
<hayesstw@telkomsa.net> wrote:

 > An "Empty Tables" function would be so much simpler. 

My daughter says about things she doesn't necessarily like but that
are not likely to be changed, "It is what it is." In 20+ years,
Microsoft has not seen the need for an "Empty Tables" function, and I
wouldn't bet money that they ever will.

Even individual apps benefit from a front-end (user interface) and
back-end (tables and data) approach. If you keep on top of every
change you make in the table structure/specifications and update your
copy, you can just copy the empty back-end that you use to start your
testing.

Importing the tables without data is about as simple as I could want,
it seems to me. 

It's quite a bit easier than creating a Delete Query for all fields in
each table.

 Larry Linson
 Microsoft Access MVP 2003 - 2014

[toc] | [prev] | [next] | [standalone]

#10424

On Wed, 25 Feb 2015 23:49:35 -0600, Larry Linson
<larry.linson@verizon.net> wrote:

>On Thu, 26 Feb 2015 05:15:03 +0200, Steve Hayes
><hayesstw@telkomsa.net> wrote:
>
> > An "Empty Tables" function would be so much simpler. 
>
>My daughter says about things she doesn't necessarily like but that
>are not likely to be changed, "It is what it is." In 20+ years,
>Microsoft has not seen the need for an "Empty Tables" function, and I
>wouldn't bet money that they ever will.
>
>Even individual apps benefit from a front-end (user interface) and
>back-end (tables and data) approach. If you keep on top of every
>change you make in the table structure/specifications and update your
>copy, you can just copy the empty back-end that you use to start your
>testing.
>
>Importing the tables without data is about as simple as I could want,
>it seems to me. 
>
>It's quite a bit easier than creating a Delete Query for all fields in
>each table.

And recreating all forms, queries, reports, from scratch?


-- 
Steve Hayes from Tshwane, South Africa
Web:  http://www.khanya.org.za/stevesig.htm
Blog: http://khanya.wordpress.com
E-mail - see web page, or parse: shayes at dunelm full stop org full stop uk

[toc] | [prev] | [next] | [standalone]

#10435

Steve Hayes wrote:


> 
> And recreating all forms, queries, reports, from scratch?

You can also import all the queries, forms, reports, macros and modules
using the same method.

[toc] | [prev] | [next] | [standalone]

#10439

On Thu, 26 Feb 2015 11:06:59 +0200, Steve Hayes
<hayesstw@telkomsa.net> wrote:

 >And recreating all forms, queries, reports, from scratch?

Only a masochist would even consider doing so... three easy ways:

1. Copy the DB file, delete the tables from the copy, and import the
tables sans data from the original.

2. As Joan said, import not only the tables without data, but all the
other objects, too.

3. As I said earlier, use the Front End - Back End approach, create a
new database and import the tables, then use method 1 or 2 above to
create the front end, and link the tables from the newly created
database with the empty tables.

In earlier days, I might have said, it's worth buying a beginner book
and reading it before launching off into using Access, but there've
been so many changes to publishing, disseminating information, and
such that it wouldn't be applicable to say so now. Back then, I might
have recommended going to your local bookstore and thumbing through
the beginner books. One I liked back then, was "Microsoft Access Step
by Step", but I haven't looked at it for quite a number of versions;
still, it'd be worth a look if you are near a bookstore with computer
books.

 Larry

[toc] | [prev] | [next] | [standalone]

#10425

On Wednesday, February 25, 2015 at 10:11:11 PM UTC-5, Steve Hayes wrote:
> On Wed, 25 Feb 2015 06:19:21 -0800 (PST), Patrick Finucane
> <patrickfinucanetx@gmail.com> wrote:
> 
> >On Wednesday, February 25, 2015 at 8:02:41 AM UTC-5, Steve Hayes wrote:
> >> On Tue, 24 Feb 2015 08:48:50 -0800 (PST), Patrick Finucane
> >> <patrickfinucanetx@gmail.com> wrote:
> >> 
> >> >On Tuesday, February 24, 2015 at 4:01:52 AM UTC-5, Pinco Pallo wrote:
> >> >> Where can I download an empty access 97 database? I need such a file in order to export data from an old software that needs an existing 
> >> >
> >> >Open up and create a new database
> >> 
> >> What I'd like to know is how to empty an existing Access database.
> >> 
> >> I create a database, enter some data to test it, then, when I'm happy
> >> that it's workling the way I want it to, I want to empty the test data
> >> and begin using it for real data. 
> >> 
> >> It was easy to empty tables in Paradox, but I can't find how to do it
> >> in Access. 
> >> 
> >> 
> >> -- 
> >> Steve Hayes from Tshwane, South Africa
> >> Web:  http://www.khanya.org.za/stevesig.htm
> >> Blog: http://khanya.wordpress.com
> >> E-mail - see web page, or parse: shayes at dunelm full stop org full stop uk
> >
> >Well, you could create a new database.  Then select File/GetExternalData for 2003- or select ExternalData from the ribbon 2007+ and select the Access icon.   Select the file to import from, select import tables, press OK, then select all of the tables, press the Options button, and select Structure ONly.
> 
> An "Empty Tables" function would be so much simpler. 
> 
> 
> -- 
> Steve Hayes from Tshwane, South Africa
> Web:  http://www.khanya.org.za/stevesig.htm
> Blog: http://khanya.wordpress.com
> E-mail - see web page, or parse: shayes at dunelm full stop org full stop uk

Here's a routine...untested.
Public Sub EmptyAllTables()
    Dim d As Database
    Dim t As TableDef
    Dim s As String
    
    Set d = CurrentDb
    For Each t In d.TableDefs
        If Left(t.Name, 4) <> "Msys" Then
            s = "DELETE " & t.Name & ".* From " & t.Name
            d.Execute s
        End If
    Next
    d.Close
    Set d = Nothing
End Sub

[toc] | [prev] | [next] | [standalone]

#10421

Pinco Pallo brought next idea :
> Where can I download an empty access 97 database? I need such a file in order 
> to export data from an old software that needs an existing mdb file.

I do not know where you might be able to download an empty Access 97 
databse, but I think you may be able to programmatically create one 
without using Access.  I have an app that does the routinely abet 
creating them in an Access 2000 format.

Check out this link:
http://en.wikibooks.org/wiki/JET_Database/Creating_and_connecting
and:
http://stackoverflow.com/questions/3455700/creating-access-97-format-database

Even after you do create a mdb that is of the Access 97 vintage, you 
will also have to create all of the objects that your legacy 
application expects will be there (Tables, queries, etc).  This is also 
possible but a little tedious.  Again my old app does this routinely,

Good luck with your project.

Rdub

[toc] | [prev] | [next] | [standalone]

#10434

Pinco Pallo wrote:

> Where can I download an empty access 97 database? I need such a file
> in order to export data from an old software that needs an existing
> mdb file.

You could go to
 http://access.mvps.org/access/resources/downloads.htm
Pick any of the 97 sample files - download and empty it.

[toc] | [prev] | [standalone]

Back to top | Article view | comp.databases.ms-access

csiph-web