Questions tagged [ms-access]

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

Filter by
Sorted by
Tagged with
3
votes
1answer
286 views

Relationship between two multi-valued child tables

Scenario In my system, there are a number of different TradeBaskets. Each TradeBasket contains a number of different Securities. The Securities have a Type, Value, Sector etc... and new Securities ...
2
votes
1answer
6k views

Does MS Access have anything equivalent to triggers?

I'm developing some code that will eventually talk to an Oracle 10g database. While doing this, I am also redesigning the relevant database tables. I'm not a database pro, and I don't have sufficient ...
1
vote
1answer
6k 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
1answer
100 views

MS Access linked table displays short text instead of Decimal data type

I have linked tables in MS Access databases (various versions, 2007-2019) which are connected to SQL server 2017 via Sql server 2017 drivers (eg, msodbcsql_17.2.0.1_x64). Fields that are of data type ...
0
votes
1answer
100 views

JOIN type for MS-Access report query

I have 7 tables, 6 of which are in a one-to-one relationship with a table named SLD joined with SLD_ID. SLD has 17 records and I need them all displayed regardless of matches in other tables. Which ...
0
votes
0answers
10 views

Can MS Access create a field alias within a table?

I have some third party tools that are written by different developers, but they share a common database and it seems like may not be completely synchronized in their activities. Currently, one tool ...
0
votes
0answers
6 views

Why does Access recalculate a stored query when I copy it? Can I tell it not to?

When I copy and paste a stored query in Access, it's usually because (a) I want to back up the code before making changes, or (b) I want to make a new query by making changes to that one. All I want ...
-2
votes
2answers
34 views

Database schema - Set Limit values in correlation to groups and/or it's members

Provided there are pre-existing tables (diagram attached below). They each have numerous use-case as far as potentially related attributes. Still, I am at a roadblock following best practices with ...
0
votes
1answer
1k 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 ...
0
votes
1answer
19 views

Compact Database VBA for an .mdb that utilizes a .mdw security file

The below code works great when you call an unsecured database from another database. But I am trying to compact an .mdb in Office 2013 that has user-level security (.mdw). If I try the below code ...
0
votes
2answers
267 views

Access Web App query 3 Tables with aggregatios - Need a workaround

I'm designing an Access 2016 Web App for inventoring our computers. The problem I have is with a query where I want to get the CPUCore-amount and RAM-Amount for each PC. The computer-value in RAM ...
3
votes
2answers
19k views

How to compact the current MS Access database from VBA function

I want to be able to run the 'compact and repair' process from within a VBA module in the database. I have a batch process that I run occasionally, it drops a few old tables, re-imports them from ...
0
votes
1answer
91 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
0answers
19 views

SQL Query Statement with Group By

I am trying to analyze how far players of the game progress as a function of age. The age is measured as the number of days since game installation. For active players who played the game at a certain ...
0
votes
0answers
24 views

How do you modify query to include additional fields in the results?

