ms-access Archives - IT Nursery

What flavor of SQL is used inside Microsoft Access?

I don’t have much Access experience, and I took on a new Access project. I can use SQL to query the Access databases. … Read more

This question is an extension of Fill percentage of total field with MS Access SQL. I have the following 2013 MS Access SQL … Read more

I have a MS Access query that is based on a linked ODBC table (Oracle). The DDL for the underlying Oracle table is: … Read more

I have created an ODBC connection to a SQL Server 2005. When I link to the tables from MS Access, some tables have … Read more

I have a MySql (5.5) database with a MS Access frontend. If two users are viewing the same record at the same time … Read more

I’m having problems joining three tables. It works well when I use the same query for joining two tables (after removing LEFT OUTER … Read more

I am working with a DB in Access and I’d like to be able to fill the field in this row with a … Read more

I have an Access table called Engagement with four fields: Emp_id, Year, Week, Act_id It records when an employee is/was engaged in an … Read more

I have a MySQL backend, MS Access front-end system that is nice and responsive over a local network but becomes sluggish over a … Read more

I have a table that has the following data: ID Name LastName 1 William Johns 2 John Adam 4 William Smith 3 Mark … Read more