Access DB Online

[zezo2021]

Hello friends;

I connect this DB to Sql Server Online It contain one table and many query

Can you please test add and tell me your opinion

did it work Correctly
What windows do you have

Did it not work? Why
what version of windows do you have

 

[The_Doc_Man]

@zezo2021 - my security system blocks this kind of activity so I can't help you. Don't be surprised if you don't get very many testers because your request is not one we commonly get.

 

[zezo2021]

@zezo2021 - my security system blocks this kind of activity so I can't help you. Don't be surprised if you don't get very many testers because your request is not one we commonly get.

I ask
because
I test the DB on many virtual machine and my computer and work

Send it to client say not work

confusing

 

[zezo2021]

The second question Is:

What best way to link table to GoDaddy SQL SERVER From access

I prefer YOUTUBE tutorial

 

[The_Doc_Man]

I cannot answer that question because it is outside of my expertise. However, I'm sure that eventually one of our other members will add in some comment on this question. Please be patient because I am not entirely sure how many of our people do this kind of thing. I'm sure it is not that many, so it might take a while to get a response.

 

[Pat Hartman]

Is there security on the db that is preventing people from linking to the table from other URL's?

 

[arnelgp]

it is working on my side.

windows 10 x64
msa 2019 x64
wifi-internet.

 

[isladogs]

It works for me as well.
However be aware that your server details, UID and password are all exposed in the connection string

 

[zezo2021]

It works for me as well.
However be aware that your server details, UID and password are all exposed in the connection string

Is there there any way to hide server details

 

[isladogs]

Not completely
Everything except the password is visible from the connection string shown when you hover over a linked table
However the connection string INCLUDING the password is also available from the MSysObjects system table
The password is also visible from the connection strings for the passthrough queries

Even if you use DSN-less connections, the connection string remains visible from the navigation pane.
You could hide all linked tables and hide the navigation pane (OR use runtime version of Access)

This article might be helpful but I haven't tested it: How to securely store Connection String details in VBA - Stack Overflow