Yes, it is easy using blueshell Data Guy! As I wrote in www.blueshell.com/forum?display=_632103593259218750 (MSDE=MS SQL Server - Use "File→New→OLE DB Connection"), *.MDF files aren't database files like *.MDB but files of MS SQL Server. You can't convert the files itself, but you can transfer each of the tables of your *.MDF to a new Jet/Access DB (*.MDB).
Act like this:
- Create and open a new Jet database
Select File→New→File Database... and specify a filename and filetype.
- Open your SQL Server database
- Start blueshell Data Guy
- Select File→New→OLE DB Connection, the Data Link Properties dialog appears.
- Select "Microsoft OLE DB Provider for SQL Server" and press Next.
- Enter the info for your connection and press Test Connection.
- When tested successfully, finally press OK.
- The connection is opened and you can now select your table from the tree view of the Connections window.
- Export your table to the Jet database
- Define your source recordset
Open a table from your SQL Server connection.
- Start the export
Select Export from the Table menu or press the
button from the toolbar.
- Choose the destination
Simply click the Jet connection of the tree view.
- Press Start to start the export
- Edit the details of the export process
Fine-tune the structure of the new table and specify which source fields will go to which destination fields.
- Do the transfer
Press the OK button. Watch the progress bar. You may interrupt the process by pressing the Pause button. You may abort the process by pressing the Stop button. You may specify error actions when an error occurs. You may even watch the source and destination (or any other) table during the transfer.
- Decide whether to commit or to rollback
Finally you may commit the whole transaction or you may rollback it.
If you have any further question, please don’t hesitate to contact me again.
Best regards,
Harry