I've confirmed that MS Access will create an ADP project in MSDE only if the server is set to Mixed (SQL Server and Windows) authentication mode. Trials in Windows Authentication mode failed. This is still hard to believe, I know, but its a reality.
To all those who tried to help, my sincere thanks.
Lou Arnold
Ottawa, Canada
Lou,
Did you have to create users in the SQL database itself so that Domain
Users could access the MSDE, and if so, with what tool did you use?
"Lou Arnold" <Lou_Arnold@.nospam.com> wrote in message
news:EB2211E6-F5BD-4DD8-AC32-65B7B0DC0ECA@.microsoft.com...
> I've confirmed that MS Access will create an ADP project in MSDE only if
> the server is set to Mixed (SQL Server and Windows) authentication mode.
> Trials in Windows Authentication mode failed. This is still hard to
> believe, I know, but its a reality.
> To all those who tried to help, my sincere thanks.
> --
> Lou Arnold
> Ottawa, Canada
