Re: Why can't Access create a database in MSDE?

From: Mary Chipman (mchip_at_online.microsoft.com)
Date: 06/24/04 

Date: Thu, 24 Jun 2004 10:47:30 -0700

I don't feel qualified to address your networking and connectivity
issues, but I do feel qualified to recommend that you NOT use Access
as a design tool for a SQL Server database. Instead, use the client
tools (Enterprise Manager, Query Analyzer). Access does not have the
required functionality to create a robust and secure SQL Server
database. You also won't have to troubleshoot all the flaky things it
does and doesn't do.

--Mary

On Thu, 24 Jun 2004 09:27:02 -0700, "Mark Ferguson"
<MarkFerguson@discussions.microsoft.com> wrote:

>Why isn't a database created on the MSDE??
>
>Network: Two Win2K Pro machines connected as peers. (No domains.) MS
>Access is on X, MSDE2000A is on H.
>
>MS Access is run under: Windows Administrator.
>
>MSDE is set for Windows Authentication only.
>
>On using the Microsoft SQL Server Database Wizard to create an Access
>project, I don't specify a user ID or password.
>
>After the wizard says it has the info it needs, it closes and a
>progress bar appears for a only a split second as the wizard tries to
>create the database. Indications are that the connections to the MSDE
>was dropped during creation. The result is that no database is created
>in the MSDE.
>
>Does Windows Authentication work on a peer-to-peer network??
>
>Shouldn't the X Administrator be able to create a database on the H
>MSDE??

Relevant Pages

  • Re: Q: Named pipes and Windows (integrated) authentication
    ... This is a SQL Connectivity Discussion ... I'm not sure this wizard exists in earlier versions of MS ... > I'd imagine if you can write a query in Access to create a database in ...
    (microsoft.public.sqlserver.connect)
  • Re: Q: Named pipes and Windows (integrated) authentication
    ... This is a SQL Connectivity Discussion ... I'm not sure this wizard exists in earlier versions of MS ... I'd imagine if you can write a query in Access to create a database in ...
    (microsoft.public.sqlserver.connect)
  • Re: DB Splitter err
    ... Thank you for using the Microsoft Access Newsgroups. ... Sounds like the database contains some corruption. ... Can't locate the article at present, but it was something like the wizard ... Could be that security permissions are interferring. ...
    (microsoft.public.access.security)
  • Re: frontpage database edit
    ... Then you will have go thru the Wizard, ... FrontPage Resources, WebCircle, MS KB Quick Links, etc. ... >>>I just want the page where you can make change to the database. ... >>>> Important The following procedures will not work on a Web site located on ...
    (microsoft.public.frontpage.client)
  • Re: frontpage database edit
    ... otherwise you have to go through the Wizard. ... FrontPage Resources, WebCircle, MS KB Quick Links, etc. ... >I just want the page where you can make change to the database. ... >> Important The following procedures will not work on a Web site located on ...
    (microsoft.public.frontpage.client)