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

learn more… | top users | synonyms

1
vote
1answer
33 views

How to create a form that allows user to enter a variable number of items

I am a total beginner to Microsoft Access 2010. I need a form that allows a user add items from as list to a list. The items can be added until initial list is exhausted. Here's the most basic ...
0
votes
0answers
10 views

Access Database VIewing Area

Somehow I've made my area where the tables, queries, etc too small and I can't find line to enlarge. where can i go to default back to normal view
0
votes
0answers
34 views

Update MS Access table from Constantly changing Excel Spreadsheet

I have an excel spreadsheet that looks something like this: modelNum | serialNum | Data ------------------------------ 478389 | 1Z431G | 4 478389 | 1Z43A1 | 6 438584 | ...
1
vote
0answers
107 views

SQL Server Linked Server with Microsoft OLE DB Provider for Visual FoxPro?

We were having some issues with our old Microsoft Visual Fox Pro ODBC driver that we shoehorned into Windows 7 and is no longer supported by Microsoft and has not been for quite a long time... So ...
0
votes
0answers
28 views

Microsoft Access Form's Combo Boxes Help

I have a database in access and I am creating a form to enter transactions for investors in our hedge fund. The form is supposed to create new records in the table tblTransactionsAccrued. I created a ...
1
vote
0answers
46 views

Database table(s) to record investor activity

I've never asked a question here before. I am currently designing my first database by learning from the web and some books I got, using MS Access to start. I work in operations for a small hedge ...
2
votes
1answer
25 views

De-duplication method for fields that are identical except for Unique ID

I'm looking for a decent de-duplication method. Basically I have a table which has five fields plus a Unique ID (key) field. I've run a duplicate which detection query which finds any records where ...
1
vote
3answers
70 views

Using JOIN statement with a WHERE

This is probably a basic question, but I'm trying to build an SQL query for an access database that returns orders from a certain customer and I want to cross reference the customerID with the ...
1
vote
1answer
167 views

SQL Server Trigger does not update all table records

This is my first question so please go easy on me. We are using Access 2013 as a front-end and SQL Server 2012 with MS SQL Server Management Studio 11.0.2100.60 backend with ODBC connections. I am ...
1
vote
1answer
33 views

Back-end with encription and user-control for MS Access2003-VBA

My client has an Access 2003 "multi-user" (<6) "database" (<3k records) with "encryption" located in a LAN folder and an easy Form I polished with VBA(DAO library). Access 2003 encryption can be ...
0
votes
1answer
44 views

Syntax Error CREATE TABLE Statement [closed]

i am getting a Syntax error in CREATE TABLE statement. Microsoft Access 2007. CREATE TABLE ROOMS ( RoomNum Int Not Null, RoomSize Char(6) Not Null, RoomBedCnt Int Not Null, RoomRate Numeric(18,2) ...
0
votes
1answer
7 views

How do I get a linked list to display more then just the first search item in Access?

I just feel like I'm missing something really stupid. I have a simple access database I'm using for tracking my projects. I have multiple individuals and I have multiple projects. For the project, I ...
0
votes
1answer
23 views

Access 2010 Need help connecting/updating database data

I have a large database that has sporadic fields with incomplete or missing data. Quite the inherited project, I have to say. I'm new to Access, so if you have any ideas on how to simplify this pile ...
0
votes
0answers
25 views

MS Access - Extract Data from Proprietary mdb file

my friend has this "software" that manages financial records, with a lot of user data per record. This "software" is really an access file. To launch it, you use msaccess.exe program.mdb, and it ...
3
votes
1answer
35 views

Create a form solely for inputting data?

I am looking to create a form for a database in MS Access, that will be used solely to allow users to input data into the database. However, all the options I have found do not allow for this, they ...
1
vote
2answers
146 views

How to get MS Access to reach a Linked server on MSSQL

We have an MS Access DB that has been in place for 16 years in a Front End/BackEnd configuration. It is now running under the latest version of MS Access using ACCDB files. Since its inception, we ...
0
votes
0answers
28 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 ...
1
vote
1answer
40 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 ...
-2
votes
2answers
53 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
113 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
414 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
25 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 ...
0
votes
0answers
59 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
38 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
11 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
60 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
82 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
146 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
39 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:: ...
-4
votes
3answers
169 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 ...
10
votes
1answer
194 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
128 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 ...
3
votes
0answers
81 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 ...
-3
votes
4answers
93 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
86 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
25 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
58 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
235 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
27 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
70 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
568 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
165 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
49 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 vice versa. The Receipt Table has the ...
0
votes
0answers
140 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
184 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
15 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 I'...
5
votes
1answer
79 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
285 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
39 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 read-...