SQL Number Change

[TechnicalScott]

Hi all,

Bit of an odd one for you all....had a normal SQL database which is read by an MSAccess frontend. I have a feild which is NVARCHAR in type and it had the following in it :

3054515617

I've just had a look and it's changed it to :

3.05452e+009

It shows this in both SQL and MSAccess.
Any suggestions why this has happened and how i can get them all to go back to normal (if possible).

Cheers

Scott

 

[SimeonJ]

I'm having the same problem, I've been researching this for a while now without any luck. I'll be sure to let you know if i figure out a solution.