UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Network Issue For Access, Any Versions    
 
   
eacollie
post Oct 2 2019, 06:38 PM
Post#1



Posts: 726
Joined: 15-January 05
From: Tennessee


I understand Access does not function with a WiFi connection. I have attached a picture of what is being used to transfer network from one building to another, at which point it is carried to individual computers using cable. Will this set up work to run Access on the individual computers? The database is split with data files on server inside network.
I hope this makes sense.
Attached File(s)
Attached File  20191002_135657.jpg ( 843.54K )Number of downloads: 7
 
Go to the top of the page
 
GroverParkGeorge
post Oct 2 2019, 07:16 PM
Post#2


UA Admin
Posts: 36,051
Joined: 20-June 02
From: Newcastle, WA


Access CAN work across Wifi, but it is not reliable. I think that's a subtle, but important distinction. The problem is that the possibility of a minor, fleeting network outage on Wifi can mean data corruption if that interruption happens while data is being written back to the Back End over the Wifi.

I can't really offer any comment about your environment, based on that image. Maybe someone will recognize it and know what it is and how it works.

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
GroverParkGeorge
post Oct 2 2019, 07:20 PM
Post#3


UA Admin
Posts: 36,051
Joined: 20-June 02
From: Newcastle, WA


One thing you might look into would be putting your back end into a SQL Server Express database. SQL Server is more resilient and the chance of corruption would be less, for that reason.

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
DanielPineault
post Oct 2 2019, 08:30 PM
Post#4


UtterAccess VIP
Posts: 6,974
Joined: 30-June 11



Try it, that the only way to know for sure. That said, backup, backup, backup. I'd setup a regular hourly backup.

I also think George's suggestion of using SQL Server (Express) as a Back-end to be a wise approach that would make it more robust especially considering you are using a wifi network.

--------------------
Daniel Pineault (2010-2019 Microsoft MVP, UA VIP, EE Distinguished Expert 2018)
Professional Help: https://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: https://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 
arnelgp
post Oct 3 2019, 04:01 AM
Post#5



Posts: 1,510
Joined: 2-April 09
From: somewhere out there...


make sure the cable is less than 100 meters, otherwise expect some drop of connections.

--------------------
Never stop learning, because life never stops teaching.
Go to the top of the page
 
GroverParkGeorge
post Oct 3 2019, 09:42 AM
Post#6


UA Admin
Posts: 36,051
Joined: 20-June 02
From: Newcastle, WA


That's a handy thing to know. Can you reference the documentation on cable lengths? I'd like to learn more about that.

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
DanielPineault
post Oct 3 2019, 09:48 AM
Post#7


UtterAccess VIP
Posts: 6,974
Joined: 30-June 11



QUOTE
The maximum length depends on a couple of things such as the transmission speed and the Category of twisted-pair LAN cable being used.

Typically, for 10/100/1000 mbps links, 100 meters (approx. 300 ft.) is the maximum length for cables with Cat5e or better. A 10 gbps link requires Cat6 cabling for up to 55 meters or Cat6a for up to 100 meters.

To extend copper ethernet connections farther than 100 meters, an intermediary network switch can be added or cascaded in between spans, which will effectively extend the connection another 100 meters.

For cascading ethernet in general, it is recommended to follow the “5–4–3 Rule”. There should only be a maximum of FIVE segments connected to FOUR repeaters/switches, and only THREE of the segments can have users on them.

Alternatively, for longer single-segment spans above 100 meters up to well into the hundreds or thousands of kilometers, fiber optics are used.

--------------------
Daniel Pineault (2010-2019 Microsoft MVP, UA VIP, EE Distinguished Expert 2018)
Professional Help: https://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: https://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 
GroverParkGeorge
post Oct 3 2019, 09:59 AM
Post#8


UA Admin
Posts: 36,051
Joined: 20-June 02
From: Newcastle, WA


Thanks, Daniel. Where did that come from?

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
arnelgp
post Oct 3 2019, 10:01 AM
Post#9



Posts: 1,510
Joined: 2-April 09
From: somewhere out there...


Daniel has given the technical.
I've read it some years back.
and it's true in all cases, when you are near
the source, the more resources you get.
be it data, electricity, water, food, etc..

--------------------
Never stop learning, because life never stops teaching.
Go to the top of the page
 
GroverParkGeorge
post Oct 3 2019, 10:54 AM
Post#10


UA Admin
Posts: 36,051
Joined: 20-June 02
From: Newcastle, WA


Yes, I saw that. In general, of course, there is a relationship between proximity and strength. I was more interested in where you found the reference to exactly 100 meters. Why it's not 78 meters, or 110 meters. It's handy to be able to advise clients on things like that, but at the same time, unqualified recommendations tend to be less convincing.


--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
DanielPineault
post Oct 3 2019, 11:15 AM
Post#11


UtterAccess VIP
Posts: 6,974
Joined: 30-June 11



This has to do with physics/math -> noise... dropped packets..., but you can find it stated all over the net and in books. For instance:

https://en.wikipedia.org/wiki/Category_6_ca...#Maximum_length

--------------------
Daniel Pineault (2010-2019 Microsoft MVP, UA VIP, EE Distinguished Expert 2018)
Professional Help: https://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: https://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 
eacollie
post Oct 3 2019, 06:13 PM
Post#12



Posts: 726
Joined: 15-January 05
From: Tennessee


Thank you to all -- so does anyone know what this equipment is?
Go to the top of the page
 
DanielPineault
post Oct 3 2019, 06:37 PM
Post#13


UtterAccess VIP
Posts: 6,974
Joined: 30-June 11



Looks like a Ubiquiti Point to Point Bridge. It's a wifi network, regardless of the computer being connected by a wire, the actual network itself is wifi.

--------------------
Daniel Pineault (2010-2019 Microsoft MVP, UA VIP, EE Distinguished Expert 2018)
Professional Help: https://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: https://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    19th November 2019 - 08:26 AM