Detecting network media connect / link state

#21

Access works GREAT with wifi if you use Access Data Projects!

On Jan 12, 5:22*pm, "David-W-Fenton" <dfas... (AT) dfenton (DOT) com> wrote:

Quote:

Tony Toews <tto... (AT) telusplanet (DOT) net> wrote innews:akkqi69sv2o4661visc9hj24sjr3o96f02 (AT) 4ax (DOT) com:

On Tue, 11 Jan 2011 00:30:34 -0800 (PST), The Frog
mr.frog.to.... (AT) googlemail (DOT) com> wrote:

Thanks for the response. I thought about this but the problem is
actually a little more subtle. What I want to ensure is that no
data is fed back to the 'master' database unless the user is
connected by LAN - so no VPN's, no Wireless LAN, etc...

One possible means of differentiating between wired connection,
WiFi and cell phone is to look at the connect speed of the device.
* If 10 (unlikely), 100 or 1000 mbps then it's wired. * If not
then it's not.

How do you get that information? My WiFi fluctuates from 54Mbps down
to 1Mbps, depending on who knows what. And badwidth is not the issue
-- 802.11n can theoretically exceed 100Mbps, but you still wouldn't
want to use a wireless connection running at that speed. And 10Mbps
wired is perfectly satisfactory for Access/Jet/ACE (it's all we had
back when I first started programming multi-user apps in Access!).

However as David points out folks can have multiple devices and
how do you know which Access is using? *Maybe force them to turn
off all other connections.

But then what if it a legitimate VPN is present? * Ah well.

You might be able to figure it out with a traceroute, which will
tell you which network device is being used. You'd then have to
parse the output. There might be better networking utilities that
would tell you more, but I don't use them often enough to know which
is appropriate here. In any case, there might very well be APIs that
do the same thing.

--
David W. Fenton * * * * * * * * *http://www.dfenton.com/
contact via website only * *http://www.dfenton.com/DFA/

#22

On Sat, 15 Jan 2011 09:12:06 -0800 (PST), "a a r o n . k e m p f
@gmail.com [MCITP: DBA]" <aaron.kempf (AT) gmail (DOT) com> wrote:

Quote:

good idea to use sharepoint?

NEVER EVER EVER is sharepoint a good idea. It's too slow / propietary
to be useful to anyone!

Umm, aren't Access and SQL Server proprietary?

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

#23

Aaron you are right about this, however I dont have the chance to
deploy anything of that nature in my environment. I also tried an
approach from Java using Tomcat as the server and an Eclispe /
Netbeans RCP but was shot down by the IT group. I'm afraid I'm going
to have to break the problem into smaller parts and probably handle
this with a drop folder type approach for separate data 'upserting' so
to speak.

But thankyou for the suggestion

Cheers

The Frog

#24

Hi Guys,

I have explored the 'server side' of the deployment scenario and I am
not going to be able to do squat. That means all I will have access to
are some tables on a BE most likely Oracle. What I intend to do is to
have the FE read the necessary incoming data from Oracle (if thats
what is used) and store to a local BE. Processing of the data that the
users do will be done locally, batch-by-batch so to speak, then when
the process is complete the user has the option to process another
batch or dump whatever they have already completed to a 'drop file'.
The drop file will be simply a dump of the results into a new mdb file
that can be copied to a network share. Once there is a file (or more)
on the network share I can run an integration process from my machine
to upsert the data to the Oracle BE. The filenames of the dropfiles as
well as the workload batches will have to be part of the data that is
transferred back and forth so that the same data is not processed
repeatedly.

Its a little cumbersome but it should work and be stable. To make a
more elegant solution I would need to be able to affect change to the
server(s) we have here and thats just not going to happen for this
problem (unfortunately). I would have preferred to handle the entire
thing via a web browser and leave the heavy work on the server, but no
joy on this one I'm afraid.

Thankyou all for your help and suggestions on this. I will report back
if there are any hassles.

Cheers and Thanks

The Frog

#25

The Frog <mr.frog.to.you (AT) googlemail (DOT) com> wrote in
news:9bf31223-19b7-4e2e-876f-8ab01ad20819 (AT) 29g2000yqq (DOT) googlegroups.com
:

Quote:

Aaron you are right about this,

The reason ADPs work over WiFi is not because it's an ADP but
because you're using a server back end (SQL Server). You would get
exactly the same benefit of stability and reliability over WiFi with
an MDB/ACCDB front end as long as you use a server back end. And if
you choose MDB/ACCDB as your front end, you get to choose your back
end, Oracle, MySQL, whatever, instead of being limited to an ADP.

So, really, Aaron doesn't have an point at all, and it wouldn't be
helpful in an environment in which you said Oracle is the supported
database server.

Quote:

however I dont have the chance to
deploy anything of that nature in my environment. I also tried an
approach from Java using Tomcat as the server and an Eclispe /
Netbeans RCP but was shot down by the IT group. I'm afraid I'm
going to have to break the problem into smaller parts and probably
handle this with a drop folder type approach for separate data
'upserting' so to speak.

Will you have the ability to manage the Oracle database? That is,
will you be given the privileges to create sprocs and views on the
server in support of what you need to do? Or will you be forced to
do it all from the client?

Do they realize that they are spending tons of money paying you to
do this when they could spend a lot less and get something that was
much less complex, would take a lot less time to implement and would
be much more robust?

That is, do they realize that their inflexibility is almost
comically penny-wise/pound foolish?

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

#26

