Increase max size of integer

[Scott]

I am trying to increase the max size of the integer box after creating a web
site with the Database Website Wizard.

I have the wizard create a ms access database.
I set up a Primary Key for Account Numbers with integer and text box.

After creating the site I change to sort the order by account number which
is fine.
But after increasing the -i maxsize="5" and getting the field larger then 5.
When I go to add new account and type in any number larger then 5 digit's and
try to save it. It comes back with Cannot save value to database field.

Is there any editing I can do to any of the files to accept these changes?

Thank You,

 

[Kevin Spencer]

Could be a caching issue. Try emptying your browser cache.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Ambiguity has a certain quality to it.

 

[Stefan B Rusynko]

Did you limit the field size in Access to 5?
An Integer field in Access Stores numbers from –32,768 to 32,767 (no fractions)
For larger values set it to Long Integer



|I am trying to increase the max size of the integer box after creating a web
| site with the Database Website Wizard.
|
| I have the wizard create a ms access database.
| I set up a Primary Key for Account Numbers with integer and text box.
|
| After creating the site I change to sort the order by account number which
| is fine.
| But after increasing the -i maxsize="5" and getting the field larger then 5.
| When I go to add new account and type in any number larger then 5 digit's and
| try to save it. It comes back with Cannot save value to database field.
|
| Is there any editing I can do to any of the files to accept these changes?
|
| Thank You,
|
|