Re: Answer: Access creates ADP database in MSDE only with SQL Server Authentication mode

From: Lou Arnold (Lou_Arnold_at_nospam.com)
Date: 07/29/04 

Date: Thu, 29 Jul 2004 04:51:32 GMT

Since you seem keen to help, lets make this easier.

I can be reached at "louarnoldottawa at yahoo dot ca".

Lou.

On Thu, 29 Jul 2004 13:22:44 +1000, "Van T. Dinh"
<VanThien.Dinh@discussions.microsoft.com> wrote:

>Not too sure about that, Lou.
>
>OK, I tested in SQL Server, not MSDE, but new ADP with *new* database on SQL
>Server can be created using Windows authetication only.
>
>AFAIK, SQL Server 2K & MSDE 2K should behave the same for security, in
>theory.
>
>Sorry, I don't have an MSDE 2K installed to test. However, if you want, you
>should set your Windows logon as the SQL Server Administrator on the MSDE,
>change the MSDE to Windows authetication only and then test see if you can
>create a new database via new ADP.
>
>--
>HTH
>Van T. Dinh
>MVP (Access)
>
>
>
>
>
>"Lou Arnold" <Lou_Arnold@nospam.com> wrote in message
>news:410737a7.8018259@nntp.flfrd.phub.net.cable.rogers.com...
>> I have now confirmed that MS Access will create and ADP database in
>> MSDE2000A only when the server is placed in MIxed mode security when
>> the SA account and password are used. It will not do so in Windows
>> Authentication mode.
>>
>> Thanks to all those who helped.
>>
>> Lou Arnold
>
>

Relevant Pages

  • Re: Help with Master/Detail UI in ADPs
    ... No, MSDE is not limited to 5 concurrent users, it is limited to 5 concurrent ... The users whose connection to the server is idle at any moment don't count. ... and from the local temp table to the Detail table on the server for rows ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Unable to connect to SQL 2000 engine on other machine from SSM
    ... how SQLServer-Browser resolves portnumber of MSDE named instance. ... Windows 2003 Server ships with SSEE preinstalled (for ... port information to your client. ...
    (microsoft.public.sqlserver.connect)
  • Re: Unable to connect to SQL 2000 engine on other machine from SSM
    ... Upgrade MSDE to SP4: not ok. ... Windows 2003 Server ships with SSEE preinstalled (for ... > port information to your client. ...
    (microsoft.public.sqlserver.connect)
  • Re: MSDE and IIS - Web Hosting
    ... sites getting over 3M hits per month and MOST of those hits were on ... when going to Windows 2003 Server and running very SMALL sites using ... coding for MSDE instead of Access because it's really our only option. ... but not as well as SQL Server who knows. ...
    (microsoft.public.sqlserver.msde)
  • Re: SBS 2003 and Great Plains problem
    ... SQL Server VSS Writer ... restarted ALL sql related services and then ran a backup ... If you think installing patches and security updates is expensive, ... They will be using MSDE ...
    (microsoft.public.windows.server.sbs)