Originally Posted by Nephron
GuitarPaul, please careful with your db access messing around and you might put your db in a state where you wont be able to access it. SQL server is not like access MDB, and especially sql express is so messy with some protocols and funky security restrictions.

Nephron, SQL Express is exactly like SQL Server. If you run the SQL Server Configuration Manager Tool you will be able to access all of the configuration settings. See the following screen shots.

www.lakepiso.com/servers.jpg

www.lakepiso.com/protocols.jpg

As you can see I am running 4 instances of SQL Server including 2005 and 2008

I am confused as to why AC will not install the DATABASE on to an existing server but rather, will install a new SQL Express Instance. SQL Express does have it's limitations.

"The illiterate of the 21st century will not be those who cannot read and write, but those who cannot learn, unlearn, and relearn." ~ Alvin Toffler