1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Splitting Access Database

Discussion in 'Business Applications' started by Slimboy Fat, Dec 29, 2004.

Thread Status:
Not open for further replies.
Advertisement
  1. Slimboy Fat

    Slimboy Fat Thread Starter

    Joined:
    Oct 29, 2004
    Messages:
    156
    We have quite a hefty database (approx 90meg) that we would like to split into 2 smaller databases.

    The plan is that if a certain "Date" field is older than a set date or another field = "Closed" then these records can be move to a archive database. The archive database needs to still have all the forms, queries and reports.

    Is there software to do this or is it a case of make a copy of the database as the archive then manually delete the records that match the above criteria.


    TIA
    Raw2K
     
  2. HeavyBall

    HeavyBall

    Joined:
    Oct 29, 2004
    Messages:
    72
    In access, create a new blank db. Go to File...Get External Data...Import...

    Import all tables, queries, reports, etc. that you want.

    In the table in the new DB, run a maketable query, pulling all records where Date < (cutoff date) or other field = "Closed".

    This new table will have your backup info. Delete the table you initially imported.
     
  3. Slimboy Fat

    Slimboy Fat Thread Starter

    Joined:
    Oct 29, 2004
    Messages:
    156
    Thanks HeavyBall.

    Just had a similar idea from somebody else (not on forums). Make a copy of the database then run a query to delete where Date < etc etc.

    With your idea is there a way to "Move" the data instead of "Copying".

    TIA
    Raw2K
     
  4. HeavyBall

    HeavyBall

    Joined:
    Oct 29, 2004
    Messages:
    72
    Not that I know of. I'm pretty sure you'll have to copy it via a make table query.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/312851

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice