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
0
votes
0answers
15 views

getting all files into one database [closed]

so i have got around 50 acces files wich contain some data that data has exactly the same structure i mean tables are the same i just posted the images to show they are the same however they all ...
0
votes
1answer
17 views

MS Access, two separate multiselect lists: appending selections of each list to the same rows of the same table [closed]

I have the two pictured separate multi-select lists, set to 'Extended': The list on the left with label 'Select Lock and Key IDs:' is called list_keyIDs and the list on the right with label '...
0
votes
0answers
10 views

How to optimize storage of sales details with multiple products in each sale in Microsoft AccessDb

I have created an accdb with customers and products tables. Now, I want to know how to store the sales order details in the Sales table, WHEN each sale has multiple products, each with different ...
0
votes
2answers
45 views

Split a string into multiple rows and get the count for each of them

I have a table "Production Database" in Server. I am using MS Access as a front end interface. I have some forms there. I want to create a query which will split records in "Reviewer" column and give ...
1
vote
1answer
27 views

How to move geographical data from MS Access to SQL Server

For 20 years I've been working with MS Access, with much VBA involved. I have a lot of geographical data in Access and I'm preparing to move to SQL Server because it supports geographical data types, ...
0
votes
0answers
10 views

Access Database for Capacity Management

I am designing database using Microsoft Access for capacity management. I have different types of equipment and need to track the power usage by every month. For instance, I have HVAC system and ...
0
votes
0answers
6 views

cant login to the ms access database

Below is the vba program to authorize to users to login into ms access database. I am trying to fix the below code and I don’t understand where is the issue with the below vba code. The debugger in ...
0
votes
1answer
26 views

Small site / online database [closed]

I have to develop a small website and I wanted to understand which language to use. The main purpose of this site is to access various tables, for example customer table, orders, warehouse, etc. by ...
0
votes
0answers
6 views

Get contents of LDB file

I have a dektop app which is generating content in a table format and displays 10 rows at a time, which I can export to a csv file or copy/paste. The table has 10,000s of rows so I am trying to find ...
1
vote
0answers
16 views

Rolling multiple rows into single row

I need help getting multiple rows of data to all pull into one row based on a primary key. I have four teachers rating a student's academic and behavior performance through the year. At the end of the ...
0
votes
1answer
16 views

How to convert columns into rows in MS Access [closed]

Please help me to understand, how to convert columns to rows in MS Access. I have the below table, I would like to convert as the below result table. NoOf_A NoOf_B NoOf_C NoOf_D 200 300 400 ...
0
votes
1answer
10 views

How to create columns with Count and percentage using MS Access Query

I have a data table below, I would like to create a query to produce a result table like below, with count and percentage, using MS Access Query. I am unable to create this. Name Alex Alex Bob Bob ...
0
votes
0answers
9 views

Combine information on multiple rows with the same key, into one row with the information in the cells next to it in a query in microsoft access

basically what this guy did here: Combine multiple row's records in one row with MS Access Query? but in such a way where its from: Case Number / Insurance 00001 / BCBS 00001 ...
0
votes
0answers
27 views

how Access can communicate to SQL without using ODBC?

Access will be the front end but I don't want to use ODBC on everyone's PC. Do you have any suggestions on how Access can communicate to SQL without using ODBC?
0
votes
2answers
24 views

MS Access with MySQL [closed]

My current team of 20 people use an Access database front end on their desktop. The backend of the access database is on a network drive. I have been asked to create a Access database front end with ...
0
votes
0answers
4 views

Return only unique values when concatenating fields in MS Access Report

How can I show only unique values when concatenating 2 field in an access report? The code would need to be case insensitive. Let's say that if the values are the same, the first value will be kept. ...
0
votes
0answers
9 views

MS Access - used locally, want to move to use remotely

In my company we have an (old) MS Access software. (Used mainly to manage customers & invoices). In the software it's possible to choose the data file to work against (.mdb file). The goal is to ...
0
votes
0answers
7 views

Access database on Azure Files

Would an MS Access database, hosted on an Azure Files share, work essentially like an Access database on a Windows Server share?
0
votes
0answers
11 views

How to prevent read-write overlaps in split MS Access databases

Consider the following scenario (it is contrived to highlight the potential issue): I have a backend.accdb MS Access DB that contains all data tables. Let's consider this to be an address contacts ...
0
votes
1answer
23 views

Speeding up linking Oracle tables in Microsoft Access

Many people in my office use Oracle tables by linking them in Access (either 2010 or 2016) databases. They always complain about the fact that, when Access is about to present them the list of tables ...
0
votes
1answer
18 views

Concatenate in MS Access - how to omit space and comma if first value is missing?

I am concatenating 2 values in a MS Access Report: "Method" and "Experiment" and they are to be separated by a comma (,). I have figured out how to concatenate succesfully when the second value is ...
0
votes
1answer
32 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
22 views

Confusion about charset for connected tables from MS Access

I run 10.4.12-MariaDB on Windows10 and I use 64-bit ODBC driver to connect tables from MS Access to MariaDB database. I am simply glad that it works (!). But going deeper and working more with ...
0
votes
0answers
31 views

MSSQL Express: linked server from Access database on network path

I run Microsoft SQL Server Express 64-bit version 14.0.2027.2 (X64) on Windows 10 Pro 10. I have trouble to set the appropriate network UNC path and other settings for the linked server. My ...
1
vote
1answer
11 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
0answers
14 views

How do I link two Access Tables so if one Table gets updated both will?

I have an access database with a table that is linked to an excel sheet. I also have a duplicate table with the same data linked to a postgres database. My goal is to either link these two tables in ...
0
votes
2answers
26 views

Find rows without matching second field for given constants in first field

