How do you access MS Access in a different domain?
March 15, 2007 7:50 AM Subscribe
I'm trying to get my head around some Microsoft Access security issues, and could use some help.
posted by chill to Computers & Internet (4 answers total)
My company has a website (on IIS6). A portion of that website (written in ASP), pulls data from a Microsoft Access database, located on the same server.
The ASP web site is now moving to a data centre, to a server in a different Active Directory domain (no trust yet exists between the two domains), but the Access database has to stay where it is (other applications reference it).
Previously, the "anonymous access" internet account had permission to read/write to the Microsoft Access database. But now the "anonymous access" account is in a different AD domain, and as such can't be granted read/write access to the Access file (unless I'm very much mistaken).
So, my question is - what is the quickest/simplest way to grant the ASP application access to the Microsoft Access file? Is there someway I can specify the Active Directory account to authenticate as in the connection string or something?