Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-08-19 : 18:29:12
|
Dave writes "I'm having a problem with an insert command that is to insert a currency value into a Access 97 table. The offending code is:
sql = sql & "'" & FormatCurrency(rstProductInfo("currCost")) & "') "
I know in and of its self this should not be a problem, in fact this has worked in the past. The problem I suspect is that the database was originally designed in access 2000, and then converted to access 97 such that can be supported by the server its on.
Does the problem then lie in my syntax, or is it a problem with the data type conversion?
I appreciate your thoughts,
Dave
Running NT 4.0 Svpk 6
Access Driver version 3.51.102900 10/29/97"
|
|
|
|
|
|
Currency Data Type in Access 2k,97