Hello everyone, I'm seeking guidance on establishing a dynamic connection within Access 2021. Our goal is to retrieve tables from SQL Server. We're looking to create a system where clients input their company code (Master DB) to link to their respective databases (Client's DB). Following this, they'll provide their login credentials. Any insights or methods to achieve this seamless dynamic connection would be greatly appreciated.
Dynamic connection Access 2021 with SQL Server using code
- Thread starter wardah
- Start date
- Local time
- Today, 11:31
- Joined
- Feb 19, 2013
- Messages
- 17,757
Need to be clearer about the actual requirements if you need anything more that basic advice
Who’s sql server? Yours or theirs? Where is it located? On a server? On the web? How are you distributing the front end? Is the front end a .accdb or .accde? How are front end updates being handled?
there are a number of threads on linking to sql server - here is a recent one
Who’s sql server? Yours or theirs? Where is it located? On a server? On the web? How are you distributing the front end? Is the front end a .accdb or .accde? How are front end updates being handled?
there are a number of threads on linking to sql server - here is a recent one
Create DSN-less connection to SQL Server
I am referring to Method 1 in Create DSN-less connection to SQL for linked table - Microsoft 365 Apps | Microsoft Learn The beginning of the module is as follows '//Name : AttachDSNLessTable '//Purpose : Create a linked table to SQL Server without using a DSN '//Parameters '//...
www.access-programmers.co.uk
Our SQL Server resides on a cloud server, primarily dedicated to managing our collective data. The distribution of the front end involves using an .accdb file. To ensure consistency and functionality, we're exploring various methods to handle front-end updates efficiently. Any suggestions or best practices in managing front-end updates within this context would be valuable.
To establish a connection with the client's database, we utilize information stored in the master database. Based on the company code provided by the client, the respective client database is connected.
To establish a connection with the client's database, we utilize information stored in the master database. Based on the company code provided by the client, the respective client database is connected.
Gasman
Enthusiastic Amateur
- Local time
- Today, 11:31
- Joined
- Sep 21, 2011
- Messages
- 17,413
We used to use something similar in my last place of work. They had a lot of clients and each could only see their data.
Now whether that was all in one BE or in multiples, I do not know.
I suspect all in one, as I used to point out bugs/make requests. To have to copy that multiple times would be a pain, but here I am only surmising.
I believe it was hosted on a windows server and we just connected via a browser, so everything was on the server?
Now whether that was all in one BE or in multiples, I do not know.
I suspect all in one, as I used to point out bugs/make requests. To have to copy that multiple times would be a pain, but here I am only surmising.
I believe it was hosted on a windows server and we just connected via a browser, so everything was on the server?
Similar threads
