My web host only supports .mdb database files, so is there a way to convert .mdf to .mdb with a program? Or would I have to do it by hand?
Thank you.
I am not aware that such a program exists.
Maybe you can use SQL Server DTS or SQL Server Transformation Services to download your database into a .mdb format.
|||Try to use this.http://www.data-conversions.net/products.php?prod_num=1&&dest=MENU&&ID=100|||
I was having the same issue and followed these steps...
1. In your ODBC connections add a SQL server connection to your current SQL server and database.
2. Create a new Access Database
3. Import from ODBC source and select all tables.
The tables will import with a dbo_ prefix, but all of the structure and information will be there. It does not carry over the table relationships either.
Nick
