Results 1 to 4 of 4

Thread: SQL SERVER 2000 to ACCESS 2007

  1. #1
    Senior Member codenamevirus's Avatar
    Join Date
    Jun 2005
    Location
    Faridabad, Haryana, India
    Posts
    298

    SQL SERVER 2000 to ACCESS 2007

    Hi

    I have a database that was made in SQL SERVER 2000....I have the mdf and ldf files. Due to certain constraints and requirements, I want to have the same database in Access 2007.

    So, is there a way to import directly the database....it'll be fine even if only the tables are imported. Creating the database all over from scratch will be really hectic....any solutions or suggestions....plz share!!!
    CodeNameVirus

  2. #2
    THE Bastard Sys***** dinowuff's Avatar
    Join Date
    Jun 2003
    Location
    Third planet from the Sun
    Posts
    1,253
    Not so straight forward in SQL 2000 2005 has a neat little wizard.

    Anyway In enterprise manager first Generate your SQL Scripts. In access (And this is from memory) you create a new database from file, or object - can't remember.

    Once your database is created you can export the data from SQL to the Access database you just created. If you monkey around with it enough you may be able to get all trust relationships, users, object rights, etc.

    Good luck, it's a pain in the ass to go backwards.
    09:F9:11:02:9D:74:E3:5B8:41:56:C5:63:56:88:C0

  3. #3
    Ninja Code Monkey
    Join Date
    Nov 2001
    Location
    Washington State
    Posts
    1,027
    It's fairly straightforward through 2000 via DTS. It won't support everything the 2000 db did but you will have your data.
    "When I get a little money I buy books; and if any is left I buy food and clothes." - Erasmus
    "There is no programming language, no matter how structured, that will prevent programmers from writing bad programs." - L. Flon
    "Mischief my ass, you are an unethical moron." - chsh
    Blog of X

  4. #4
    Senior Member
    Join Date
    Sep 2004
    Posts
    117
    yes , it would be easy using DTS in mssql2000
    tools..data transformation services .. import data
    next
    Data Source : microsoft access
    browse to the file
    the other is self explanatory

Similar Threads

  1. Windows Error Messages
    By cheyenne1212 in forum Miscellaneous Security Discussions
    Replies: 7
    Last Post: February 1st, 2012, 02:51 PM
  2. PIX: Access Control Lists and Content Filtering
    By Nokia in forum The Security Tutorials Forum
    Replies: 0
    Last Post: October 23rd, 2006, 04:58 PM
  3. breaking tru firewall
    By red_budha in forum Miscellaneous Security Discussions
    Replies: 3
    Last Post: April 1st, 2006, 08:16 PM
  4. October MS updates
    By mohaughn in forum Microsoft Security Discussions
    Replies: 2
    Last Post: October 13th, 2004, 04:31 AM
  5. Windows 2000 Tips
    By Nokia in forum Tips and Tricks
    Replies: 0
    Last Post: June 12th, 2004, 05:13 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •