Including information from one database into another – MS Access

I have created a new table in MS Access which, for my purposes here, I’ll call Table A. It contains a ton of information that staff need to enter for each company or individual. The forms are time consuming to complete and so, I thought, to save them a bit of time, many of those company and individual names already exist in the contacts database, so they could simply enter in the last name (or company name) and it would get the info from the contacts database and populate the field. And that works great if the client’s name is already in the contacts database.

However, some names are new and don’t exist in the contacts database.

If they have to go to the contacts database (or the form for it) and enter in the contact name and address, THEN go to Table A and enter in all the information associated with it, it won’t be a time saver at all.

There must be a way, if the name doesn’t exist, for a form to pop up so the user can add that information which would then populate the contacts database so that it would then populate Table A.

Does anyone know how to do that? Or if it’s possible? I’m self-taught, and a novice user.

Thank you!

Lori

networking – Cannot Access LAN through VPN on TPLink TL-R600VPN

I would like to use my TP-Link TL-R600VPN router to access my home network. Here is a rough sketch of my setup:

Network Topology

My internet service comes through a Hub that has built in modem, router and Mesh WiFi. The LAN on this router is 192.168.2.0/24. I have a couple of servers on this LAN that I need to be able to access while traveling.

I have connected the WAN port on my VPN Router to the Hub with a fixed IP address: 192.168.2.2. I have put this IP address into the DMZ on the Hub, and am successfully able to connect to my VPN router from outside. I have also connected one of the Ethernet ports on the VPN router back to the Hub.

Here is the problem. The VPN router does not let me assign remote connections an IP address within the same subnet (192.168.2.*) as its WAN port. I’ve configured the VPN router’s LAN as 192.168.3.0/24 so the remote connection gets an address in that range. Here is the routing table on the VPN Router:

ID  Destination IP  Subnet Mask     Next Hop    Interface   Metric
1   0.0.0.0         0.0.0.0         192.168.2.1 WAN1        0
2   85.203.37.1     255.255.255.255 192.168.2.1 WAN1        0
3   85.203.37.2     255.255.255.255 192.168.2.1 WAN1        0
4   127.0.0.0       255.0.0.0       0.0.0.0     lo          0
5   192.168.2.0     255.255.255.0   0.0.0.0     WAN1        0
6   192.168.3.0     255.255.255.0   0.0.0.0     LAN         0

I cannot reach the servers on home LAN (192.168.2.*) from a remote computer connected to the VPN Router.

What do I need to do to achieve this? Any help/suggestions would be greatly appreciated. One thing I should mention is that my Hub’s interface does not allow me to add any static routes, but the VPN Router allows static routes to be added.

python – How do I use Rest Data Source API with access tokens?

I’m trying to get data back from an API without having to loop through an RDD, and I found the Rest Data Source Library on Git hub: https://github.com/sourav-mazumder/Data-Science-Extensions/tree/master/spark-datasource-rest

The issue I’m running into is how to incorporate Access Tokens in with parameter mapping. When it comes to the supported options the descriptions has this for the URL call: url: This is the uri of the target micro service. You can also provide the common parameters (those that don’t vary with each API call) in this url. This is a mandatory parameter. I’ve been trying to do this using python/pyspark if possible

So I have code structured like this:

Getting access token:

token_url = 'https://restful-website/oauth/token'

search_url = 'https://my_final_endpoint'

client_id = my_client_id

client_secret = my_client_secret

data = {'grant_type': 'client_credentials'}

access_token_response = requests.post(token_url, data = data, verify = False, allow_redirects = False
                                      , auth = (client_id, client_secret))
tokens = json.loads(access_token_response.text)
api_call_headers = {'Authorization': 'Bearer ' + tokens('access_token')}

expert_input_Df = spark.read.csv(file_directory, inferSchema = True, header = True)
expert_input_Df.createOrReplaceTempView('test_expert')
*expert_prms_Soda = { 'url' : search_url
            , 'input' : 'test_expert'
            , 'method' : 'GET'
            , 'readTimeout' : '10000'
            , 'connectionTimeout' : '2000'
            , 'partitions' : '10'}
expert_returnDf =* spark.read.format('org.apache.dsext.spark.datasource.rest.RestDataSource').options(**expert_prms_Soda).load()
expert_returnDf.printSchema() 
expert_returnDf.createOrReplaceTempView("expert_table")
spark.sql("select name, address, city_name from expert_table ").show()

What I would like to know is how do I get this to work with the access token? And ‘what common parameters are needed to get this to work. I’m stuck at this point and could use some guidance, please. This api call doesn’t take headers so I’m kind of stuck and I don’t want to have to use an RDD just to do this……

soft question – Sustainability of ZBmath unrestricted access

ZBmath (formerly Zentralblatt für Mathematik) will become “Open access” in 2021 (see for instance at EMS site and at FIZ Karlsruhe site). It used to be under paywall, although some partial access was allowed.

My question (which was suggested in the comments of this answer to Is a free alternative to MathSciNet possible?):

What are guarantees (technical and/or legal) that the reviews will remain in unrestricted universal access?

(Concretely, I’d be reluctant to write reviews if ZBmath has the possibility to suddenly turn back to partial paywall in 2030 for whatever reasons, especially if this paywall affects searches for reviews made during the so-called open-access period.)

How to Access a Windows VPS using Remote Desktop

How to Access a Windows VPS using Remote DesktopWindows VPS’s are widely used nowadays. They can be used for numerous purposes and could be set up according to your needs.

A typical scenario is to use Windows VPS as a web host for a website. This provides much better control and customization options compared to using a shared hosting server. You can install any application and service on a Windows VPS to better your experience. Moreover, a VPS provides a consistent performance for your website.

Other than web hosting, a Windows VPS can be used as a server for multiplayer games. A VPS is essential if you want to host multiplayer games such as CS: GO.

Another popular use of a Windows VPS is to use it as a backup for your main computer.

You can access your Windows VPS through the remote desktop protocol. RDP was developed by Microsoft to connect two remote computers through the internet.

How do I access a VPS using Remote Desktop?

Today, we will tell you how you can access your Windows VPS through various operating systems via RDP.

Windows:

Let’s start with Windows. Open the start menu, then search for “Remote Desktop Connection.” Open the program, and you would be prompted for the remote VPS’s IP address or hostname. Once you enter the IP address, it will ask you for a password if you have set one on your VPS. You can also select the resolution and color depth from the display tab.

You can also open this program by typing “mstsc” in the Run program.

macOS:

On macOS, you would need to download the “Microsoft Remote Desktop.” Open the App Store, search for the app, and download it.

When the Microsoft Remote Desktop is installed and opened, click on the “New” option. It would then prompt you for the IP address, user name, and password for the remote desktop. There are also several other options, such as the resolution and full-screen mode.

Moreover, you can also forward your local printing devices, and even swap the mouse buttons. You can also choose a local folder to be available to the remote desktop.

Ubuntu:

On computers running on Ubuntu, you can access the remote Windows VPS with the default app that is called Remmina.

Search for Remmina or RDP in the apps list and open it. Then click on the “+” icon in the top left of the app. It would then prompt you for the server’s IP address, user name, and password. You can also select the resolution and color depth. Click “Save and connect” to start the connection.

As you can see, Windows VPS’s are accessible from multiple platforms, the best part about it is with a Windows VPS RDP, you can start your work on one computer, and resume it and pick up where you left off even if you transition to a different workstation or computer.

Jon Biloh

I’m Jon Biloh and I own LowEndBox and LowEndTalk. I’ve spent my nearly 20 year career in IT building companies and now I’m excited to focus on building and enhancing the community at LowEndBox and LowEndTalk.

sql server – What can cause log shipping copy step to occasionally fail with access denied?

Have sql agent job for log shipping copy step that fails every once in a while with “Reason: access is denied” but no other detail.

Here is what the failing step looks like:
“C:Program FilesMicrosoft SQL Server120ToolsBinnsqllogship.exe” -Copy DEF49099-4526-ABCD-83AE-E00F5C221E74 -server MyServer

Job runs every 15 minutes but fails maybe once a day. SQL Agent service running as domain user. How can I drill down further on this intermittent failure.

Microsoft SQL Server 2014 (SP2-CU10-GDR) (KB4052725) – 12.0.5571.0 (X64)
Standard Edition (64-bit) on Windows NT 6.3 (Build 9600: )

Deny access to all the content of a section of website with Nginx from Plesk

I need to deny access to a part of website and allow some IP Addresses to access it for example my site is example.com it is accessible by every one but example.com/test and all its files are accessible only for 123.123.123.123, so I tried this code in PLESK.

Domains > example.com >Apache & nginx Settings. In the Additional nginx directives section I added this code and my IP address.

Code:

location ^~ /test {
allow 203.0.113.2;
deny all;
}

this worked for example.com/test but for example.com/test/file.php it did not work the files are accessible, and they are being downloaded instead of being executed, I Googled for solution but I did not find anything so what should I add to fix this and to deny access to all the content of /test
because I need to upload an angular project in this directory that I want to limit access to, so I need to deny access to different directories and different file formats.

network – MacBook Pro running 10.15.6 lose .local access. I can’t reach my home server until restarting it. Solutions?

I have a Debian server with a .local address and a dynamic ip served by my router.
I have a number of Macs and iOS devices at home, and I can reach the Debian server with the .local address without any issues in all but one of them: a Macbook Pro running Catalina 10.15.6.
This machine can connect to the server and the connection will work for some time –days maybe– then it will no longer be able to connect. When pinging the server from this machine on those occasions, there is a time-out: nothing comes back. Restarting the MacBook Pro or the router is not enough: I have to restart the server and then I can reach the machine again.

I did this change in the System Preferences > Network > DNS to no avail.

System preferences

permissions – Whatsapp can access my microphone after disabling all sensors, other apps cannot

I’ve recently discovered the developer option “quick access toggle” for turning off all sensors on Android 10 on my Redmi and thought: “Finally a way to regain some control for when those apps can access the mic/cam”

But after testing it, i’ve noticed that some apps still are able to access the mic like usually. Whatsapp and the recorder app pick up everything like i didn’t turn it off, in telegram, a voice message is silent, like it’s supposed to be.

How is it possible for Whatsapp to just access the mic anyway?

nginx – how can I deny access to all the content of a section of website

I need to deny access to a part of website and allow some IP Addresses to access it for example my site is emample.com it is accessible by every one but emample.com/test and all its files are accessible only for 123.123.123.123 , so I tried this code in PLESK

Domains > example.com >Apache & nginx Settings. In the Additional nginx directives section I added this code and my ip address

Code:

location ^~ /test {
allow 203.0.113.2;
deny all;
}

this worked for emample.com/test but for emample.com/test/file.php it did not work the files are accessible, and they are being downloaded instead of being executed, I googled for solution but I did not find anything so what should I add to fix this and to deny access to all the content of /test
because I need to upload an angular project in this director that I want to limit access to, so I need to deny access to different directors and different file format