September 7th, 2007, 01:59 PM
SQL SERVER 2000 to ACCESS 2007
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!!!
September 7th, 2007, 03:10 PM
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.
September 8th, 2007, 01:20 AM
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
October 2nd, 2007, 07:58 PM
yes , it would be easy using DTS in mssql2000
tools..data transformation services .. import data
Data Source : microsoft access
browse to the file
the other is self explanatory
By cheyenne1212 in forum Miscellaneous Security Discussions
Last Post: February 1st, 2012, 02:51 PM
By Nokia in forum The Security Tutorials Forum
Last Post: October 23rd, 2006, 05:58 PM
By red_budha in forum Miscellaneous Security Discussions
Last Post: April 1st, 2006, 08:16 PM
By mohaughn in forum Microsoft Security Discussions
Last Post: October 13th, 2004, 05:31 AM
By Nokia in forum Tips and Tricks
Last Post: June 12th, 2004, 06:13 PM