I have a form created with Access'97 and VBA. It's been in production since 3 yrs ago.
Currently I need to do a little enhancement that is: In one of the textbox for credit course, the datatype that is used to be set for an integer in SQL is now need to be changed to float since user want to be able to enter 1.5 credit.
I've changed the datatype into float by went into the SQL Server ( enterprise manager ), saved it.
Then I re-linked the associated views and the tables from Access,changed the format to format=fixed and decimal=2, changed all the necessary variables to double.
When I tested the application, I enter 1.5 in that textbox and saved it, unfortunately it is saved into 1.00 instead of 1.50 and I got a message saying:
"The microsoft jet database engine stopped the process because you and another user are attempting to change the same data at the same time"
I know for sure there is no other user? and why the number is rounded up???????? Anyone can help me please? I've been trying to solve this problem for 2 weeks unsuccessful, Thanks! Alec
Currently I need to do a little enhancement that is: In one of the textbox for credit course, the datatype that is used to be set for an integer in SQL is now need to be changed to float since user want to be able to enter 1.5 credit.
I've changed the datatype into float by went into the SQL Server ( enterprise manager ), saved it.
Then I re-linked the associated views and the tables from Access,changed the format to format=fixed and decimal=2, changed all the necessary variables to double.
When I tested the application, I enter 1.5 in that textbox and saved it, unfortunately it is saved into 1.00 instead of 1.50 and I got a message saying:
"The microsoft jet database engine stopped the process because you and another user are attempting to change the same data at the same time"
I know for sure there is no other user? and why the number is rounded up???????? Anyone can help me please? I've been trying to solve this problem for 2 weeks unsuccessful, Thanks! Alec