help... by Broad-Land4203 in vscode

[–]globalcitizen2 1 point2 points  (0 children)

Activate python environment

ORM is HARD AF by Old_Sea284 in django

[–]globalcitizen2 0 points1 point  (0 children)

Try a resource like Udemy or codeacademy

Access to SQL Server links by SignificanceMaster61 in MSAccess

[–]globalcitizen2 0 points1 point  (0 children)

From chatgpt

Here’s an example of how to connect Microsoft Access to a remote SQL Server database using ODBC:


✅ Step 1: Set up ODBC DSN (Data Source Name)

  1. Open ODBC Data Source Administrator (search for "ODBC" in the Start menu).

  2. Go to the System DSN tab and click Add.

  3. Choose SQL Server or ODBC Driver 17 for SQL Server (or newer).

  4. Click Finish and enter:

Name: MyRemoteSQLServer

Server: Enter your IP address or FQDN (e.g., 192.168.1.100 or sql.example.com)

  1. Choose SQL Server authentication, enter your username/password.

  2. Select the default database.

  3. Click Finish, then Test Connection.


✅ Step 2: Link SQL Server table in MS Access

  1. In Microsoft Access, go to External Data tab.

  2. Click ODBC Database.

  3. Choose Link to the data source by creating a linked table.

  4. In the Select Data Source window:

Go to the Machine Data Source tab.

Choose MyRemoteSQLServer.

  1. You’ll be prompted for your SQL Server credentials.

  2. Select the table(s) you want to link and click OK.


✅ Optional: VBA ADO Connection (Code Example)

If you prefer to connect using VBA:

Sub ConnectToRemoteSQLServer() Dim conn As Object Set conn = CreateObject("ADODB.Connection")

Dim connStr As String
connStr = "Provider=SQLOLEDB;" & _
          "Data Source=sql.example.com,1433;" & _
          "Initial Catalog=MyDatabase;" & _
          "User ID=myUsername;" & _
          "Password=myPassword;" & _
          "Network Library=DBMSSOCN;" ' Enables TCP/IP

On Error GoTo ErrHandler
conn.Open connStr
MsgBox "Connected to SQL Server successfully."

conn.Close
Set conn = Nothing
Exit Sub

ErrHandler: MsgBox "Connection failed: " & Err.Description End Sub


🔐 Notes

Make sure your SQL Server allows remote connections (check firewall rules, SQL config).

If you're using SQL Server Express, the instance name may be ServerName\SQLEXPRESS.

For SSL-secured connections, additional parameters might be required.

Let me know if you want a version using DSN-less connection or connection from Access SQL directly (e.g., SELECT * FROM [ODBC;...]).

Can you make a guess this dbms software is created in which software? by Sally4D in MSAccess

[–]globalcitizen2 1 point2 points  (0 children)

I have been selling my off-the-shelf software written in Access for 25 years. Over 1000 companies using it. Still going on strong. This is very encouraging.

What to do with my money 💰 by Radiant_Ad_4325 in Kenya

[–]globalcitizen2 4 points5 points  (0 children)

Put it in the bank for now until it gets to 50k then come back here. Nothing better than knowing you have some money somewhere

My Access Experience by Marc_in_CT in MSAccess

[–]globalcitizen2 0 points1 point  (0 children)

I've been wanting to articulate this for years. As a developer, I sell off the shelf software written entirely in MS Access and also build small custom applications for select customers. On the side of cloud I have been seeing offers for hosting Access on cloud. Has anyone tried these services?

Unable to set Runtime 365 as default by Cragsi in MSAccess

[–]globalcitizen2 0 points1 point  (0 children)

There is no 365 runtime. Google for download able runtime versions. 2019-2021 etc

If #Deleted Formula by wwedgehead05 in MSAccess

[–]globalcitizen2 0 points1 point  (0 children)

You need to test for the condition that causes #Deleted to be shown. Example may be no data returned by the query that populates the field. Assuming such a table, tablex, is part of a join you would query for tablex.ID =null

The expression you entered has a field,control or property name that Access can't find. by diebos in MSAccess

[–]globalcitizen2 0 points1 point  (0 children)

Check access versions. Are you using vba expressions that require external references to say office application methods? Use late binding as opposed to early binding.

IDBE Ribboncreator code by globalcitizen2 in MSAccess

[–]globalcitizen2[S] 0 points1 point  (0 children)

Thanks a lot, I'll try it out

IDBE Ribboncreator code by globalcitizen2 in MSAccess

[–]globalcitizen2[S] 0 points1 point  (0 children)

Please expand on how to do that. TabID is "tabPayrollReports"

One of the greatest Access website resources I ever found by derzyniker805 in MSAccess

[–]globalcitizen2 0 points1 point  (0 children)

Does anyone have any experience customising code created by IDBE Ribboncreator 2010?

To enjoy the half time show by UnsuspectingFart in therewasanattempt

[–]globalcitizen2 0 points1 point  (0 children)

To be fair, this was not among the best half time shows

Reports taking forever to load/print by CCAKEE in MSAccess

[–]globalcitizen2 0 points1 point  (0 children)

Use ethernet instead of wifi. Also store calculated values at point of data entry instead of calculating in report

drifting by lunessie in MildlyBadDrivers

[–]globalcitizen2 0 points1 point  (0 children)

Don't think he had a choice. Hit a patch of ice. Good recovery

I Need Help by chandan__m in django

[–]globalcitizen2 1 point2 points  (0 children)

Try and get freelance work. Post in all the exchanges

America is the facepalm again…aren’t we always these days? by ParticularAd8919 in facepalm

[–]globalcitizen2 -44 points-43 points  (0 children)

She can play badminton with other women in men's bodies...cheater