Access to MDF?
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=21346
Printed Date: 09 April 2026 at 1:15am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Access to MDF?
Posted By: balearicjobs
Subject: Access to MDF?
Date Posted: 20 September 2006 at 7:50am
|
Not the favoured television home makeover show material but the file.
Does anybody know how to convert an Access database, in this case a V8.4 WWF Access database into an "mdf" file using software currently available on the internet or with Access 2003?
I am trying to convert my forum which currently has 15,000 members (so can't start again) from Access to SQL for performance, secruity and corruption avoidance reasons and Borg mentioned that if you had a mdf file it should be possible to attach this to an SQL database. ------------- Thanks for your help!!! Kind Regards Rob, http://www.balearic-jobs.com" rel="nofollow - Balearic Jobs Helping young people find seasonal work in the Balearic Islands, including vacancie |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 20 September 2006 at 8:35am
|
You need to be using the DTS tools, try the upsize wizard in Access and have a look at the sticky topic in the version 7.x forum on Access to SQL Server Step by Step
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: balearicjobs
Date Posted: 20 September 2006 at 10:13am
|
When you say DTS tools, do you mean something like http://www.sqlserverportal.com/software/datatransfer/datatransfer.htm - DTS Soft ?
As mentioned in my previous post, I can't follow those instructions as I am unable to get hold of a copy of Enterprise Manager, I don't believe that it's currently available. ------------- Thanks for your help!!! Kind Regards Rob, http://www.balearic-jobs.com" rel="nofollow - Balearic Jobs Helping young people find seasonal work in the Balearic Islands, including vacancie |
Posted By: WebWiz-Bruce
Date Posted: 20 September 2006 at 10:35am
|
The DTS tools are built into Enterprise manager, without this I'm afraid you maybe stuck with Access or start again with a clean install on SQL Server.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: balearicjobs
Date Posted: 20 September 2006 at 10:56am
Thats scary. So now Enterprise Manager is apparently not available people will not be able to upgrade from Access to SQL?
 Do you know where its possible to download legally, or purchase Enterprise Manager? ------------- Thanks for your help!!! Kind Regards Rob, http://www.balearic-jobs.com" rel="nofollow - Balearic Jobs Helping young people find seasonal work in the Balearic Islands, including vacancie |
-boRg- wrote:Posted By: WebWiz-Bruce
Date Posted: 20 September 2006 at 10:59am
|
You would need to get SQL Server 2000
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: nexus
Date Posted: 20 September 2006 at 11:21pm
|
Don't think you need to start from scratch again! Since you're not able to get the enterprise version, couldn't you ask one of the guys in here which have enterprise version to upsize/convert it for you? I mean, downloading the access db is no problem, so you only have to hand it out then to someone whom you TRUST and then let them run it through the DTS tool for you. Or am I mistaken somewhere?? =) |