Hack I use the same character with SQL Server and Access if I am doing the Connection from VB and it works on boths. If using Access exclusively (the code is written in Access) then the character makes a differance.