I have the following MS Access query: SELECT * FROM (SELECT [cnPart],[desc] as DATA,"desc" as CAT from PartData UNION SELECT [cnPart], [qty], "qty" FROM PartData UNION SELECT [...
0
votes
3answers
4k views

Querying a many to many relationship in access

I have just created a many to many relationship in MS Access with three tables as shown below AE Career Fair - Struc contains a list of companies where the company name is distinct. Office Locations ...
2
votes
2answers
1k views

Splitting 1 record on one table to become two records on another table

I am REALLY very new to this so please excuse my ignorance, but I could really use some help! I've got two tables: BillsFiled and Authors On BillsFiled, there are the columns: ID, Symbol, Filedate, ...
2
votes
2answers
50k 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
362 views

Tables not showing up when linking SQL Server to Access using ODBC connection

I am learning to link the back end of a database in SQL Server express 2016 to the front end in Access 2016. The tables were originally in Access and then I exported them to SQL Server. Now I am ...
1
vote
1answer
94 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
1answer
253 views

How to Export MS SQL DB from Docker-Linux to Access format

I have a MS SQL database which is currently up and running on my Mac within a Docker container that is hosting the Ubuntu Linux version of MS SQL Server. I need to export the database to a format ...
0
votes
1answer
185 views

Setting up relationships properly with the Access UI

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
27 views

MS-Access Beginner Replace Textbox Caption With Combo Box Selection on Button Press [closed]

I'm a complete beginner, just trying out/looking into Databases as more of a hobby, and think Microsoft Access would be an easy way to start with the whole front-end forms and back-end combination. I ...
1
vote
1answer
57 views

How to refer to Field Name with a ? in it in MS Access VBA code [closed]

Simple question, but I am new to databases. I have a field called 'ActorRetired?', and in some VBA code I need to set the value of it to -1. But When I try: Me.ActorRetired?.Value = -1 I get the ...
2
votes
1answer
32 views

Microsoft Access: Using other fields in an Autonumber

I'm trying to use Microsoft Access to start an employee database. However, I want the display of the Employee ID to be the initials and then their number. For example, John Smith with the ID 0002 is ...
1
vote
1answer
41 views

What is MS Access ODBC SQL syntax for a table with AutoIncrement and Memo columns?

I am migrating a full framework .NET app to core. It used ADOX to create an MS Access database and tables. It used OLE DB to populate data. In ADOX, the data type was ADOX.DataTypeEnum.adInteger and ...
3
votes
2answers
3k views

MS Access replace entire table contents

Info: I am setting up a new MS Access database for a small team (~10 person) project. There is a table "A" which is never modified but has relations to another table based on the field "Tag Number". ...
1
vote
1answer
20 views

How to design a query to pop up input with two text boxes in MS Access

I ask this question while I could not find any similar question neither on Google nor DBA Stackexchange, this question might be duplicated. I wrote this query in MS access to check for first name and ...
0
votes
2answers
244 views

Microsoft Access Listbox Query

I have 2 tables in Microsoft Access. Table 1: ID Val1 Val2 Val3 1 a b c 2 e f g 3 h i j Table 2: ID Val Chosen 1 a 2 ...
1
vote
2answers
836 views

Help with Vehicle Service database [closed]

I am using the Desktop Vehicle Maintenance template in access, but i am trying to cater it towards our farms needs. We will be keeping track of the service's done on Trucks, Tractors, Equipment, etc. ...
1
vote
1answer
21 views

Find Max Date from a Distinct Row Then Add Value to a Table Column

Quick disclaimer - I am familiar with Access, but a novice at MySql within Access. I have a table with activity data that I pulled into a query to filter down to only necessary data. The query table ...
0
votes
0answers
23 views

Creating a report with multiple sub-reports, grouped on one field - Microsoft Access 365

I am trying to create an MS Access Report (Microsoft Office 365) with more than 1 subreport, to be grouped under a field called "City". The report is based on a linked table and the sub-...
1
vote
2answers
29 views

Return results with several LIKE and NOT LIKE requirements

I am trying to create a query that selects only a set of values, but excludes other ones. The column I am selecting it's called "Participants" and the values therein are not a single text ...
0
votes
1answer
27 views

How to Stop MS Access From Undesired Cascading Delete? [closed]

When I delete a record from one Microsoft Access table, it deletes the corresponding record in another table. I need to stop that. Table 'items' has ID (the key), item_name, and some other fields. ...
6
votes
2answers
2k 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
85 views

Expressing A Composite Key in a Data Dictionary

I am looking for an example of expressing a "Composite Keys" in a data dictionary. I am using an MSO Access application with a Lecturer Table and Subjects Table where I have taken the ...
0
votes
1answer
30 views

Q: Updating multi table linked view with MS Access

I have an MS Access db with a linked table pointing to an MS SQL server database view. We have been using MS Access as a simple front end to change data contents via this view. The view was ...
1
vote
2answers
4k 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 ...
4
votes
5answers
4k views

What flavor of SQL is used inside Microsoft Access?

I don't have much Access experience, and I took on a new Access project. I can use SQL to query the Access databases. What SQL specification/flavor is used inside Access? Is it the same as SQL Server?...
0
votes
1answer
130 views

MS Access : Navigation pane is suppressed

I received a MS Access form client. It is in access 2007 format. Initially Navigation Pane was not available. Only form was visible. Then I choose options->Current database->checked Display Navigation ...
0
votes
0answers
24 views

Error 2105 on Northwind derived Access database when trying to opening a blank form after changing the table source

I have an Access database which was built from the Northwind template, which is referenced here: https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/downloading-sample-databases I ...
1
vote
3answers
5k views

How to create an Access query to find # symbol into a field?

It seems easy but I'm missing something. I have a MySQL database that is connected from access through ODBC connector. I'm looking for the fields where there are # symbol but I'm getting zero results,...
0
votes
0answers
55 views

Corrupted Access Database

I have a big Access database, with aobout 150 Tables/Queries/Linked txt files/Macros/Modules. I was working today, and then from out of nowhere the database got corrupted. I googled, and forund that ...
0
votes
1answer
31 views

Consolidate / sort / combine / merge data for dummies

I am looking for a non-scripting solution to combine data from 3 different tables (preferably using spreadsheet software like Microsoft Excel but a database would also work e.g. Microsoft Access). I ...
0
votes
2answers
239 views

How to interpret timestamps stored as 10-digit negative integers?

I've inherited an undocumented MS Access database where the date/time values are stored in an INT column and the majority of values I've seen so far are 10-digit negative integers. How do you ...
-2
votes
2answers
4k views

MS Access SQL multiple rows into one row with new columns [duplicate]

I have a table which contains individual test items (responses) from a 20 item test. There is a Person_ID, a Item_Number, and a Item_Response. Example: Person_ID| Item_Number| Item_Response 1 |...
0
votes
0answers
11 views

how to Manipulate duplicated records using access

Using Microsoft Access, I have a number of records that have duplicated field-1. I need to form a query such that the duplicate records get unique ; BUT the next filed-2 data must be seen in columns ...
0
votes
0answers
8 views

Two table left has multiple rows, right has 1 row. Need right table to return value only in left table 1 time

Newbie Here, looking for guidance. Please and Thank you! I have two tables where I am looking to see where Alice (left & right) is forecasted and to what role(s) and to what client(s) (left) and ...
1
vote
1answer
68 views

3 Simple Queries SQL Student Question, Query Errors in Microsoft Access

The First Question is: "List the name of each trip that does not start in New Hampshire (NH)." SELECT TripName FROM Trip WHERE State!='NH'; /* works with State='NH' */ The Second Question ...
0
votes
1answer
21 views

query for showing columns from various tables, grouping and showing calculated field in each row of the result

I am doing a stock management system. In one table I store items: ITEM<br> id_item<br> item_name<br> ORDER<br> id_order<br> date<br> ORDER_ITEM<br> ...

1
2 3 4 5
14