dsoderstrom
asked on
Leading plus sign in text field getting dropped
I have an Access 2010 database that links to a table in SQL server 2008 R2 using ODBC.
One of the fields in the SQL table has a field type of varchar(30).
Some of the records have data in this field that starts with a plus sign (ex. +354384).
When I link to the SQL table in Access, the plus sign is sometimes getting dropped. For example, +354384 shows up as 354384. On other records, the plus sign shows up as it should.
When I query the same data in SQL server, the plus sign shows up for all records.
Any ideas on what is going on here?
One of the fields in the SQL table has a field type of varchar(30).
Some of the records have data in this field that starts with a plus sign (ex. +354384).
When I link to the SQL table in Access, the plus sign is sometimes getting dropped. For example, +354384 shows up as 354384. On other records, the plus sign shows up as it should.
When I query the same data in SQL server, the plus sign shows up for all records.
Any ideas on what is going on here?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
When linking to the SQL table, the varchar fields become text type fields in the Access table, which is what they should be. When I open the linked table in Access I see the plus sign at the beginning of the data in the field. But, when I do a select query on the table to display the data, the plus sign gets dropped.
However, if I run a "Make Table" query in Access to read the data from the linked table and write it to a new Access table and then do a select query on the new Access table the plus sign does not get dropped.
Very strange. Anyway, knowing that and having spent way to much time on this already I can design a workaround to accomplish what I need to do.
Thank you both for contributing.
However, if I run a "Make Table" query in Access to read the data from the linked table and write it to a new Access table and then do a select query on the new Access table the plus sign does not get dropped.
Very strange. Anyway, knowing that and having spent way to much time on this already I can design a workaround to accomplish what I need to do.
Thank you both for contributing.
ASKER