Thanks, Mike.

You must have been posting at the same time as I was replying to Raj.

What you suggested has done the trick, and I just need to cope with the...

Thanks for the prompt reply, Raj.

I'm not sure how I would "put query without that table".

I have created an Access "Report" that has my "View" as...

Thanks Jack, I just needed someone to tell me (I hadn't managed to read it anywhere) that Windows Authentication would not work without a Domain. What I had read was...

Thanks for the replies.

I'm not sure whether or not I'm using ODBC to connect from my remote PC; how would I tell?

I have been into a couple of the SQL...

Thanks for the prompt reply.

When in the Access Project on my "development" laptop that also hosts the SQL Server database, Access Options - Server - Connection brings up the "Data...

I stumbled on this article and thread as I searched for help with allowing "remote" users to connect to a SQL Server 2005 Express database. Front-end is an Access "project"...