Search results

Thanks for your input. Actually we have 2 products, one is a desktop with Access/Jet and the other is SQL Server/.net based on Azure. We need a solution for the Azure solution, so I will investigate.

Is PowerApps an application? Can you please clarify?

Tried it and it works with a minor problem that may be in the settings. The image that is stored is reflected ie left is right and right is left. Any idea why this is the case? Edit: My bad. It is fine.

Thanks, will try it.

A bit of a late response. Where can I find the db you made? Where is "Sample Databases"? Thanks. Edit: I did a search on the site and found it. Thanks.

We have a dental practice management software (www.VisualDentist.com) and we would like to be able to show a picture of the patient, in the patient details. There is the obvious solution where a picture is taken and stored in a file, which we can link to. The ideal scenario would be to operate...

The problem was resolved for the Desktop-Laptop network. Unfortunately I still have the problem with the pc running W10 A365 32bit on the 4pc network. I will try to run the code step by step after I double check the firewall rules and the TCP-IP connectivity.

Found the problem. In #18 above I said I use the following connection string from the desktop success fully ODBC;PROVIDER=MSDASQL;DRIVER=ODBC Driver 17 for SQL Server;SERVER=DESKTOP-KQTNJ42\SQLEXPRESS;UID=savf;Trusted_Connection=No;APP=Microsoft Office;DATABASE=VF3;PWD=1234 I use the same...

The machine name is DESKTOP-KQTNJ42 and the server name is SQLEXPRESS

Once I locate the "meat" I will send it over in a screenshot. SQL Server Browser was not running and it is running now. From both pcs I can enter the db through SSMS by using the following. I have made sure that both are looking at the same db, by making a change in one of the fields.

The correct ODBC driver (bitnesswise) had been installed

I have created a 2 pc network with a desktop and a laptop. The desktop runs W10 32-bit A365 and is called DESKTOP-KQTNJ42 The laptop runs W1112341234sa1234savf 64-bit A365 and is called JohnP The SQl Server is on the desktop and I can log onto SSMS on both with Server = DESKTOP-KQTNJ42...

Will do thanks.

I also found a suggestion of enabling Named Pipes.

Just a clarification "DESKTOP-KQTNJ42" is the name of my pc, which is not on the client's Network The Network has 4 pcs called 1) Server 2) pc1 3) pc2 4) pc3 The problem is with pc2 with runs Windows 10. The other 3 pcs run Windows 11. The Network section of pc2 is indicated below and does...

I have a meeting onsite shortly (on a Saturday). The W10 pc can see the Server (which is just a pc). I was able to create a mapped drive to the Server and SSMS can see the DB (VF3) which resides in the SQL Server on the Server. We have checked the firewall rules and will check them again.

As I mentioned the specific problem has been reported by Bitdefender as far back as 2010. A good indication of a false positive is the fact in VirusTotal no AV flags it, including Bitdefender.

At present we have a network with 4 pcs. The 3 run Windows 11 and they run ok. The 4th pc runs Windows 10 and cannot connect to the SQL Express All 4 pcs use: ODBC;PROVIDER=MSDASQL;DRIVER=ODBC Driver 17 for SQL...

Can Access 365 and Access 2013 coexist and I am not referring to the Access 2013 Runtime. Can these two versions of Access exist and can development take place in both these versions on the same pc?

The problem resurfaced and I checked the specific quarantined files at VirusTotal, where Bitdefender did not flag it as as virus. As mentioned by Edgar in #4, it must be a false positive, so I added the specific folder in the Bitdefender exceptions.