Results 1 to 5 of 5
  1. #1
    afg9881 is offline Novice
    Windows Vista Access 2007
    Join Date
    May 2011
    Posts
    9

    Exporting entire Database


    i need to export all the information from an entire database including the Tables, reports, and queries but i dont want to import the settings or the restrictions

    Is This Possible

    the creator of our companies database is no longer here and we have and audit in 2 months and nobody knows how to get in and update it

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    where are you exporting it to?? depending on your destination, there are already tools out there to do this. No effort would be required by you.

  3. #3
    afg9881 is offline Novice
    Windows Vista Access 2007
    Join Date
    May 2011
    Posts
    9
    just trying to export it into a new access database

  4. #4
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    Quote Originally Posted by afg9881 View Post
    just trying to export it into a new access database
    ummm...use the export wizard and select all the objects. that's about it...

  5. #5
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Conversely, open a new database and import the required objects using the wizard there. Take your pick ---import or export.

    Alan

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

Similar Threads

  1. QBF (search entire field)
    By 161 in forum Queries
    Replies: 9
    Last Post: 02-09-2011, 03:01 PM
  2. Replies: 2
    Last Post: 11-16-2010, 10:55 AM
  3. Border surrounding entire Report
    By yes sir in forum Access
    Replies: 1
    Last Post: 11-13-2010, 01:58 PM
  4. Exporting Forms to another Database
    By Rawb in forum Forms
    Replies: 3
    Last Post: 05-07-2010, 09:27 AM
  5. How to loop code to run through entire table
    By kmajors in forum Reports
    Replies: 9
    Last Post: 04-23-2010, 09:27 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