SQL Server Trusted Connections with FULL STOP in User Name
Posted on 2006-07-05
Have you come accross a problem, and more to the point resolved a problem, with Access 2000 trying to link the Microsoft SQL Server 2000. We are using trusted connections and the user appears as DOMAINNAME\firstname.surname. When I try to connect to the table as the user it will either create the attached table but fail to open or it will fail to attach.
Option 1: I have tried connecting through the connection manager and this creates the attached table but fails to open it.
Option 2: I have tried using my standard code that I use to create the attached tables with the folowing options all to no avail.
I am 100 Percent convinced this is a problem with the FULL STOP and as you can see I have tried all combinations of using [ ] and "".
Just to confirm I need to have the table owned by the User not DBO
I need to have an attached table in MS Access 2000 to this table.