-
Access truncating fields from SQL Server backend
I have an access front-end I am running against a SQL- Server 2000 back-end database. The problem I am having is with two fields which I called user_id and Job_user_id which were defined as nvarchar (7). I now have user id's that are of length 8. I thought just going to the table defintions and increasing the length to 10 on the SQL Server will take care of it but I am still having id's that are 8 characters in length being trancated to 7 in the VBA client causing some of my joins to fail. For instance
Private Sub lstUnassigned_DblClick(Cancel As Integer)
MsgBox Me.cmbJOB_USER_ID
Me.cmbJOB_USER_ID = Me.lstUnassigned
End Sub
The MsgBox shows the Me.lstUnassigned trucated to 7 characters instead of 8 that is in the SQL Server database and so the Select statement in the object to fail.
I have also checked all my stored procedures and made sure that any user_id references have been increased to 10. I just cannot make the client stop truncating the JOB_USER_ID/user_id fields. Any ideas? Thanks, SKN.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|