473,320 Members | 1,535 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

update questions

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
Nov 20 '05 #1
2 967
Fay Yocum wrote:
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. 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? Not if your application demands it.
2. If the answer to #1 is no what is the best approach to achieving
that functionality? Once you have made your changes, simply call the DataAdapter.Update command

Regards - OHM#

Thank you for helping the beginner.

Fay


Regards - OHM# On**********@BTInternet.com
Nov 20 '05 #2
Fay Yocum wrote:
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. 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? Not if your application demands it.
2. If the answer to #1 is no what is the best approach to achieving
that functionality? Once you have made your changes, simply call the DataAdapter.Update command

Regards - OHM#

Thank you for helping the beginner.

Fay


Regards - OHM# On**********@BTInternet.com
Nov 20 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

17
by: kalamos | last post by:
This statement fails update ded_temp a set a.balance = (select sum(b.ln_amt) from ded_temp b where a.cust_no = b.cust_no and a.ded_type_cd = b.ded_type_cd and a.chk_no = b.chk_no group by...
27
by: VK | last post by:
<http://www.jibbering.com/faq/#FAQ3_2> The parts where update, replacement or add-on is needed are in <update> tag. 3.2 What online resources are available? Javascript FAQ sites, please...
4
by: The Spoon | last post by:
I am looking for functions that can be used to automatically update the system date and time on an NT based system, resulting from manually entered date and time values input by an operator via a...
4
by: Nick Barr | last post by:
Hi, I am trying to gather stats about how many times a resource in our web app is viewed, i.e. just a COUNT. There are potentially millions of resources within the system. I thought of two...
5
by: Stephen Plotnick | last post by:
I'm very new to VB.NET 2003 Here is what I have accomplished: MainSelectForm - Selects an item In a public class I pass a DataViewRow to ItemInformation1 Form ItemInformation2 Form
12
by: si_owen | last post by:
Hi all, I have a SQL query that worked fine in my project until it came to testing. I found that the NvarChar fields I have wont accept the use of an ' My code and query is here does anyone...
2
by: rn5a | last post by:
When a DataGrid is in the editable mode, users can change the quantity of the items that are currently in his shopping cart by entering a new quantity in a TextBox. After changing the quantity, a...
0
by: Cindy Huyser | last post by:
I have an Access 2000 database behind a threaded Java application that that can have have concurrent access to the same table (but not the same record). The database is set up for shared access...
2
by: sirdavethebrave | last post by:
Hi guys - I have written a form, and a stored procedure to update the said form. It really is as simple as that. A user can go into the form, update some fields and hit the update button to...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.