Grasshopper - Hi. Have you implemented Access 2010 ADP to SQL Server 2008 r2 Express? I am trying to do the same thing but don't seem to be able to connect client PC to server. When I try to create a new AGP project and make it create new DB on SQL Server I get "...Server Error 262: CREATE DATABASE permission denied in database 'master'...).

On the server side:

- installed all updates and patches

- enabled TSPIP

- Set Server Browser to 'Automatic'

- I have created a user/password and attached it to 'master'

- Security is set to mixed SQL Server / Windows Auth. mode

- no firewall running

- shared directory where local instance is installed ( I can see the directory on the service in file manager on the client)

On my client, via local LAN

- no firewall

- Try to create AGP in Access with choosing to create new database

- enter server and user/login info

- get the error message

Any help would be greatly appreciated.