I have read all the documentation etc... but must be missing something. I have upsized the Access DB successfully, but when I do I have to specify the SQL Server. The new MSSQL DB that I create needs to moved to a hosting service. How do I upsize the DB and move from the server Icreated it on? Is it the .mdf file, just transfer it then create a DSN connection? Cna anyone better explain this to me?

Michael Rudge

You need to connect to the Server with the Client Network Utility then register the remote SQL Server in Enterprise Manager then use Import/Export to copy the database objects from your local SQL Server to your SQL Server at the host.

Take a look at this post:
dwmxextensions.com/forum//topic.asp?TOPIC_ID=2567

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo