I have a problem with a button in MS Access requesting an SQL View that does not have a foreign key.
My question is VERY similar to the question found here: Error accessing MS & ODBC - the call failed. Invalid character value for cast specification (# 0) " - This seems to be my exact problem, but I'm not sure how to solve it. Here are a few more details. First, the exact error message:
ODBC--call failed.
[Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification (#0)
Here where I am different. I have a button in MS Access that does the following:
Private Sub btnMachineCutSheet_Click()
Dim stDocName As String
stDocName = "qryCutSheetByMachines"
DoCmd.OpenQuery stDocName, acNormal, acEdit
End Sub
The query you see there (qryCutSheetByMachines) is a rather long query, but I narrowed the problem down to one line. Here's the request:
SELECT
vwCutSheet.Network,
vwCutSheet.NetworkSpeed,
vwCutSheet.Duplex
FROM vwCutSheet
INNER JOIN local_tblCreateCutSheet
ON vwCutSheet.EquipmentID = local_tblCreateCutSheet.EquipmentID;
, / MS SQL 2008
, , vwCutSheet.NetworkSpeed. , .
, JOIN, . , , . ( ) , (vwCutSheet) PK ( ?). vwCutSheet.EquipmentID PK, - , EquipmentID .
, , - . "" ( MS Access), , Access "", , , varchar ( 5). , Access , ( 10, 100, 1000 10000).
, , ! Hah... , , , .
... , . , , .
!
EDIT: :
, , varchar (5). , varchar (5), , "" 10, 100, 1000, 10000 Auto.
, , null.