Network Connectivity Issues with Microsoft Access when accessing Remote Databases

[romilly]

I'm having trouble with Microsoft Access when trying to connect to a remote database over my network 192.168.0.1.

The connection is either very slow or fails intermittently. I’ve checked my network settings and ensured that other applications are working fine, but Access continues to have issues. I want to solve this issue with the help of your suggestion.
Thank you.

[jimatqsi]

Welcome to the Bytes.com community, Romilly. We'll try to help, but more information will go a long way to helping us help you.

What environment are you working in, Windows server with current (Win 11) workstations and Office 365? Or something else? What is the backend data stored in (SQL, Access or something else)?

Is this problem new, in an application that previously had no problem? Do you see the problem when you run any query or open any table, or is it specific to a given query or table? When the failure happens, what do you see?

[NeoPa]

Also, many household routers (that connect you to the internet as well as connecting all your household appliances together) assign IP addresses in the range 192.168.0.1-254 - where the first three octets are always 192.168.0. Many businesses use similar routers too.

One thing we'd particularly need to know is what the IP Addresses are of both the machine the database is stored on and the machine (Your PC.) where the database is opened.

To see the IP Address of any machine that you're running on simply open a Command Prompt (Start -> Command Prompt) then type out the following and hit <Enter> :
IP Config

You're looking for the IPv4 Address line following your Ethernet Adapter. There may be multiple Ethernet adapters, but only one that has an IPv4 Address line.

[romilly]

Welcome to the Bytes.com community, Romilly. We'll try to help, but more information will go a long way to helping us help you.

What environment are you working in, Windows server with current (Win 11) workstations and Office 365? Or something else? What is the backend data stored in (SQL, Access or something else)?

Is this problem new, in an application that previously had no problem? Do you see the problem when you run any query or open any table, or is it specific to a given query or table? When the failure happens, what do you see?

Environment: Windows Server with Windows 11 https://19216801.pro/ workstations and Office 365; backend data in SQL.
Problem: Describe if it's new or affects specific queries/tables.
Error Details: What exactly happens when the failure occurs?