I'd like to add an MS Access database as a linked server for SQL Server 2008, but I'm struggling. The Access database is being held on a separate server, and has an associated workgroup. I've got this far ...
... but am not sure what my data source should be? The connection string would use in PHP is this:
Driver={Microsoft Access Driver (*.mdb)};
dbq=\\\\servername\\Data$\\path\\to\\my\\database.mdb;
systemdb=\\\\servername\\Data$\\path\\to\\my\\workgroup.mdw
Now, clearly the megaslashing needs to go, and the driver isn't needed (or is it?), so perhaps:
\\servername\Data$\path\to\my\database.mdb;systemdb=\\servername\Data$\path\to\my\workgroup.mdw
This isn't working. Soooo ... what do I do to make it work? Is it something that I have to add in the "security"? Say if my username is something like:
username: "user.name"
password: "password1"
Any help would be really, really, really appreciated 🙂