update questions

  • Thread starter Thread starter Fay Yocum
  • Start date Start date
F

Fay Yocum

In Access any changes to data is immediately saved in the tables. I am
learning about vb.net. I have a couple of applications that I want to build
that are not designed to be accessed by more than one person. As I am going
through the various reading material I have learned that vb.net creates a
local snapshot of the Access table, holds that information in memory, and
then the updates are done by clicking a button.

Questions
1. Is there any reason in vb.net why I wouldn't want the Access like
functionality in the described situation?
2. If the answer to #1 is no what is the best approach to achieving that
functionality?

Thank you for helping the beginner.

Fay
 
Fay said:
In Access any changes to data is immediately saved in the tables. I am
learning about vb.net. I have a couple of applications that I want to
build that are not designed to be accessed by more than one person.
As I am going through the various reading material I have learned
that vb.net creates a local snapshot of the Access table, holds that
information in memory, and then the updates are done by clicking a
button.
Click to expand...
ADO.NET ( Part of the framework ) works in a disconnected mode.
One you run the select statements the connector, dataAdaptor fills
the designated DataSet or Table, you work on it and then send it back
to Access using update.

Questions
1. Is there any reason in vb.net why I wouldn't want the Access like
functionality in the described situation?
Click to expand...
Not if your application demands it.
2. If the answer to #1 is no what is the best approach to achieving
that functionality?
Click to expand...
Once you have made your changes, simply call the DataAdapter.Update command

Regards - OHM#


Thank you for helping the beginner.

Fay
Click to expand...

Regards - OHM# (e-mail address removed)
 
Back
Top