Dear all,
MS Access 2k, SQL2k
I have an access database that needs to pass values from an access table into a SQL2k table. The data is inserted into the SQL table using an ADO connection that fires a SQL SP with the data items passed as parameters.
My last couple of fields are set as decimal precision 18, scale 2 in Access, these are to go into a SQL field of decimal(18,2). When I try to run the code, it errors with an "Run-time error '3704': Operation is not allowed when the object is closed". If I change the access field type to integer, it all works fine.
How do Access and SQL treat decimals differently, is there an easy fix to my problem? (I need these to be decimal as its a monetary amount)
MS Access 2k, SQL2k
I have an access database that needs to pass values from an access table into a SQL2k table. The data is inserted into the SQL table using an ADO connection that fires a SQL SP with the data items passed as parameters.
My last couple of fields are set as decimal precision 18, scale 2 in Access, these are to go into a SQL field of decimal(18,2). When I try to run the code, it errors with an "Run-time error '3704': Operation is not allowed when the object is closed". If I change the access field type to integer, it all works fine.
How do Access and SQL treat decimals differently, is there an easy fix to my problem? (I need these to be decimal as its a monetary amount)
