I am using MS Office 2007 on Windows 7, and I am developing a small database in MS Access.
I have created the form below to save data to the database.Â
Now the problem is when I press "save" button the form does not save the data to the database.
How can I do that?
Note: I want to save record to table1
Thanks.
This problem has occurred due to table problems as you did not define relationship among the tables. If you have done it properly, the next thing is that your primary key is not functioning properly or you didn’t define it. If you are using composite primary key, it is a possibility that it is not getting null value. Try to reduce the primary key to a single key. This method is done through a process called "normalization of tables" which reduces big tables to small tables. Check out the relationship. Or redefine your table as a final solution.
The possibility is the value you are passing from form doesn’t matches data type. Kindly also ensure the formats or any constraints you defined while defining the structure of your table.
