Search results
14 mar 2016 · The AutoExec macro is a macro named AutoExec which runs when you start your Access app. You can use the RunCode macro function to call your VBA function (it does have to be a function and not a sub). This way you can (re)link your table before the form is even opened. answered May 6, 2014 at 15:43. Brad.
If your database has a username/password, then your sConnString needs to have "Password=###;User ID=###". ALso, the sConnString should have "Data Source=IP_ADDRESS_OF_SERVER" and if you're using the same computer for database & VBA, then you can use 127.0.0.1 for the IP_ADDRESS_OF_SERVER. – Michael. Dec 9, 2014 at 17:49.
19 sie 2021 · I have always been successful in connecting my VBA solutions in MS Access as a client to my company’s SQL Server, but I struggled for a long time to figure out how to connect to a SQL Server Express LocalDB instance on my personal computer until now.
20 sty 2022 · I am using VBA to try and connect to SQL server. Here is the code: Sub GetDataFromADO () 'Declare variables' Set mConn = New ADODB.Connection. Set mRS = New ADODB.Recordset. Dim strSQL As String. 'Open Connection'
17 lut 2012 · For your setup, it sounds like all you need to use is the server name. On the other hand, if you have a named instance (for example, multiple instances of SQL Server on one PC), the FOLDER might be an instance name such as COMP1\SERVER2.
12 maj 2019 · Let’s create a program. First you need to declare three variables: Dim c As ADODB.ConnectionDim rs As ADODB.RecordsetDim connectionstring As String. First variable is needed to create a database connection, second is used for creating a recorset and the third is used for a connection string.
2 kwi 2024 · I am unable to connect to my sqlserver from Excel. It is possible when i connect through a ODBC but impossible directly when i just indicate ther name of my server. Data >> Get Data >> From Database >> From SQLServer, i enter the server name (i have tried with IP), OK and nothing more... The answer is :
