Questions tagged [ms-access]

Microsoft Access, popularly called Microsoft Office Access, emerges as a brilliant software solution offered by Microsoft for application and database development purposes. Remarkably, it amalgamates the exceptional Microsoft Jet/ACE Database Engine with a visually intuitive user interface while enhancing the overall experience through an array of advanced software-development tools. Notably, users may even opt to employ alternative database engines like SQL Server, thereby allowing great flexibility in employing Access applications.

Is it possible to use Selenium Webdriver in VBA to interact with a button located within a frame?

I have created an automation script for a webpage that contains frames. In order to complete certain tasks, I need to navigate through multiple menu links before returning to the main content. This automation is executed using Access-VBA. Below is a snippe ...

ms-accessselenium-webdrivervbaframe

Incorrect data retrieved for numeric (integer) fields via ODBC access

Currently, I am in the process of developing an application that requires the importation of Microsoft Access files. This application is built using PHP, and I followed a specific tutorial to configure the environment (https://gist.github.com/amirkdv/96728 ...

phpms-accessodbcunixodbc

single-use date availability checker

I'm currently facing an issue with my code. It seems to be functioning correctly, but only for the first iteration. Let me explain further. If I select a date and time that is already in the database, it correctly displays "date unavailable". Likewise, if ...

c#htmlasp.netms-access

Is there a way to only read from an Access database (.mdb) file without making any changes?

My current code is able to read a .MDB Database and convert it into a CSV file. However, since the database is located in a shared network folder, other users conducting tests are unable to write to the database while the code is running. I am looking for ...

pythonsqlms-accesspyodbcreadonly

PHP script using SQL SELECT query to retrieve records with dates greater than a specified value, including dynamic PHP variables

After reading through various threads on this issue, I still haven't found a solution that incorporates php variables. I am trying to retrieve the first 100 new records after a specific date from my database, but I'm struggling to make it work. ...

phpsqldatems-accesspdo

Error encountered: PYODBC InterfaceError - Cannot locate specified data source name

I am attempting to establish a connection between Python and an MS Access Database using pyodbc. However, every time I try, I encounter the following error message: pyodbc.InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] ...

pythonms-accesspyodbc

Error message "The table 'MSysAccessStorage' does not exist" is encountered while attempting to drop tables from the list generated by cursor.tables()

After successfully connecting to a database and iterating through the metadata to retrieve table names, I encountered an unexpected error message: pyodbc.ProgrammingError: ('42S02', "[42S02] [Microsoft][ODBC Microsoft Access Driver] Table 'MSysAccessS ...

pythonms-accesspyodbc

How can I effectively display personalized information from an MSAccess database on a WordPress website?

I am seeking advice from experienced Wordpress developers. My organization possesses an internal MS Access database that comprises various tables, reports, and input forms. The structure of the database is relatively straightforward, encompassing informati ...

javascriptwordpressms-accessinternet-exploreractivex

Delivering Access data in HTML format via email

In my MS Access database, I have a report that combines client records from one table (including email addresses) with grouped records fetched from other tables using a Query. I want to send this report directly to each client via email, within the body o ...

htmlvbams-access

Utilizing getElementsByClassName for web scraping: encountering inaccurate outcomes

I am attempting to extract the inner text from all classes with the className = "disabled" within the provided snippet of HTML Code: HTML code In my effort to achieve this task using MS Access (VBA), the code I have implemented is as follows: Set IE = C ...

htmlvbams-accessweb-scrapingscreen-scraping