Re: Q: Named pipes and Windows (integrated) authentication

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Kevin McDonnell [MSFT] (kevmc_at_online.microsoft.com)
Date: 07/22/04 

Date: Thu, 22 Jul 2004 00:22:00 GMT

Hi Lou,
   I'm not an expert in Access. This is a SQL Connectivity Discussion
list. The problem you're describing is not Connectivity related, rather,
how to do this from MS Access GUI.

   In MS Access 2003 there is a Wizard to create a New SQL Database with
adp Projects. I'm not sure this wizard exists in earlier versions of MS
Access..

  I'd imagine if you can write a query in Access to create a database in
SQL while connected to master, this would work. Afterwards, you'd have to
link to the new database you've just created. This is why i suggested just
using OSQL to create the database first.

  
Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.

Relevant Pages

  • Re: Moving databases from SQL 7 to SQL 2000 - More Questions!
    ... Personally I feel using the copy DB wizard is more effort than just a backup ... Passwords Between SQL Servers ... Issues When a Database Is Moved Between SQL Servers ... for SQL Server ...
    (microsoft.public.sqlserver.setup)
  • Re: Using Database Results Wizard for dropdown
    ... Present SQL for the form (showing just the dropdown portion for GroupMix; ... > Is there a parameter you can add to the sql of the Database Results Wizard ...
    (microsoft.public.frontpage.programming)
  • RE: ODBC Imports of entire Database
    ... When I run the wizard it does not give me the option to copy the entire ... connect to the other database. ... Start the SQL Server Import and Export Wizard ... SSIS package so that we can maintain the SQL base and not have to recreate ...
    (microsoft.public.sqlserver.dts)
  • RE: Trouble with SQL Adapter Metadata Wizard in BizTalk Server 2006
    ... However when I type the SQL Server name ... it works fine and then I can select the default database. ... I'm getting in trouble with SQL Adapter Metadata Wizard in BizTalk 2006. ...
    (microsoft.public.biztalk.general)
  • Problems with sortable tables and DRW
    ... This tutorial uses Frontpage's Database Results Wizard. ... The page is saved as an Active Server Page because FrontPage ... When you specify options, FrontPage writes the SQL ...
    (microsoft.public.frontpage.client)