Re: Running a query on the Back End

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

From: Alex Dybenko (alex_at_PLEASE.cemi.NO.rssi.SPAM.ru)
Date: 03/04/05 

Date: Fri, 4 Mar 2005 18:29:35 +0300

Hi,
just make an access application, which runs on server and do following
tasks:
every 5 mins (1 hour) it checks to a value in a field "run import" of a
table "settings"
if it=true - is run all your import queries and then set flag back to false

so when some user need to run import - in just set this flag field to true

Also you can build the same on VB, and run it as a service on your server.
then you dont need to have a logged session runnig 

-- 
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com
"rgrantz" <r_grantz@hotmail.com> wrote in message 
news:38r1scF5qppiiU1@individual.net...
> Thanks for the reply.  Is there any kind of example you can give me as to
> how to do this?  All I need is for these tables in the Back End to be
> updated from SCO tables which would be linked to that same Back End.  What
> sort of application would I make, and what do you mean by flag?
>
>
> Thanks again
>
>
> "Alex Dybenko" <alex@PLEASE.cemi.NO.rssi.SPAM.ru> wrote in message
> news:%23JDqtdJIFHA.2744@tk2msftngp13.phx.gbl...
>> Hi,
>> as i understand you - this will not work as you expect. even if BE is
>> located on a server, Jet is still running on a local PC, so in order to
>> connect to SCO tables it need ODBC drives on local PC also
>>
>> solution can be  - is to build a separate application to be run to 
>> server,
>> which will do import, and which will be intiated from any frontent by 
>> some
>> flag in BE table for example
>>
>> HTH
>> -- 
>> Alex Dybenko (MVP)
>> http://Alex.Dybenko.com
>> http://www.PointLtd.com
>>
>>
>>
>> "rgrantz" <rgrantz@hotmail.com> wrote in message
>> news:38q12hF5o79rdU1@individual.net...
>> > I've searched the newsgroups about this, and any posts regarding my
>> > particular situation are from 2000 or earlier, so I'm hoping a
> resolution
>> > has come up since then.
>> >
>> > I have a Back End that is used by several users' identical Front Ends.
>> > All Front Ends ONLY use the Back End Access tables.  However, I want to
>> > update and append these Back End tables using linked ProvideX tables
> from
>> > a separate SCO ERP table set.  So, I want to Link the SCO tables to the
>> > Back End, and just activate/run the BackEnd's update/append queries to
>> > append the Access tables in the Back End which the Front Ends use.  I
> have
>> > 2 reasons for doing this:
>> >
>> > - only having to pay for one set of ODBC drivers for the PC/server 
>> > where
>> > the BackEnd resides
>> > - reducing network traffic and Server lag, since the queries on the 
>> > Back
>> > End would fill Access Tables only with usable data, whereas querying 
>> > the
>> > SCO tables per use per FrontEnd user take about 4 minutes for every
>> > Form/Data entry action.  For example, the forms and queries on the 
>> > Front
>> > end never need to see records from before 2003, whereas the SCO tables
>> > themselves have records dating back to 1999.  Using update/append
> queries
>> > and linking FrontEnd forms/queries to the Access Tables rather than the
>> > SCO tables reduces the records/filters from about 600,000 records to
>> > 30,000.
>> >
>> > Is there any way to just run a BackEnd query using a FrontEnd button
> click
>> > event or something?  Again, the query would ONLY update/append the Back
>> > End tables from SCO tables linked to that same Back End.  If anyone
> knows
>> > the code or whatever that's needed, let's assume a sample SCO Linked
> table
>> > is named Order_Status, the Access Back End table to be updated/appended
> is
>> > OrderStatusAcc, and the path to the Back End is
>> > //ServerRoot/C:/BackEnd/AccessBackEnd.mdb.
>> >
>> > Thanks for any help here, it is much appreciated.
>> >
>>
>>
>
>

Relevant Pages

  • Re: Does samba 3.0.14Aa on OS 5.0.6 work with ldapsam backend on another LDAP server?
    ... used 3.0.9 on SCO 5.0.6 for quite some time after suffering problems I ... a RedHat4 box running samba 3.0.10 and OpenLDAP 2.2.13. ... and no LDAP server (although there were the ... share on the SCO server without any smbpasswd on that server! ...
    (comp.unix.sco.misc)
  • Re: Fallout from the SCO suits
    ... >> Microsoft until their ears bled cash. ... It's obvious that anyone still running their business on an SCO ... intention of developing for MS products and running on IIS+SQL Server. ... Every MSCE I've worked with - without exception - has been a bumbler. ...
    (comp.unix.sco.misc)
  • Re: Where to find SCO Termlite?
    ... Where to find SCO Termlite? ... I use putty myself as a developer and admin and only when I don't need certain features that my application relies on that various commercial emulators have. ... Because the seats are licenced on the server instead of in the client, the client is free and freely downloadable redistributable, You can put a link to the installer right on a web page next to a "login" button, and the user never sees anything like a license number or serial number or registration. ...
    (comp.unix.sco.misc)
  • Re: Where to find SCO Termlite?
    ... Where to find SCO Termlite? ... licenced on the server instead of in the client, ... There are a few Java emulators out that that make it possible to be as easy ...
    (comp.unix.sco.misc)
  • Re: SCO admits it wont continue with UNIX
    ... A few hours after posting this, my mail server received a little over ... >> A translation of the speech and comments made by Gregory Blepp ... for those SCO employees who might think that SCO's Unix ... > You know damn well that almost all of us have Linux and/or BSD ...
    (comp.unix.sco.misc)