Search results

Hi all, Did not receive an answer whether I can download the Access Runtime from the link above and what happens if I do not have Office installed on the PC. Why would I install the Runtime if the full Access version is installed.

Q1) Do you know whether I download Office Deployment Tool from below link? Download and install Microsoft 365 Access Runtime - Microsoft Support Q2) What if no Office is installed? At present I use A13 Runtime and I do not need the presence of Office and come to think of it it is better if no...

Did someone mention where I can download A21 Runtime from?

Thanks for the info about A21. How about the A21 Runtime? Do you know where I can download it from?

I believe the Access 2021 is the latest version I can get as a standalone. I have not been able to find a download place on the web. There is mention of the Office Deployment Tool below, that may be relevant: Download and install Microsoft 365 Access Runtime - Microsoft Support Can I buy A21...

At the end of the day, it would be unreasonable to expect the user to have Office installed, so I believe that for the sake of stability, a specific version of Access should be used, say A21 and the specific Runtime should be installed.

Just came across the following When installing the Access 365 Runtime on a machine that has another Click-to-Run version of Office installed, the Access Runtime installed will match that of the existing Office installation. For instance, if the machine has Office 2021 installed, Access 2021...

Code works fine, Only very minor issue, above should be IsDBServerAvailable(strCn) Happy holidays!

Many thanks for stating the obvious!!! My comment was for Minty's reference to a FileDSN.

Yes it works and I will also check the new code you sent over, to which I may need to add the Provider. Many thanks.

I added the On Error (see 1) and empty Error Handler (see 2) and it works fine and executes (see 3)

Yes I am using 32-bit. It worked with the addition of "PROVIDER=MSDASQL" I changed the db from VF3 (which exists) to VF4 (which does not exist) and I get the following error

Same error message as above

After commenting out, at the .Open it says

I have tried specifying a table in the connection string, different dbs. Have tried other code which I found on the Internet. There is not much I can do, if the connection string works.

I tried your suggestion. It is telling me that it is not available Function IsSQLServerAvailable(strCn As String) As Boolean On Error Resume Next With CreateObject("ADODB.Connection") .ConnectionString = strCn .CursorLocation = 3 ' adUseClient .Open If .State = 1 Then...

Chicken and egg situation! The check should be done prior to linking any tables.

I also tried closing all elements forms, queries, tables etc before Application.Quit, but it did not help.

These are the two annoying messages I get

If any of the Connection parameters to the SQL Server is wrong then I get prompted to enter the SQL server password. Is there a way to check for the presence of the SQL Server without the user being prompted for the password. I use a DSNless connection from A365 to SQL Server Express and the...