I have created a .ASP database search (the database is Access .mdb). On my local machine and local testing server it works fine, I created a Custom Connection String pointing to the database on the remote testing server and it is ok.

I have now uploaded it to our Intranet site which requires secure logon (username and password) I have these, and I have created DSN and System DSN connections on the Server pointing to the database file.

However, when I click "test" in the Custom Connection String box I get the following error message - "HTTP Error 401 - unauthorized"

I am having trouble working out what could be stopping it from connecting, but Im guessing its something to do with security.

Any Ideas?

sounds like it's to do with permissions on the access file itself. You could try adding 'everyone' to the folder's security (right click on the file and select 'properties' then select the security tab', and give them full access. You should only need iusr_machinename in the permissions list, but I normally try with 'everyone' in the first instance to rule out file level permissions problems.

You could also check IIS to see what authentication methods are required for the site.