Re: updating and downdating

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: William Ryan eMVP (dotnetguru_at_comcast.nospam.net)
Date: 05/10/04


Date: Sun, 9 May 2004 23:56:16 -0400

Delete the access files and wipe their remains from the registry.

SQL Server and replication would lend itself really really well to this
scenario and the Publisher/Subscriber model is made JUST for this.

You can do it with Access, but it'll take some fancy footwork that I don't
think is worht it. Remember that DataSets are local 'databases' themselves
so you could just use Access on the server, load yoru datasets from it, and
periodically send the updates back and refresh them. On a scale of 1 to 10
it's probably a 3. but Access will corrupt, will have security problems and
will be doing a job it wasn't really intended to do.

I'll gladly walk you through either process, just let me know.

Cheers,

Bill

www.devbuzz.com
www.knowdotnet.com
"Neil" <neilsteventon@blueyonder.co.uk> wrote in message
news:mVxnc.18698$Us1.13826@pathologist.blueyonder.net...
> I was wondering if anybody could shed some light on this scenario, maybe
> there is white paper somewhere ?
>
> I have a vb.net app that runs on a few machines storing data in a local
> access db, but if they are connected to web I want them to be able to
upload
> there data and pull down any updates that they do. whats the best way of
> going about this?
>
> Thanks
>
> Neil
>
>



Relevant Pages

  • Re: update and downdate ?
    ... SQL Server and replication would lend itself really really well to this ... scenario and the Publisher/Subscriber model is made JUST for this. ... periodically send the updates back and refresh them. ... > I have a vb.net app that runs on a few machines storing data in a local ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Tracing sql server user logins
    ... GroupName sysname NULL, ... FAQ from Neil & others at: http://www.sqlserverfaq.com ... SQL Server does not audit by ... >Failure causes only failed login attempts to be audited. ...
    (microsoft.public.sqlserver.security)
  • Any security whole accessing sql database with anonymous account
    ... are the exactly security holes and the problem i will face in this scenario. ... break down my sql server database. ... I will create a windows nt user account with no previliges called JOHN ...
    (microsoft.public.inetserver.iis.security)
  • Re: General database safety question
    ... preventive measures to take for the database of our product. ... Scenario 1: Laptop on which Sql Server is installed in stolen. ... Look in to PKI strategies. ...
    (microsoft.public.sqlserver.server)
  • Re: sql server events on data create
    ... NS ships with "Event Submission Stored Procedures" to support this scenario. ... >> I knew of the ability to let my program poll the sql server but I´m ... >> A little bit like exchange and outlook. ...
    (microsoft.public.sqlserver.programming)