sql .bak into .mdb

[EnergyTed]

I have a .bak sql server 2005 file I would like to convert into access. Can anyone inform me if this is possible and of the steps involved. I am using Access 2007 on a stand alone pc.


Kind Regards

Ted

 

[JBinQLD]

Download and install free SQL Server Express

create a new db and then restrore over it your .bak file

Create an odbc connection to the database you've just installed

Create an access db and connect to the tables in the OBDC connection

Write a funky function to loop through all tables and executre a make table of * on each one.

Sounds like lots of work but it's no drama mate, wont take long

JB

 

[EnergyTed]

Thats great, but can I set up a serveror a local connection on my stand alone pc when I install sql server express?

 

[JBinQLD]

yep, no problem at all

i use it all day, every day.

 

[EnergyTed]

Ok, can you provide some brief steps on how to configure or create a new db within ssmse. It is looking for a server to connect to. I do not know how to set this up?

 

[JBinQLD]

This is a bit off post for an access forum mate, start a thread somewhere in another forum and post it back here so we can continue... But to answer your question, just press connect, your pc becomes the SQL server after installing the software. Something like [yourcompname]\SQLEXPRESS all in UPPER CASE with windows authentication turned on.