I have a table named MyTable linked from an external MS Access database (C:DataLinkedDatabasesExternalData.mdb). The table structure includes GroupId, RuleId, and DecisionCode. I need to create a query that lists all entries from this table where the values 10 and…
The goal is to find passengers in a flight database who accumulated 20,000 or more miles. I am asked to find the 10th passenger with the highest total miles. First I needed to create the top 10 list using the…
In my organization, we have an access file in which everyone can add new lines according to the work they do. And now, we adopted sharepoint online to manage our intranet. The file is in a server folder like this:…
I am trying and failing to read a local .accdb file in my Python 3.11 app, which is running in an python:3.11-alpine container. My Dockerfile executes without errors: FROM python:3.11-alpine EXPOSE 5001 ENV PYTHONDONTWRITEBYTECODE=1 ENV PYTHONUNBUFFERED=1 RUN apk update &&…
Small company, limited funds, we will be upgrading our server from Windows 7 Pro to Windows Server 2016. The site has been using Classic ASP connected to an Access (mdb) database, my understanding is that Server 2016 does not support…
I am trying to do a search using an ID to find the information that I need. The database is Access and the ID is an autonumber value(primary key). I am using Visual Studio 2022(visual basic) to to the search…
I'm currently working on a script where I import a .json file into a microsoft access database, so far each field enters without issue, except for one field where the characters are more than 255. To overcome this, i've tried…
I currently have an existing ASP classic app connecting just fine with this code: Set server = Server.CreateObject("ADODB.Recordset") server.ActiveConnection = "dsn=[name in ODBC Data Sources];" I am now trying to write an ASP.NET Webforms app to connect to the same…
the guy from the Baptism database is here again. In Visual Studio it's easy but here I don't get it done. I have form with two textboxes: login and password. I have a button to check the info Both must…
I created an *.mdb file (Access 2002 - 2003 file format) and I added in Access (from External Data tab - Excel) an ODBC DataBase (that I configured in ODBC DataSource Administrator 32-bit to point to a MySQL database server)…