Re: Form not saving to table

Tech-Archive recommends: Fix windows errors by optimizing your registry

After upsizing your database, please make sure that your valdiation rules are
working properly and that autonumber fields are working as expected otherwise
nothing gets saved.

Please also note that if you do not provide adequate data checks on Acess
Form, Access will simply send your data as it is to the server and the server
might simply ignore your data if that data is not covering all the necessary
fields. This is because SQl Server enforces its own validation rules.

Please also make sure that your Access Form (and the table on it) are
updateable.

Although I am new to Sql Server territory, I think the above will help you.

Best luck.

--
Message posted via http://www.accessmonster.com
.

Relevant Pages

  • Re: Form not saving to table
    ... Francis via AccessMonster.com wrote: ... working properly and that autonumber fields are working as expected otherwise ... Please also make sure that your Access Form are ... Although I am new to Sql Server territory, I think the above will help you. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Use Unique or Bigint for ID field?
    ... I am a fan of using autonumber fields also, ... Computer Education Services Corporation, Charlotte, NC ... I support the Professional Association for SQL Server ... is there any reason for choosing a unique field over a ...
    (microsoft.public.sqlserver.server)
  • Upsizing replica
    ... We have a tables database in 2002 and we want to upsize it to SQL Server ... I ran an unreplicate add-in before uploading it and it uploaded just ... autonumber fields and I cannot set them to Identity fields on SQL Server. ...
    (microsoft.public.access.replication)