convert a .mdf file to .mdb 3

[olafurpetursson]

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!

 

[Olaf Doschke]

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.

 

[simian336]

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

 

[morrishall]

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

 

[morrishall]

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

 

[olafurpetursson]

Thank you guys for your feedback and help. Thank you!