Search results

  1. P

    Connection to SQL Server using VBA connection string and Azure AD

    I have a SQL Server 2019 running on Amazon AWS and use Access 2021 as a front-end for an in-house application. I connect to SQL Server every time I want to run a stored procedure using a connection string in VBA: dbConn.Open "Driver={SQL Server};Server=SQLSERVER;Database=NorthWind;User...
  2. P

    Rusty but experienced data engineer

    Hi all My name is Paul and based in the North West United Kingdom. My background is mainly as a data engineer in a Business Intelligence environment but during that time I have built various apps with an Access front end and Microsoft SQL Server back-end. I would say I am pretty much an expert...
Top Bottom