Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [ms-access]

Microsoft Access is a relational database management system that is part of the Microsoft Office suite.

1
vote
2answers
129 views

Are there alternatives to Microsoft Access? [closed]

In my office, we often use MS Access for many applications (eg creating reports, data analysis and data processing) because it is convenient to use (easy data import, fast query building, easy ...
2
votes
0answers
49 views

Troubles inserting new records in linked SQL-server table in Access

Years ago, I upsized the back-end database from Access to SQL-server using the build in tool in Access. It worked fine but in the recent two weeks an error began to appear. This problem occurs for ...
0
votes
1answer
52 views

Access: Making a Pivot Table with Multiple, Same Values as Columns

First post ever, thanks for having me! Currently we have an Access database connected to two access control devices tracking hours for different statuses: Check In, Check Out, Break Out, Break In, ...
0
votes
1answer
15 views

How to Total all Records in a Field?

this is probably very basic but I can't figure it out. I'm trying to total two records to give the output: £2,100 in the Total field but they keep coming out separate. Any help? Thanks.
2
votes
1answer
26 views

Report transition from Access to Crystal (multiple queries)

I have just started a new job where I am responsible for building and improving reports. There is one report I am trying to move from Access to Crystal. The data is stored in an application called ...
0
votes
1answer
32 views

How Do I Query this Data in Access Without Creating a Circular Reference

I have two tables called Events and EventSeasons. Events define the main type of events that there can be, and EventSeasons stores the number of times that the events have occurred yearly. I'm trying ...
1
vote
0answers
15 views

How to use validation rule within database with drop down menus.

Building a scheduling database using access 2013 for my company. I currently have it set up so that only employees that have a rating of 3 or more for the particular job show up when you use the drop ...
1
vote
0answers
23 views

Postresql & Access synchronising

I would like to ask for hints / tips / pointers on the possible approaches that I might use for the following... I maintain a database locally using postgresql 9.5, hosted on a Linux server. However, ...
1
vote
0answers
29 views

SQL Server linked to AccessDB Update statement doesn't work in some scenarios

I have a SQL Server 2014 Express server linked to an Access DB. I am able to SELECT and view data in the access db without issue. However, when I run update statements they don't always work. The ...
1
vote
2answers
29 views

Access fails to group data! [closed]

In this example Query, SELECT [Account Transactions].ID, [Account Transactions].Transaction_Amount, * FROM [Account Transactions] GROUP BY [Account Transactions].ID, [Account Transactions]....
0
votes
1answer
54 views

MS Access - Creating a report based on a pass-through query that requires a parameter

I am attempting to make a report in Access that uses parameters as well as a pass-through query. I'm open to using a temporary table but the guides I can find using temporary tables all use an ...
3
votes
2answers
164 views

Local bus schedule structure/design

I'm Gergo Nagy, and I'm learning databases. My project is a bus schedule program, in android, but I stucked with the database part. My program will include 2 main parts: -If I click on a number of a ...
2
votes
0answers
32 views

Export table from MS Access to Excel while retaining Field Name and disregarding Caption

I have a MS Access Database, with each table containing the data of a particular questionnaire. I am building data entry forms for each of these tables, but as the field names may prove to be ...
1
vote
0answers
24 views

Jet SQL switch — Fill in 'n/a' for blank cells

My query isn't working as I expect it too. I am trying to create best_id and where blanks/null cells are set to 'n/a' . Also I use Microsoft.ACE.OLEDB.12.0 connection via excel to do an internal ...
0
votes
1answer
189 views

Microsoft Access is giving me network interrupted errors

We have just upgraded to window 10 and are using Microsoft Access 2016 (16.0.8431.2110) 32 bit. As a result of this upgrade we now have the issue of intermittent network connectivity issues. My ...
-2
votes
1answer
20 views

MS Access Bound Object Frame [closed]

I made an access bound object frame that has a datasheet form in it. The actual form has more than one row but the one in the bound object shows only one. Any ideas?
1
vote
0answers
60 views

Access Field Data Type Changed

I have several MS Access databases with tables containing fields that were set to the Data Type "Double" with decimal places set to "Auto" Access somehow changed all these fields to the Data Type "...
0
votes
2answers
631 views

LEFT JOIN with WHERE (Microsoft Access SQL)

Given following 2 tables a, b: table a ID job 1 farmer 2 physician 3 bank clerk table b bID ID lang job 1 1 en farmer 2 2 en physician 3 3 en bank clerk 4 2 de Arzt 5 1 ...
0
votes
1answer
34 views

MS Access: Capture ListBox Scroll Event?

An Access 2016 ListBox control has 10 items, only 1 showing at a time. My Goal: when the user scrolls up/down using the scrollbar arrows, I would like the item displayed to be automatically selected ...
0
votes
1answer
26 views

Extend Query to include additional column

I have the following query, which gives me (in addition to other columns) the Direction ID only: SELECT Users.Name, Users.Surname, Transactions.Timestamp, AccessPoints.Description as Door, Readers....
1
vote
0answers
20 views

MS Access 2016 M:N relationships return multiple columns instead of multiple rows from a JOIN

Let's assume a data model like this: Books could have multiple authors as well as authors could have written multiple books. If a book and its authors are selected by the following statement (this ...
0
votes
1answer
26 views

unable to add data to table because related record is required

I have an access database with my work that I am trying to insert into but I keep getting. 'You cannot add or change a record because a related record is required in table 'Projects'.' I'm running ...
4
votes
1answer
619 views

Designing a database which can track stock movements

I work for a manufacturing company which sells machines to customers which have a control unit installed in them. We need to keep track of the locations of all the Machines after they are sold to the ...
0
votes
1answer
39 views

Selecting values from one table which don't exist in the other

I have two tables, one containing a list of all orders and another containing a list of orders that have been invoiced. I have the following query which I'm testing in SQL Server Management Studio, ...
0
votes
0answers
22 views

How to connect to mdb fie

I have a exe file that read and write from local Db file. I check this file with Detect It Easy and it tell me that is mdb file. I can open this file with Microsoft Access, and watch all the tables ...
1
vote
1answer
31 views

Is there a standard database layout for repetitive information?

I was recently tasked with creating a database to store a modest amount of data. I am learning as I go, but my main hold is figuring out the best way to layout the data. The problem is that for each ...
0
votes
0answers
28 views

Challenge Compiling Productivity Metrics from Multiple Tables

My head is bloody from the pounding following countless frustrating hours failing to find a solution to a problem that I know is quite solvable. Please deliver me from the pain. Thank you in advance. ...
1
vote
1answer
40 views

Querying for 2nd highest numeric value

Database set up here (was too large for sqlfiddle): https://pastebin.com/Hd0DbQ5z This is an MS Access DB. I am looking to get the top score as well as the second top score. I have the following ...
0
votes
0answers
27 views

Importing excel table to access in desired format

Excel table data is in following format: S.No. Book No. Book Description Author Location Quantity ----------------------------------------------------------------------- 1 N001 ...
0
votes
1answer
786 views

How can I merge data from an Excel file into an access database with multiple tables? [closed]

I have an access database with many internal tables. Each table is a category of electronic components (resistor, capacitor etc) In all tables, there is a manufacturer part number and a currently ...
0
votes
0answers
32 views

MS Access write conflict XMIN at (2^32)/2 -1

I have several clients running access 32 bit with a postgres database backends. A while ago, almost all the access apps started to return "write conflicts" when the end users would make changes to the ...
0
votes
1answer
22 views

MS Access Query summarizing 2 tables doesn't produce expected output

I cannot successfully create a query in MS Access 2016 that correctly summarizes data from 2 tables with similar but not completely identical fields. I have a fruit market. I buy each type of fruit ...
0
votes
0answers
23 views

MySql to MS Access query conversion

I have a mysql query, which I want to use in MS Access. SELECT company_name, agent_id FROM ( SELECT company_name, agent_id, @rn := IF(@prev = agent_id, @rn + 1, 1) AS rn, @prev := agent_id FROM ...
0
votes
0answers
200 views

MS-Access - “Previous Record” Query

I'm working in an access database with the following fields (and others): Asset; Asset_Date; Start_Date; Start_Time; Office_Stop. Asset is a # field, Asset_Date is text; Start_Date is Date/Time; ...
0
votes
0answers
44 views

Connect Ms Access to Oracle via LDAP

For connecting to the oracle database using sql developer I use the following parameters: LDAP server: xxx.xxx.org:18125:18126 Select Context: cn=OracleContext,dc=xxx,dc=xxx Instance XXXYYY And that ...
1
vote
1answer
64 views

How to Prevent Timeslot Overlap

SQL newbie here. I currently have a 2-table database-"Customers" and "Bookings". This question concerns the "Booking" table, which has 3 attributes this question is about: BookDate BookStart BookEnd ...
0
votes
1answer
25 views

Policies and Procedures Database

I'm trying to create a database for work purpose, and I need you guys to help me. I don't know if my idea possible or not but i want to give a chance to apply it. As the title I want to make database ...
3
votes
1answer
37 views

SQL/Access: Iterate through a query's results to use in another's WHERE clause

Just to preface, I'm pretty terrible with databases in general (patience appreciated). I have a table structured as follows: TEAM |PERSON |GAME |SCORE _______|_______|_____|_____| ...
1
vote
0answers
160 views

How do I get MS Access 2016 to work with SQL Server 2016 where DATETIME columns are involved?

I'm working in an environment that has a lot of apps that are a MS Access 2016 front-end with a SQL Server 2016 back-end. Symptoms: When viewing data from a table where a DATETIME column is part of ...
0
votes
0answers
37 views

How do I set up an Active Directory group to use with DSN-less linked tables from MS Access to SQL Server

I have set up a group in Active Directory. I have added all my users to that group. I have set up a login for the group with default database as mydb. The login is a member of the public server ...
0
votes
0answers
20 views

Sql Server is not recognizing group login [duplicate]

I created user group in AD. Added users to group. Added group login to db. added role to db for group to alter and control with owner sa. Still not able to get Access to create dsnless links to db.
0
votes
1answer
23 views

Im trying to group two queries by year so that it will show the amount of tours done(by count of tour id) in that year [closed]

SELECT [school tours done showing year].[CountOfTour ID], [Visitor Tours Done Showing Year].[CountOfTour ID], Year([Date]) AS [Year] FROM [school tours done showing year], [Visitor ...
4
votes
1answer
393 views

SSMA for Access - Migration Assistant Wizard fails at link tables

When using Sql Server Migration Assistant for Access with the Migration Wizard, all goes well converting an Access (2016) database to SQL Server Express (2017) until I get to the Link Tables step. ...
0
votes
1answer
189 views

Convert MS access to MySQL DB using php

We are creating a system that has a button for converting MS Access DB to MySQL. Is there a way to convert MS Access DB to MySQL using PHP? I would really appreciate any inputs on this one. Thank ...
1
vote
1answer
47 views

MS Access 2000 Application - SQL Server [closed]

I have an old MS Access 2000 application which connects to a SQL Server 2000 database. I need to migrate this database and application to a new server with SQL Server 2012. The Access application is ...
0
votes
0answers
11 views

MS Access 2016 with Personal Geodatabase

can somebody tell me if the latest Access version (2016) works fine with Personal Geodatabase (Arc GIS 10.3.x)? It's ok if I have to open the database in ArcMap. All I want to know is if ArcGIS has a ...
0
votes
0answers
34 views

Database Latest Duplicate Query filter

I built a linked database for work that pulls data from another database to track inventory assets. The original database that I am pulling from compiles data of serial numbers from work performed on ...
3
votes
1answer
474 views

Access “couldn't use … file already in use”

I have an Access 97 database that is used by some software on multiple (up to 4-6) computers (running Windows 7). Once in a while (maybe 1-2 months) something happens where computers on the network ...
2
votes
2answers
318 views

Using Powershell can you insert a macro into Access?

I am using PowerShell to automate an export of an access databse (.accdb) to postgresql. As a step of that I am using a VBA script to convert all the table and column names to lowercase so they play ...
2
votes
1answer
65 views

How to trust trust a document in access via PowerShell so I can trigger my database export marcos

Long story short I'm working on using PowerShell to automate a nightly DB conversion from access to PostgreSQL. In it's more basic form the script does the following. Copies the .accdb file to a ...