I have a Quality Assurance database. Inspectors currently input data at
desktops via wired LAN. Can I do the same with wireless laptops?
The plan is to have 10+ wireless laptops with same front ends feeding the
data to a main laptop with the back end main database.
Thoughts...
Rick B - 16 Dec 2004 14:41 GMT
I'm pretty sure that Access has no way of knowing what type of LAN card or
communication you are using. Wireless vs wired should make no difference.
> I have a Quality Assurance database. Inspectors currently input data at
> desktops via wired LAN. Can I do the same with wireless laptops?
> The plan is to have 10+ wireless laptops with same front ends feeding the
> data to a main laptop with the back end main database.
>
> Thoughts...
Tony Toews - 16 Dec 2004 20:27 GMT
>I have a Quality Assurance database. Inspectors currently input data at
>desktops via wired LAN. Can I do the same with wireless laptops?
>The plan is to have 10+ wireless laptops with same front ends feeding the
>data to a main laptop with the back end main database.
Technically it will work. Trouble is wireless networks are
relatively flaky especially when you get to the reception fringes.
You run a much greater risk of corruptions.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony Toews - 17 Dec 2004 21:35 GMT
>>I have a Quality Assurance database. Inspectors currently input data at
>>desktops via wired LAN. Can I do the same with wireless laptops?
[quoted text clipped - 4 lines]
>relatively flaky especially when you get to the reception fringes.
>You run a much greater risk of corruptions.
Just to add to my comments. A client has a similar problem. Should
they ever decide to give the QC folks tablet PCs or such we were going
to put them on Terminal Server.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Immanuel Sibero - 16 Dec 2004 21:34 GMT
Hi Paul,
As Tony pointed out, I would make good backup and test and test and test it.
I ran Access on the earlier technology (802.11b I think), and quickly
abandoned it because of occasional corruptions. I had another commercial app
written in C with dbaseIV backend that was frequently corrupted over
wireless. They have obviously improved wireless but I have been shy to try
any database app on wireless.
Other factors to consider include sources of interference, static,
obstructions where the wireless is implemented (i.e. walls, machinery, etc.)
If you decide to try, do post back your experience, I'd be interested.
HTH,
Immanuel Sibero
> I have a Quality Assurance database. Inspectors currently input data at
> desktops via wired LAN. Can I do the same with wireless laptops?
> The plan is to have 10+ wireless laptops with same front ends feeding the
> data to a main laptop with the back end main database.
>
> Thoughts...
Paul Casavant - 20 Dec 2004 06:21 GMT
Thanks for all of your quick responses.
I'll test it out with the 802.11g laptops & test, test, test.
Merry Xmas ;<}
> Hi Paul,
>
[quoted text clipped - 19 lines]
> >
> > Thoughts...
SirPoonga - 20 Dec 2004 20:34 GMT
If I were to do this I would think about using an intranet and a web
browser interface. Not sure how well teh ASP pages access creates
would work off hand.
I would go this route because then the record data isn't travelling
across the wireless connection, just the user interface is.
Immanuel Sibero - 20 Dec 2004 21:32 GMT
Just my .02 cents worth,
Given the assumption that an Access app has been in production, I would
probably lean towards terminal server as Tony suggested.
First, you wouldnt have to convert (i.e. rewrite) to ASP pages.
Second, the Terminal Server scenario might even be more stable. If the
wireless connection is dropped, only your connection to the terminal server
is dropped.
Third, terminal service scenario also eliminates data travelling across
wireless.
HTH,
Immanuel Sibero
> If I were to do this I would think about using an intranet and a web
> browser interface. Not sure how well teh ASP pages access creates
> would work off hand.
>
> I would go this route because then the record data isn't travelling
> across the wireless connection, just the user interface is.
SirPoonga - 20 Dec 2004 21:43 GMT
Right, that would work, either Terminal Services or simular application
like VNC.
Tony Toews - 21 Dec 2004 22:40 GMT
>Right, that would work, either Terminal Services or simular application
>like VNC.
But does VNC allow multiple connections to one system such as Terminal
Server? If not you'd have to dedicate a PC per connection.
Does MSs license agreement allow for such outside Terminal Server?
Which is rather doubtful. <smile>
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm