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

learn more… | top users | synonyms

0
votes
0answers
11 views

How can I make microsoft Access update fields that are linked in several tables?

I am working on a database for clinical observations in cancer mouse models. Usually, the animal care staff reports an observation that the vet checks. Sometimes, we have false positives that I need ...
0
votes
1answer
33 views

Query that compares dates

I'm trying to create a query that shows if students are mature or not, based on their date of birth. However when the query is executed it returns all students as not mature. Any students that are ...
0
votes
0answers
12 views

MS Access 2013 won't pull the data for a specific column when creating a report [on hold]

I am trying to run a report in Access from three different tables, the report pulls the data from all of those tables and all of their columns, except for one - the column appears in the report but is ...
0
votes
2answers
41 views

Query that finds the oldest driver

Given two tables: driver=(d_id,name,gender,birthday,address,country) event_list=(o_id,d_id,odate,oplace) The event list table represent the driving violations of the driver , o_id is the violation ...
0
votes
1answer
22 views

MS Access Run Multiple Queries

I have eight 'append' queries in MS Access 2010 that I want to be able to run. Each query also needs to take one parameter (a project number). I want to run all eight, entering the parameter only ...
0
votes
2answers
25 views

Combine multiple row's records in one row with MS Access Query?

I have a table (name- tbl2) with 21 column but I want to combine multiple rows records in a row by using a unique reference number as below: Table Field and Records Type Expected Result: Please ...
0
votes
1answer
20 views

Create new table values based on partial column value - access

I am trying to remove a ton of unnecessary rows in this table. Currently there are 1.3m of them which are all an individual transaction id - with the country and destination assigned for each which ...
-1
votes
0answers
37 views

Create a database in Access with historical records

I am a beginner at making databases and an approach to this problem would be very helpful. The case is that everyday there is a data dump on an online server. From this server, I have to export a lot ...
0
votes
0answers
20 views

Microsoft Access - Use table from excel to update all other tables in a database

I am working with a database on Microsoft Access 2016 in a small company. What I would like to do is create a table (imported by Excel) and update all related fields in the other tables. The Excel ...
0
votes
1answer
31 views

Beginner Question: Trouble turning a field with comma separated values into a multi-valued field

It's my first time using Access, and I have my first of what I assume will be many questions. Yay! So I imported some data from Excel to a table, including a column with a comma separated tagging ...
0
votes
0answers
9 views

Simple Microsoft access 2000 database to count product quantity

I have made a simple 2 colomn database in microsoft access 2000 (thats what I have to work with). The first colomn is the product name like "pack of paper A4" or "pencil blue". The second colomn is ...
1
vote
1answer
52 views

Combining two queries

I am trying to write code for this query: Find the names of the actors that played at least in one movie since 2000 and where not directors of any movie at this period of time. My thought was to ...
1
vote
1answer
48 views

INNER JOIN for 3 tables [duplicate]

I am doing a small course in SQL during my academic degree, I am very new with this material. I saw Inner joinning 3 tables on StackOverflow, I tried to do INNER JOIN between my three tables, the ...
-5
votes
2answers
108 views

Query that finds the names of the directors that played in movies that they directed

Given database of the website "eMovies" that manage data about cinema movies. Write in SQL query that finds the names of the directors that played in movies that they directed The tables: ...
-2
votes
0answers
38 views

Query that finds the names of the directors that played in movies that they directed [duplicate]

Given database of the website "eMovies" that manage data about cinema movies. Write in SQL query that finds the names of the directors that played in movies that they directed My attempt: ...
-2
votes
0answers
40 views

Query that finds most common genre [duplicate]

Given database of the website "eMovies" that manage data about cinema movies. Write in SQL query that finds most common genre (with the biggest number of movies) The tables: My attempt:: ...
-3
votes
3answers
129 views

Finding the most common genre for “eMovies”

Given database of the website "eMovies" that manage data about cinema movies. Write in SQL query the most common genre (that have the biggest number of movies) The tables: Actors ActorID ...
9
votes
1answer
120 views

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 ...
1
vote
1answer
70 views

Error at line 1, column 25: ORA-00923: FROM keyword not found where expected

I have some code that works in Access but now I want to forward the code to our IT department to make a view in our SQL database. Could anyone please help me convert it so it is correct for normal ...
1
vote
0answers
20 views

Need ODBC connection to postgresql to include materialized views

I have an Access front end user interface that links to tables in a postgreSQL database using the most recent ODBC driver. I can link to the postgreSQL tables and views but can't get to the ...
-1
votes
4answers
73 views

Number of movies that belongs to comedy genre and also belongs to animation genre

Given database of the website "eMovies" that manage data about cinema movies. Write in SQL query the number of movies that belongs to comedy genre and also belongs to animation genre. The ...
1
vote
2answers
79 views

Finding the names and the year of the movies that have at least 5 actors

Given database of the website "eMovies" that manage data about cinema movies. Write in SQL query that finds the names and the year of the movies that have at least 5 actors. My attempt: The ...
0
votes
0answers
17 views

relationships in access

I am making the database design of my website in Microsoft Access 2013 because it has a nice user interface and I believe it will help me understand everything a whole lot better with the UI. I have ...
1
vote
1answer
44 views

Combining GROUP BY and JOIN

This seems like a really simple request, but I can't find the answer. I'll admit that I only have a very limited understanding of JOINs, so it could just be that I just don't fully understand the ...
1
vote
0answers
85 views

Permission Error when creating Linked Server from SQL Server to Access DB

I created a linked server from my SQL Server 2008 R2 64 bit Windows Server 2008 machine to an Access 2000 Database that resides on another server. The Linked server was created with no trouble using ...
0
votes
0answers
22 views

Help creating database schema to build database off

