Results 1 to 2 of 2
  1. #1
    GBR2l is offline Novice
    Windows XP Access 2007
    Join Date
    Nov 2010
    Posts
    1

    Copy database structure and all querries to new database


    Hi

    Is there a way to copy database structure and all querries to new database preferably without having to delete all the records as we have a DB that has 10million records and is full!

    Thanks

    GBR2L

  2. #2
    ssanfu is offline Master of Nothing
    Windows 2K Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    It is not the number of records the mdb holds, it is the file size. Is your mdb close to the 2 gb file size?

    Is your mdb split? ie a backend (BE) with the data and a front end (FE) that holds everything else - forms, reports, queries, modules?

    If it is split, then from windows, copy the BE and delete the data. Rename the file and relink it to the FE.


    You could also use SQL Server Express 2008 (max file size 4 gb IIRC) as the BE and still use the Access mdb as the FE.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 08-12-2010, 08:38 AM
  2. Developer Gone Cannot Access Database Structure
    By jonsuns7 in forum Security
    Replies: 4
    Last Post: 08-01-2010, 11:07 PM
  3. Help with Database Structure
    By scottay in forum Access
    Replies: 8
    Last Post: 06-30-2010, 08:16 AM
  4. Database Structure | Best Practice Question
    By davidson12 in forum Forms
    Replies: 0
    Last Post: 11-05-2009, 03:29 PM
  5. database structure:primary key debate
    By MUKUDU99 in forum Database Design
    Replies: 0
    Last Post: 08-19-2008, 12:20 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums