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

learn more… | top users | synonyms

0
votes
0answers
13 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
18 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 ...
9
votes
1answer
118 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
22 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 ...
0
votes
2answers
223 views

Concatenate 2-3 table field values in 1 table field in access

I have a project that in Access. The problem is I am a newbie in this application and I really couldn't figure out what to do, I have checked out several ways but am still stuck. I'll be handling a ...
0
votes
0answers
21 views

Undcipherable SQL error [closed]

In a introductory Databases class and am suppose to input the following SQL statement into MS Access: SELECT Count(*) FROM SKILL JOIN CERTIFIED ON SKILL.SKILL_ID = CERTIFIED.SKILL_ID WHERE SKILL_NAME ...
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
1answer
75 views

Linking MS Access 2010 to Outlook Inbox: Including Attachments

I'm trying to set up a MS Access table linked to an Outlook folder. I've been able to use the external data wizard to set up a linked table, but the table seems to only include subject lines and ...
0
votes
0answers
16 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
2answers
634 views

How to export an Access database and import to MySQL?

I am working on a Java project that sources data from an MS Access database, but I want to use MySQL because I have found it to be very easy to manage. How can I export an Access database that has ...
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
8 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
44 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 ...
-3
votes
3answers
126 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 ...
-5
votes
2answers
103 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: ...
1
vote
1answer
46 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 ...
3
votes
1answer
10k views

Joining 3 tables using SQL Query?

I'm having problems joining three tables. It works well when I use the same query for joining two tables (after removing LEFT OUTER JOIN C ON B.No = C.No). However, it doesn't work when I use three ...
1
vote
1answer
305 views

Display a one-to-many relationship in one row

I have a "one to many" relationship in two tables: Table "products" contains: product_id, product_descr Table "packing" contains: product_id, package_id, package_desc One product has often more ...
-2
votes
0answers
34 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
39 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:: ...
1
vote
1answer
310 views

Calculating Open Days field and stopping with status change

I had a question but wasn't sure where I needed to post or view if someone has done this before. I have a dilemma on my hands. Background Info: I have been trying to figure out what to do since I ...
1
vote
1answer
68 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 ...
0
votes
1answer
5k views

Access 2010 After Insert data macro to update another table

I have an Access DB with 3 tables. Table 1 Appointments Fields with Data that is not used anywhere else, but some of the information is inserted into 3 with a after insert Script. Table 2 Usage Data ...
0
votes
1answer
825 views

Allow access to enter data through forms, but not full database access

Using Access 2013 or Sharepoint 2013 is it possible to give someone access to data entry forms that work with a back end database whether Access database or Sharepoint SQL. But from everything I've ...
0
votes
1answer
2k views

MS Access .mdb & .ldb database corrupted

I am using a A.mdb database. You know when connecting the database Microsoft automatically create a .ldb file. Unfortunately my pc shutdown when connecting the database. As a result after restart the ...
1
vote
0answers
18 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 ...
2
votes
1answer
8k views

Linking Fields From 2 Different Tables (Microsoft Access)

I am trying to link 2 fields from 2 different tables on Access but I will give an example to try and make the issue clearer. I have 1 table called "Employee Details" which contains the field ...
0
votes
1answer
166 views

Access 2010 ODBC Connection to SQL Server 2005

I'm trying to code an ODBC connection to SQL Server in Access 2010 and hoping someone can help me, as I've lost the plot. This is my code, it simply accesses one SQL Server database/table and insert ...
1
vote
1answer
151 views

Update Table Query: Automatically handle “Enter Parameter Value” prompts?

EDIT: Here are two database Files that demonstrate an applied example of the problem: Example_DBs.zip (Zipped due to 2 link limitation.) Note: The missing Field in "Not Working.mdb" is ...
0
votes
1answer
136 views

PostgreSQL ODBC and Microsoft Access date/time in aggregate functions

I am trying to replace our MS Access 2003 databases with PostgreSQL 9.3. The first step is to use our MS Access front end to the upsized databases in PostgreSQL. Everything seems to work very well ...
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
votes
4answers
69 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
71 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
0answers
74 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 ...
1
vote
1answer
239 views

MS Access: adding column if not exist (or try/catch it)

this is an easy question, but I can't find out the solution... I have to check if a column exists and add it if the test is negative. How can I do with only sql code? This is the syntax for SQL ...
1
vote
2answers
2k views

Access 2007 sql editor

Is there an ACCESS 2007 JET SQL editor or client (not sure the right term is) that can be used to code Access Jet SQL queries? It is very difficult to write SQL queries in ACCESS 2007 since it's like ...
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 ...
6
votes
5answers
219 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
0answers
116 views

MS Access: Control source vs. record source

I'm trying to understand the difference between a control source and a record source for my MS Access 2010 form. I'm designing an inventory system for food. There is a table for invoices, food items, ...
0
votes
2answers
36 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
1answer
22 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 ...
3
votes
2answers
112 views

representation in ms-access

I have a database in microsoft access. I want to know how to look up a singular datum from a reference table giving a dynamic set of values. Here is a representation of what I mean: I have the ...
1
vote
1answer
306 views

Is it worth time converting Access query to T-SQL query

Let me just say, before anything else, that I am a enormous noob when it comes to databases in general, so please forgive me for my rather stupid thoughts and actions. I had a database built in ...
0
votes
0answers
38 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
42 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
31 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 ...
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
108 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 ...