not sure if this is the right area for a question such as this but I am looking to create a database for an IS warehouse who deliver laptops, desktops, monitors and other peripherals to different ...
1
vote
1answer
23 views

“Network connection was interrupted” error with shared Access database

We have an Access database with a split front/back end. The back end resides on a Samba 4.1.6 share with around 15-20 users. Frequently the database will popup with the error "Network access has been ...
6
votes
5answers
227 views

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 ...
0
votes
2answers
40 views

Access Database - Linked Table “Not Responding”

I have an Access 2013 database that has a local front end, and a network based back end. The database works fine for everyone. Network connections are usually pretty decent, so it's not so bad. Users ...
0
votes
0answers
41 views

Set-up Record Counter

I have a problem in the receipt DB I am hoping to get some help with. I have to track physical receipts from the database to the binder that houses them and visa versa. The Receipt Table has the ...
0
votes
0answers
48 views

Update form after append query runs

I have an item table called 350_ITest with ISort = vendor item no and GSort company Item no. I have to assign a new GSort to every new Isort. The form has an unbound field linked to the sub form. If ...
0
votes
1answer
32 views

Pulling data into Access from an external API

[Apologies in advance if this has been asked an answered elsewhere.] I have recently dived into Microsoft Access 2016 to handle a relatively small (but still too big for Excel) database with somewhat ...
0
votes
0answers
8 views

Access - two unique autoincrement values for project/task relations

im trying to make access database from which i will get data into excel sheet which will be shared for multiple users. In database i want to store project and task data (this data are nearly same so ...
5
votes
1answer
72 views

What is the meaning of this operator: *=

I have a very old Access application that uses SQL Pass-Through Queries. This application has been nursed along through multiple server upgrades, and we recently moved up to SQL 2012. I now get a ...
0
votes
1answer
124 views

MS Access: Update data from one table to another based on a choice [closed]

Help! I have a patient form where their referring doctor is chosen and that ID for the doctor is stored in a variable. When I click "Save record" I need it to copy the data form the ReferringDoctors ...
0
votes
0answers
22 views

Composite Primary/Clustering Key vs GUID for Merge Replication scenario

I need to decide on a primary key for my tables in a merge replication scenario (currently one laptop taken into the field during the day while another user works on a desktop; both users need ...
0
votes
0answers
44 views

How can I layout a schema that will track monthly installments?

I'm pretty new to database design and have a beginner's understanding of SQL, mostly simple SELECT statements. I find myself in a situation where I have to create a system that will track monthly ...
1
vote
0answers
45 views

Invoice Number Generation

I started a small business and have created an accounting DB with advice from my accountant. In Part of my business I generate invoices for the same customers every month. I use a unique invoice ...
0
votes
1answer
24 views

Referring to a network location without volume label in VBA for Access 2013

I run a database at work in Access 2013. The VBA corrupted after a day from the amount of people using it, so I attempted to split the database to solve the problem. The split worked after I ...
0
votes
2answers
37 views

What would cause an UPDATE statment to hang when executing from an .mdb file to SQL Server 2008 R2 over ODBC?

Is there anything that would cause an UPDATE statement INNER JOINed between a separate MS-Access linked table and an SQL Server 2008 R2 table to hang, when the values are being set on the SQL Server ...
0
votes
0answers
39 views

MS-Access linked tables Azure intermittent connection failure

I have an MS-Access front-end with linked tables to Azure SQL db. It has been running for about 6 months without any major problems. In the last week I have had increasing intermittent connection ...
1
vote
1answer
69 views

ADO connection suddenly starts failing Intermittently

I have an Access 2010 front end connecting to a SQL Server 2014 back end. I've got SSMS 2014 installed on my machine, and everything was working fine. (Running Win7 64-bit with 64-bit Office.) Long ...
0
votes
0answers
32 views

Convert Access query to SQL Query

I am converting Access query to SQL server. I want to convert below lines to SQL 1. Format (210.6, "Standard") 2. Format (210.6, "#,##0.00") How do i convert it to SQL query. I have tried with ...
-1
votes
1answer
78 views

How do you translate this into SQL Server 2008 statement?

I'm not sure how to translate this from Access to SQL. We are currently using SQL Server 2008. I am trying to migrate Access reports into SQL views. SELECT ...
1
vote
1answer
43 views

Getting intervals between time from all succeeding rows? (Time is in text data type)

NAME DATE TIME INTERVAL a 10/19/2015 5:00 PM a 10/20/2015 5:00 PM 86400 a 10/20/2015 5:30 PM 1800 This is easy to do in Excel. But considering we ...
0
votes
1answer
34 views

Select Unique Fields with Max Values in Each?

I have a table with names, numbers, and timestamps on the data. I want to know how to select a unique instance of each name based on how recent the timestamp is. Addy (text), NW (number), UDate ...
1
vote
1answer
45 views

leading 0 missing in column when exporting to csv

I have a query I export which is then used to import products into our website. One of the ways we help people find products more easily is by using a long and short item code. It's basically the ...
1
vote
0answers
5 views

select Concatenated field in Access Form [closed]

I have Created a Report whith a Listbox which contains concatenated fields: Cname: SELECT tbl_Employee.GID, tbl_Employee.Sname, tbl_Employee.Gname FROM tbl_Employee ORDER BY tbl_Employee.Sname, ...
0
votes
0answers
27 views

Shared access database file connected with MySQL server

Currently I have an access database in a dropbox folder, used by a lot of people knowing nothing of IT and DBMSes (imagine them being grannies that just learned to use access after a course of five ...
4
votes
2answers
246 views

Loop through tables or copy paste

I have to do a migration where I should retrieve data from 40 Access tables, which should contain several of the same columns (but not all, the schemas are different). To make it simpler, I used SSMA ...