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

L

Lou Arnold

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to manage SQL Server authentication in Microsoft Access 2007 0
Why can't Access create SQL Server ADP database while Osql Can?? 1
Access 2007 Application for Reports Only – SQL Server Security 3
Manual prompt needed for SQL database Authentication 0
How to manage SQL Server authentication in Access2007 1
Picking authentication when linking Access to SQL Server 1
Can't create ADP database on MSDE using MS Access 15
Need help: Can't create ADP Database in MSDE from MS Access 0

Top