Answer: Access creates DB in MSDE in SQL Server Authentication mod -- sql server msde

Lou Arnold
7/27/2004 10:09:02 PM

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

T. W.
9/14/2004 12:42:06 PM

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?

[quoted text, click to view]

sql server msde : Answer: Access creates DB in MSDE in SQL Server Authentication mod