Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [ms-access]

Microsoft Access is an application development and database development tool from Microsoft. It combines the Microsoft Jet/ACE Database Engine with a graphical user interface and software-development tools. Other database engines, such as SQL Server and MySQL, can also be used as a database server for Access applications.

For more information:

677 questions
21
votes
3 answers

Access (Jet) SQL: DateTime stamps in TableB flanking each DateTime stamp in TableA

First Words You can safely ignore the sections below (and including) JOINs: Starting Off if you just want to take a crack of the code. The background and results just serve as context. Please look at the edit history before 2015-10-06 if you want to…
mpag
  • 978
  • 7
  • 23
11
votes
5 answers

Full Outer Join in MS Access

I have two staff lists: List A: StaffID Supervisor ==================== 0001234 NULL 0001235 0001234 0001237 0001234 0001239 0001237 and List B: StaffID Supervisor ==================== 0001234 NULL 0001235 …
Ozzah
  • 213
  • 1
  • 2
  • 5
10
votes
3 answers

Query best possible matches and order them

I'm trying to write a query along these lines: select * from tbl where col1 = 1 and col2 = 2 and col3 = 3 order by ... ; I want first all the results where all 3 WHERE conditions match (3/3), then all the results where any 2…
forX
  • 435
  • 2
  • 7
  • 12
10
votes
1 answer

Why would suser_name() not reflect an AD account name change?

One of our users' names was legally changed, so we changed their Active Directory username to match - from domain\oldname to domain\newname. However, when suser_sname() is called by this user in a stored procedure, it returns the old name, not the…
Warrior Bob
  • 471
  • 1
  • 5
  • 15
9
votes
7 answers

Main Considerations When Moving From MS Access Programming to SQL Server

I am a 100% self taught MS Access programmer (main part of my job is programming), I am now building larger databases; still using MS Access as the UI but SQL Server to store all data and do more of the 'work'. In essence my question is; what…
Simon1979
  • 213
  • 2
  • 6
9
votes
6 answers

What is the easiest way to get started using databases with real data?

I have a project that could benefit from using a database, but I have no experience with databases, don't have access to a server, and have relatively little experience working with things living server-side. If I'm going to have to tackle a…
Charles W
  • 193
  • 1
  • 1
  • 4
9
votes
5 answers

Can I be automatically notified of prolonged blocking in SQL server?

About once a week I have to resolve a blocking chain on a SQL Server 2005 database, caused by a long-lived read lock from an Access 2003 front-end. The lock is taken out whenever a user opens a certain form and is released once the user has finished…
Warrior Bob
  • 471
  • 1
  • 5
  • 15
8
votes
1 answer

Normalizing a database without access to source data?

I've started a new role which deals with large amount of related data. Our source of all this data is various Excel dumps pulled from databases we do not have access to. The previous person filling this role used a dozen or so Excel files to gather…
pedram
  • 133
  • 9
8
votes
3 answers

Easiest way to import access db (.accdb) into SQL Server 2016?

I have a .accfb file from an access 2016 database and am trying to import this database into a SQL Server 2016 developer edition instance. While I found posts online discussing using import/export data tools in SQL Server and also migration…
choloboy
  • 235
  • 1
  • 2
  • 7
8
votes
3 answers

How to log data changes in Access at the table level?

I support an Access database for a non-profit organization. We have some issues with data mysteriously changing, and there been some, um, friendly debate over whether this is caused by users who are not the most computer-literate or by some of my…
BenV
  • 4,923
  • 7
  • 40
  • 38
7
votes
3 answers

Online resource for writing Access SQL statements

I am looking for an online resource for writing Access SQL statements. I write queries using SQL because the UI puts limitations on what can be queried. I have been using w3schools for reference, however MS-Access sometimes has slightly different…
Move More Comments Link To Top
  • 170
  • 1
  • 6
7
votes
1 answer

MS Access database in a network

I would like to ask if MS Access database supports working in networks & multi-user access?
Ahmed
7
votes
1 answer

Is it possible to synchronize two ms access db?

We have a flower store where we use MS Access and a client program to work with the database. But this program can work only with one database. We are going to open a new store, so now we have to solve the problem of syncing between the two…
Max
  • 73
  • 1
  • 1
  • 3
7
votes
2 answers

Import from Access .accdb file to SQL Server

How to import data from Access .accdb file to SQL Server? What should I choose in SQL Server Import and Export Wizard? Suppose we choose OLE DB Provider for SQL Server Integration Services, then if that is a correct direction, what should be…
Przemyslaw Remin
  • 241
  • 1
  • 3
  • 7
7
votes
5 answers

SQL queries to only show most recent purchase records for individual food items

I'm working with a food purchasing / invoice system in MS Access 2013 and am trying to create an SQL query that will return the most recent purchase price for each individual food item. Here is a diagram of the tables I'm working with: My…
J. Taylor
  • 379
  • 2
  • 5
  • 17
1
2 3
…
45 46