how do I commit changes in msaccess

[Guest]

After making changes to records in an MS Access table (not programatically,
rather graphically using the MS Access GUI), I want to "commit" the changes.
I'm successfully reading data in the table I made changes to using Perl w/
Win32::ODBC. But the only way I can see the changes is if I close the table
(in MSAccess), then rerun the perl script. I was hoping there would be a
"commit" button somewhere that I could use.

 

[Guest]

If you are using an Access form to make the changes, the changes made apply
to the form's recordset and are not applied to the underlying table until
either the form is closed or requeried.

 

[Van T. Dinh]

If you simply use the DatasheetView of the Table to enter data in the Table,
you can use the shortcut key Shift + Enter to save the Record into the
Table.

Alternatively, you can use the Menu command Records / Save (which can be
accessed using Alt / R / O). In addition, you can simply move the focus to
another the row and the previously-focused row will be automatically
updated.

 

[Guest]

If you allow users to enter data in a datasheet view, you may as well use
Excel.

 

[Van T. Dinh]

Of course ...

However, from what Dave Gauthier wrote, he uses Perl w/ Win32::ODBC and I
think he is more interested in *testing* his Perl programming. My feeling
is that Dave only uses JET to store data, not Access as the primary
graphical user interface!