| Author |
Topic |
|
David Thomas
Starting Member
4 Posts |
 Posted - 2008-04-02 : 15:18:48
|
| All I want to do is open an .mdf file. So I have downloaded and installed SQL Server 2005 Express Edition. I have searched HELP but I see nothing simple. How do I add a file to this server so that I can read the file in Access?Thank you very much for any help you can give.David Thomas |
|
|
marco gwiliani
Starting Member
25 Posts |
Posted - 2008-04-02 : 15:30:49
|
| Right click on Databases>Attach>Add the file you want to attach to (.mdf) then click OK. This should then open the file in Management Studio Express.rgdsMArco |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-02 : 15:41:37
|
| Where did you get this .mdf files from? |
|
|
|
David Thomas
Starting Member
4 Posts |
Posted - 2008-04-02 : 17:32:35
|
| MArco.Thank you for your prompt reply. But how do I get to Databases or to Management Studio Express? All I seem to get to is SQL Server Configuration Manager or something similar and from this I can get nothing very helpful to me.Sorry to be so dense.Regards,David Thomas |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-02 : 17:52:41
|
| Run SQLWB.exe on run or open SSMS |
|
|
|
David Thomas
Starting Member
4 Posts |
Posted - 2008-04-04 : 10:36:07
|
| MArco,I have downloaded Management Studio Express, but still I do not see how to follow your instructions Databases>Attach etc. I repeat all I want to do is read .mdf files in Access, but I seem to be in something far too complex. I would much appreciate further help.Thank you,David Thomas |
|
|
|
readysetstop
Posting Yak Master
123 Posts |
Posted - 2008-04-04 : 11:51:23
|
| David, Forgive me if I'm talking beneath your level, but it sounds like you're not familiar with SQL. Here's a step by step to get you to where Marco is.1. Open management studio.2. Find the Object Explorer pane. If it is not displayed, there is a button on the toolbar at the top to activate it.3. In the Object Explorer, click on 'Connect', and select 'Database Engine'.4. If the name of your machine is not displayed, enter '(local)' without the quotes. Use Windows Authentication, and click 'Connect'. Your server should now show up in Object Explorer. 5. If it is not already, expand the server node and find the 'Databases' folder. Right click on that, and follow Marco's instructions, above. Post again if you need more help.____________________________________________________________________________________"Believe in those who are seeking the truth. Doubt those who say they have found it." -Andre Gide |
|
|
|
David Thomas
Starting Member
4 Posts |
Posted - 2008-04-04 : 16:11:13
|
| Master,Yes I am quite unfamiliar with SQL, but I hope to get some glimmering.Thank you very much indeed; your instructions along with those of Marco has enabled me to open the mdf files. I am really most grateful.David |
|
|
|
raky
Aged Yak Warrior
767 Posts |
Posted - 2008-04-06 : 05:52:08
|
| Try this select sp_helpfileThen we get the ldf and mdf filesBe happy |
|
|
|
|
Opening .mdf files