UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Value column on Access table not populated    
 
   
marie777
post Aug 11 2004, 06:17 AM
Post #1

New Member
Posts: 5
Hi,

For some user profiles, an Access (2000) database reading from a text file failes to populate any column that has a numerical value.
Strangely though, if the profile (s) is (are) deleted, then re-created, the problem goes away but only temporarily - until the PC is shut down.
It definitely looks like a setting somewhere, but where?

Please help, someone.
Thanks.
Go to the top of the page
 
+
JayNoelOlimpo
post Aug 11 2004, 06:44 AM
Post #2

UtterAccess VIP
Posts: 7,990
From: Philippines
Hi Again ...

Have you tried granite consulting .

and check your codes. to convert a text field to numeric -- Val(TextfieldewithNumericValue) ...
Go to the top of the page
 
+
marie777
post Aug 12 2004, 04:40 AM
Post #3

New Member
Posts: 5
Hi again ...

The codes are correct. I don't really think the problem is with the codes though but with a setting somewhere in the profile for those users affected on those PCs. The same user logs on to another PC and there is no problem. When the profile is deleted and re-created the problem goes away but only until the PC is shutdown.

We recently upgraded to Access 2000 (SR1/ SP3) from Access 97 which had absolutely no issues with this database.

Any more suggestions?
Go to the top of the page
 
+
« Next Oldest · Access Tables + Relationships · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 18th June 2013 - 01:26 AM