If I had to wager, I'd guess a typical Oracle DBA would throw up his/her
hands in horror at the very idea of letting a mere "Access user" touch his
"baby" in the manner you describe. That's based on a few years' personal
experience with DBAs in customer/client shops (and the Oracle crowd are
"moreso than most", I fear).

Larry

"David-W-Fenton" <dfassoc (AT) dfenton (DOT) com> wrote

Quote:

The Frog <mr.frog.to.you (AT) googlemail (DOT) com> wrote in
news:9bf31223-19b7-4e2e-876f-8ab01ad20819 (AT) 29g2000yqq (DOT) googlegroups.com
:

Aaron you are right about this,

The reason ADPs work over WiFi is not because it's an ADP but
because you're using a server back end (SQL Server). You would get
exactly the same benefit of stability and reliability over WiFi with
an MDB/ACCDB front end as long as you use a server back end. And if
you choose MDB/ACCDB as your front end, you get to choose your back
end, Oracle, MySQL, whatever, instead of being limited to an ADP.

So, really, Aaron doesn't have an point at all, and it wouldn't be
helpful in an environment in which you said Oracle is the supported
database server.

however I dont have the chance to
deploy anything of that nature in my environment. I also tried an
approach from Java using Tomcat as the server and an Eclispe /
Netbeans RCP but was shot down by the IT group. I'm afraid I'm
going to have to break the problem into smaller parts and probably
handle this with a drop folder type approach for separate data
'upserting' so to speak.

Will you have the ability to manage the Oracle database? That is,
will you be given the privileges to create sprocs and views on the
server in support of what you need to do? Or will you be forced to
do it all from the client?

Do they realize that they are spending tons of money paying you to
do this when they could spend a lot less and get something that was
much less complex, would take a lot less time to implement and would
be much more robust?

That is, do they realize that their inflexibility is almost
comically penny-wise/pound foolish?

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

#27

eat a dick.

ADP work over WIFI and MDB doesnt

quit your bitching you faggot

On Jan 17, 2:50*pm, "David-W-Fenton" <dfas... (AT) dfenton (DOT) com> wrote:

Quote:

The Frog <mr.frog.to.... (AT) googlemail (DOT) com> wrote innews:9bf31223-19b7-4e2e-876f-8ab01ad20819 (AT) 29g2000yqq (DOT) googlegroups.com
:

Aaron you are right about this,

The reason ADPs work over WiFi is not because it's an ADP but
because you're using a server back end (SQL Server). You would get
exactly the same benefit of stability and reliability over WiFi with
an MDB/ACCDB front end as long as you use a server back end. And if
you choose MDB/ACCDB as your front end, you get to choose your back
end, Oracle, MySQL, whatever, instead of being limited to an ADP.

So, really, Aaron doesn't have an point at all, and it wouldn't be
helpful in an environment in which you said Oracle is the supported
database server.

however I dont have the chance to
deploy anything of that nature in my environment. I also tried an
approach from Java using Tomcat as the server and an Eclispe /
Netbeans RCP but was shot down by the IT group. I'm afraid I'm
going to have to break the problem into smaller parts and probably
handle this with a drop folder type approach for separate data
'upserting' so to speak.

Will you have the ability to manage the Oracle database? That is,
will you be given the privileges to create sprocs and views on the
server in support of what you need to do? Or will you be forced to
do it all from the client?

Do they realize that they are spending tons of money paying you to
do this when they could spend a lot less and get something that was
much less complex, would take a lot less time to implement and would
be much more robust?

That is, do they realize that their inflexibility is almost
comically penny-wise/pound foolish?

--
David W. Fenton * * * * * * * * *http://www.dfenton.com/
contact via website only * *http://www.dfenton.com/DFA/

#28

yah but SQL Server works with firefox you fucking NooB

On Jan 16, 5:18*pm, Tony Toews <tto... (AT) telusplanet (DOT) net> wrote:

Quote:

On Sat, 15 Jan 2011 09:12:06 -0800 (PST), "a a r o n . k e m p f
@gmail.com [MCITP: DBA]" <aaron.ke... (AT) gmail (DOT) com> wrote:

good idea to use sharepoint?

NEVER EVER EVER is sharepoint a good idea. It's too slow / propietary
to be useful to anyone!

Umm, aren't Access and SQL Server proprietary?

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages -http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
* updated seehttp://www.autofeupdater.com/

#29

The Frog <mr.frog.to.you (AT) googlemail (DOT) com> wrote in
news:12fce774-9f23-4c37-89fd-8ca5893dbe38 (AT) t8g2000vbd (DOT) googlegroups.com
:

Quote:

I think it
must be obvious by now that I have very little respect for this
department. They have to retire sometime.

They might kill the company before they reach that point.

I have seen refusal to retire kill any number of healthy
organizations. It's cheaper in the long run for the organization to
buy out the dead weight, but that's usually not obvious in the short
run.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

#30

With any luck I wont be here much longer :-) The company (management)
is convinced of their Godlike abilities while at the same time
managing to lose half the companies turnover and still reward
themselves for 'Top Performance'. One of the seniors even gave an
award to another senior for excellent performance, which cost the
company 100Million Euro per year in turnover (in an expanding
market!). I cant see this place, despite its size, surviving much
longer. I give it maybe 5 years at most in its current direction
before the parent arm simply shuts up shop and outsources everything
to a distributor and separate manufacturer to do some brand labelling
on generic product. Exit stragetgy is being developed as we speak.....

The Frog