we write something in database table and close without saving and when we re-open the table, the data is there?

Question

we write something in database table and close without saving and when we re-open the table, the data is there, how it saves data automaticaly in database table?

Answer 1

Database, such as Access, automatically save any entry you type into your table. You don't have to do anything to enable it, it's just the nature of it.

Answer 2

There really is no single method or algorithm which will rectify this problem. The problem is compounded by the fact that you are having to deal with company names (proper nouns) so you cant do a word lookup in a dictionary to see if its a proper word or not. The weakest point of any system is the point of data entry, as thats the only point where a human being enters data into the system and thats where most of the mistakes happen. No amount of coding or logic can ever compensate for bad data entry. Perhaps you can do a grouping on the company name and store off the unique company names into another table. That table can have another field which will be empty by default. You can do some lookup or some processing to process each of the extracted company names to see if its valid or not and assign the proper company name for that value into the second field. eg. fld1 fld2 **** **** Wal-mart Walmart Inc Walmurt Walmart Inc. And then you can overwrite the company name field in the original table with fld2 from the temp table using fld1 as a lookup field. Not a very satisfactory solution , but I cant think of anything better

Answer 3

This depends on the specific Database Management Software your using. Many include a default that always "flushes the buffer" causing everything to be written to the DB before it is closed.



This is especially common in something like Microsoft Access 2002 where the record is written to the DB when you have made changes and then leave the record.

Answer 4

thats why it should be passward protected