Consider an example table with two string fields FIRST_NAME and LAST_NAME. For a given Lastname == Smith, I find to expect a row with another given Lastname == Johnson and identical Firstname. How ...
0
votes
1answer
22 views

Creating a database link from Oracle Cloud server to remote access database

I work for a small company that currently use Apex to run reports on our accounts system. Oracle is installed on our local server and part of the data is gained via a database link to an access ...
0
votes
0answers
20 views

Issues with updating MS access table with data from another table

I have a table in a MS Access DB that currently has a bunch of Alpha codes. I need to switch those to be numeric ones. I have another table that acts as a code directory. I'm trying to update the ...
-1
votes
1answer
17 views

How to show records for a particular month

Show the Sales, Profit and ShipDate fields (only) of any records from the month of January (any year) where Region and Province are both Ontario.
0
votes
1answer
17 views

Single Column index or 3 column index in MS Access

I am creating a table with a single memo field and either 3 text fields (tablename, fieldname, caseID) or a single text field with the 3 text strings concatenated. There will be a single NO ...
0
votes
1answer
26 views

How can I import multiple .xlsx and .xls files into multiple tables in Access?

I have 100 .xslx and .xls files with different formats and I need to import them all separately into Access keeping their original file names intact. Folder example: C:\Users\username\Desktop\...
0
votes
0answers
21 views

MS access >2gb and inaccessible: Can't be repaired followed by 'Object invalid or no longer set'

We have added 2 queries that should drop and load tables into our DB. For an (at this time) untracable 'mistake', it is likely that the queries only loaded and did not drop any tables to end up with a ...
0
votes
0answers
19 views

How do I set up a report that shows number of clients by age group when their age is stored by date of birth in Microsoft Access

I am working on setting up a new database in Microsoft Access for a food locker it will be used for client input as well as tracking client visits. One of the monthly reports they need is how many ...
0
votes
1answer
33 views

Manipulating duplicate records in access

I have a table with data as follows: Field1 Field2 Field3 10 10 20 10 20 10 30 1 0 20 1 1 20 1 20 1 30 2 2 30 2 30 2 My goal is to ...
0
votes
0answers
70 views

ODBC in Access working but not in SQL Server

I have a postgres database running on a remote server. I'd like to be able to query it in SQL Server. I downloaded the ODBC Driver for postgres and created a system DSN which successfully runs a ...
0
votes
0answers
16 views

SSMA for Access - Migration Assistant Wizard remove password prompt after linking table

Hello used SSMA to create a linked table using SQL. Is there a way to remove this password prompt after opening the table in Access ? I tried adding the username and password in the connection string ...
0
votes
0answers
31 views

OPENROWSET link from Access to Excel

I am trying to use Microsoft Office 12.0 Access Database Engine OLE DB provider to query an XLSX file with OPENROWSET. An attempt to query just spins in SSMS without error, failure, or a result set. ...
0
votes
1answer
66 views

how to find min max of sum?

hello everyone i try to find minimum and maximum value of SUM(units_sold) i test some ways but i can't find best solution please help me ! SELECT TOP 1 dp.product_name, SUM(fs.units_sold) AS ...
-1
votes
3answers
51 views

Query for showing missing years

I have a question about showing the missing values by a query. Given table named Top2000 with fields Artist, Title, Ranking, Year, the following query... Select * from Top2000 order by Artist, ...
0
votes
0answers
24 views

How can you effectively visualise a complex relational database?

I have an Access database which contains all the data from an open-source Japanese dictionary, JMdict. The database contains 24 linked tables, so reading it is complicated. The reason for this is that ...
0
votes
0answers
50 views

MS Access front-end cannot modify records when connected to MySQL

I migrated my Access tables to MySQL hosted server and linked the tables back to MS Access front-end and now I cannot edit the records in my forms. I can see the data and go between records, but I ...
0
votes
1answer
38 views

ms-access concat a string with control source

Sorry for this likely noob question but I cannot seem to find the solution. I'm trying to modify an existing field on a report, standard in this field the data is being pulled from the control source ...
0
votes
2answers
26 views

Best way to enter data in DB that is spread out date wise

I have an Excel file that, to keep it simple here, has 3 columns: ActivityID, ActivityName and TotalHours. TotalHours column is basically all the hours allotted to that specific ActivityID and the ...
1
vote
0answers
50 views

SSIS to import tables from Access DB to SQL

im trying to design an SSIS package to import 80 tables from Access DB into SQL DB, I have done it through the export and import wizard then saved the SSIS package but i didnt like the way the package ...
0
votes
0answers
21 views

Word file running an SQL command - How do I find the source SQL database?

A word 2013 file has a merge function that activates whenever this is open and it is "SELECT * FROM 'database'". As the final results have errors (the final word document feeds from the wrong field ...
0
votes
1answer
30 views

How to update a yes/no field to yes when all related fields in another table are marked yes

I'm new to database stuff (read: database idiot) and I am using Access. I have a table (let's call it "projects") that has a list of projects and one the fields (let's call it "actions_complete") for ...
0
votes
2answers
43 views

What's an alternative solution to using a null value for a foreign key field?

I have a few tables in my database which contain a Foreign Key field linking to another table. The problem is, the value for that field isn't always going to be present, and so sometimes I might have ...
0
votes
0answers
26 views

1 table with 2 same foreign keys to 3rd table with Primary Key

First time building a database in Access. I've been searching, but I did not find something to solve my question, so I finally decided to ask. It may be a really stupid question but what is the best ...
0
votes
2answers
103 views

How can I insert a record into a table that depends on a foreign key linking to a previous table?

Following on from this question. I have a dictionary file written in XML. I've written a program in VB.NET to parse this file and store all the data in Class objects, and now I want to write a ...

1
2 3 4 5
13