Form not saving to table

  • Thread starter Thread starter familyhall
  • Start date Start date
F

familyhall

I have an access dbs that works fine while in access. I have to upsize
the dbs to sql in order for my IT department to place it on networked
computers throughout the plant.

the problem, is that when I do the upsize, everything appears fine - I
get no errors.

when I open the form, enter data and then save and exit - none of the
information was saved to the sql tables.

I use the access as a front end and the tables are stored in sql.

tables have primary key.

permission has been granted to users and administration.

not sure where else to look.

I am a newbie to sql - please help.
 
« enter data and then SAVE and exit »

How are you doing your saving. Usually, with bound forms, this is done
automatically by Access, so I suppose that maybe you must use some special
method of saving data in your code.

Also, it's not clear from your message if you have upsized to an ADP file or
to a MDB file with linked tables.

Finally, it's not a necessity to upsize your dbs to SQL in order to place it
on a LAN (but it's not a bad idea, either).
 
Sylvain, - I hope this response is clearer.

I have a form that when closed, should save the data entered into the
sql table.

If I run the database is Access - everything works fine. When I run
the front access as the front end - the form does not automatically
save.

file was upsized to link the tables .

Excuse me but I am really new to this. I don't enough to know what
went wrong.

I am told, because our plant uses thin clients, my IT dept wants a
runtime version of access with the sql tables to hold the data.
 
screw upsizing to link tables.

either

a) use ADP
b) start over from scratch

don't you wish your database was SIMPLE like me?
don't you wish your frontend WORKED Like me?

dont you?

dont you?

Microsoft will come out with an ADP SQL 2005 patch soon; as it is; ADP
against SQL 2005 is probably the most pleasant experience i've ever had.
 
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.
 
Francis said:
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.
Click to expand...
 
Back
Top