Re: Writing Data to Access Database on Network

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


I have tested on a network and it works fine, but here is the actual
problem.

I have a Shopping Cart application which uses a Access database.

If i run the app on a standalone system (eg Windows XP) and using another
app developed in C# insert some data into the Access database, i have to
select from a combobox "All Products" int the shopping Cart app, to refresh
the new added data, it shows up, without shutting down the Shopping Cart
app.

However if i use the Shopping Cart App on a network (keep it running) and
insert some data in the Access database using the C# app, the data gets
inserted without any problem into the Access database, but if i select "All
Products" the data is not refreshed, i have to shut down the Shopping cart
app on the network and restart it for the data to appear in the shopping
cart app on the network.

Is there any way i can refresh the data on a network app without shutting it
down. This is my clients requirement not mine, he does not want to shutdown
the shopping cart(s) on the the network.

TIA
Barry


"Alex Clark" <quanta@xxxxxxxxxxxxxxx> wrote in message
news:uknEjXCRJHA.4504@xxxxxxxxxxxxxxxxxxxxxxx
If you're using the ODBC connector there won't be any difference
code-wise, you'll just change the path in the ODBC connection properties
to point to the .mdb file on the network share instead of on a local
drive.

I would be wary of reading/writing to an MS Access database via a network
though. I've seen problems occur, particularly when concurrent writing
has taken place, which required the database to be repaired every other
day.


"Barry" <someone@xxxxxxxxxxxxx> wrote in message
news:uNKm1dARJHA.4824@xxxxxxxxxxxxxxxxxxxxxxx

Hi

Is the any difference in coding when it comes to standalone database and
the kept on a network?

TIA
Barry






.

Relevant Pages

  • File Comparisment
    ... I have a File (Access Database) on my Network, ... When my App Starts I would like it to check to ... make sure the Local Machine has the same file as on the network, ...
    (microsoft.public.dotnet.languages.vb)
  • Re: ODBC Connection with SQL Managed Provider
    ... One thing to remember is when running application from a network share, ... > So it was our intent to put a lot of the "forms" into the main app. ... the odbc manager is no quicker than the odbc. ... >>> authorizing the user against a table in the SQL server database. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: .NET new executable
    ... Since there is no network access avaialble, I want to send my app to each ... then you update the data into database. ... If all you are trying to do is send some data to your SQL server, ...
    (microsoft.public.dotnet.general)
  • Re: LISP for web
    ... Any large scale web app that is business critical is based on a few ... -> So you need at least two routers, two switches, two machines ... ... Load balancing is done based on content and on network traffic ...
    (comp.lang.lisp)
  • Re: Environment.CommandLine Security Exception
    ... installed on network drives and they typically don't ... require that users get into the details of security as ... believe an MS Office network install is a good example of ... >app from a *network* share. ...
    (microsoft.public.dotnet.security)