Recent content by wardah

Thanks for the response... Let me explore this solution further. P.S I made a horrible mistake... "UID = sa" :(

Thanks for prompt response. But i do not want to use ODBC driver as we will have to install and configure the correct ODBC driver on clients machine as well. We intend to distribute the frontend as a single installable file with Access runtime.

I'm currently working on pulling linked tables from a cloud-hosted SQL Server into Access 2021 using an OLEDB connection. While the connection appears successful, I've hit a roadblock—I can retrieve and print the names of the tables from the connected database onto the immediate screen, but I'm...

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...

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...

Hey everyone! 👋 Excited to join this Access Forum! I'm Wardah, diving into the world of Access—I might be new, but I've got a legacy to follow! My dad's been an Access whiz for over 30 years. Now, I'm making the leap from Access 2010 to 2021. Looking forward to learning and sharing experiences...