Skip to content
IT Nursery
  • Home
  • Programming
    • Mac / IOS
    • Android
    • Web Applications
    • PHP
    • Java
    • C
    • C++
  • DataBase
    • MySQL
  • CMS
    • WordPress
  • System and Network
    • Serverfault

ms-access

What flavor of SQL is used inside Microsoft Access?

by IT Nursery

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

Tags ms-access

Fill percentage of total field conditional on some other field with MS Access SQL

by IT Nursery

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

Tags ms-access, ms-access-2013

Access not properly translating TOP predicate to ODBC/Oracle SQL

by IT Nursery

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

Tags ms-access, odbc, optimization, top

MS Access displays alle columns in SQL Server tables as “deleted”

by IT Nursery

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

Tags ms-access, odbc, sql-server, sql-server-2005

Concurrency question?

by IT Nursery

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

Tags concurrency, ms-access, MySQL

Joining 3 tables using SQL Query?

by IT Nursery

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

Tags ms-access

IF IS NULL then SINGLE else keep the value of the field

by IT Nursery

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

Tags ms-access

How can I allow part of a key to be null and enforce uniqueness of records with nulls?

by IT Nursery

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

Tags ms-access, null, primary-key, unique-constraint

Database Performance Tuning

by IT Nursery

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

Tags ms-access, MySQL, performance, performance-testing

Compare Two Rows and Find the Difference Between Them Which is In The Second Column?

by IT Nursery

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

Tags ms-access
Older posts
Page1 Page2 … Page5 Next →

Recent Posts

  • Advice for improving internal dashboard [closed]
  • grep : ‘+’ special character
  • File location for Syslogs in Centos machine
  • How to collect users’ task completion times?
  • “service {FOO} start” vs. “/etc/init.d/{FOO} start”? [closed]
IT Nursery
Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

Important Link

  • About
  • Privacy Policy
  • Contact

IT Nursery

The Goal of ITNursery Engaging the world to foster innovation through aggregate information. Our Question Answer post, blog information, products and tools help developers and technologists in life and at work.

copyright © 2023 All Right Reserved | IT NurSery
x
x