INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

convert a .mdf file to .mdb

convert a .mdf file to .mdb

(OP)
I need to convert a .mdf file to be viewable in Access. I am assuming the step is to first open the file in SQL Server Management Studio Express, however, when I do so I get a message that says "The operation could not be completed. Not enough storage is available to process this command."
Any suggestions as how to get around this? The file is on the large side (1GB), however, I have about 20GB free space on my computer. Or perhaps I am using the wrong steps to convert the file. Thoughts? Thanks!

RE: convert a .mdf file to .mdb

This is no conversion issue. You have two totally different things at hand with an MSSQL Server database MDF file and the goal to create an Access legacy MDB.

In the first place the MDF normally is accompanied by an LDF and the first thing to do if that's all you have is install MSSQL and attach the MDF/LDF files as database, then export into a new empty Access DB or use Access to import from the MSSQL database.

I don't know what command you issued caused the error messsage "The operation could not be completed. Not enough storage is available to process this command." You should tell so if you want to get help with that.

Bye, Olaf.

RE: convert a .mdf file to .mdb

Yes, Normally if you need SQL Server data in Access you would do it with ODBC data import.

Create a DSN in ODBC Administration that points to the SQL Server and database. Then in Access create a new database then go to the External Data tab. Once there chose ODBC Database and follow the prompts.

Simi

RE: convert a .mdf file to .mdb

The error may be related to RAM not. A reboot usually solve this problem.
--Method 1---
First attach that file to SQL server then export all the tables in excel and then import that execl file in access. If the file is corrupted or doesn't open you can try to open it using a paid mdf open file tool

RE: convert a .mdf file to .mdb

--Method 2---
Build SSIS package which export tables from SQL to access.

RE: convert a .mdf file to .mdb

(OP)
Thank you guys for your feedback and help. Thank you!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close