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
20 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 ...
0
votes
0answers
11 views

I have field in table that is a URL. I would like to have another table populated with data from this URL [migrated]

I am not an expert at Access or web development. I'm pretty sure this can be done though. In my table, there is a URL to lookup wallet addresses on BitRef.com. I would like data from that webpage (...
0
votes
0answers
11 views

Images aren't showing in gridtable [migrated]

I can't see the image files I included in my asp.net page. The images are put into the linked access database table first, and I also included the images into the same folder as my web application. &...
0
votes
1answer
27 views

Why i can't use table name in subquery?

I have a MS-ACCESS database. When i try to do this query: SELECT * FROM (SELECT * FROM tblClients AS a1 LEFT JOIN (SELECT TOP 1 lVersion, lRequestID AS lVerReqId, lClientId FROM ...
-1
votes
0answers
10 views

Combine empty subqueries

I have a sql query (a1.ID - is the parameter an user inputs using inputbox): SELECT * FROM (SELECT TOP 1 lVersion, lRequestID AS lVerReqId FROM tblClientsVersionsHistory WHERE ID = (SELECT MAX(ID) ...
0
votes
1answer
20 views

How to select maximum row value using optimal way

I have a large table: +----+-----------+------------+--------+--------+--------+ | Id | lClientId | datAccess | lProp1 | lProp2 | lProp3 | +----+-----------+------------+--------+--------+--------+ | ...
0
votes
1answer
67 views

Is it better to have multiple tables with the same primary key or one big data table?

So there is one primary key so far used for IDs of locations. Currently there are multiple tables (sheets) in Excel for the following Events (Location ID, Date, Title, Description) Animals (Location ...
-1
votes
1answer
49 views

How to rewrite IIF and dlookup function from Access in SQL Server as we have recently migrated from access to SQL Server

I need to rewrite the IIF and dlookup part of this query so its can work in SQL Server . I would preferably like the CASE and SELECT statement as SQL Server doesn't have dlookup function so code is ...
1
vote
2answers
63 views

SQL server Login failed for user [duplicate]

My MS Access Application uses SQL Database as backend. The permission to SQL database is granted with Windows Authentication mode to a specific user group. Most of users in the group can get access to ...
1
vote
1answer
17 views

Update query using two tables

I want to update the ProductStock field in tblProduct when this query is run. The ProductStock should minus the Quantity field in tblOrderProduct. (ignore the * sign, I just wanted to see if ...
0
votes
1answer
19 views

Table Diagram and Access File of Contact Database for Church

I have volunteered to design and develop an MS Access database for contacts at my local church in Jamaica, which has no budget to hire a database expert. I have attempted to design a database for the ...
1
vote
0answers
20 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 ...
0
votes
0answers
9 views

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

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 ...
0
votes
1answer
26 views

Microsoft Access Move Multiple Rows In Table1 To A Single Row In Table2

I'm new to Microsoft Access so my terminolgy and understanding are limited, please bear with me. I am interfacing a piece of lab equipment via Serial/ASTM/ODBC to MS Access for Office 365 MSO 16.0.12....
0
votes
1answer
27 views

Combine Multiple Rows Results From Left Join in a unique cell

¡Hi guys!, I don't have any idea how to create a new column that contains all information of results from a Left Join if exists the value Example Table 1 -------------------------------------- | ...
0
votes
1answer
182 views

Backend on server keeps getting into an inconsistent state

I built an Access database. It was originally meant to be for 6 people but I see that it's up to about 20, so that could be the problem. Anyway, the backend gets into an inconsistent state a couple of ...
0
votes
2answers
25 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
1answer
67 views

Database software solution [closed]

Our company has user data (name, email, phone number, systems of access, AD username) in a large Excel workbook. The Excel workbook is becoming very slow because of the 1000s of entries in it, and we'...
0
votes
2answers
57 views

Guidance on strategy for serving files remotely using SQL Server

Thanks for the help. "I" am the IT department for a small business and my ignorance may keep me from asking the right questions so please bear with me. Currently, we are using MS Access ...
1
vote
1answer
42 views

SQL Trigger that creates new table when a new record is added to current table

It's been quite a few years since I have done DB work. I am working through mysql workbench (using MS Access as a frontend). I have a base table that I am multilinking (basically a name index type ...
0
votes
1answer
15 views

how to convert query related to calculate work hours in MySQL to MS Access [closed]

I want to calculate work hours in each day using MS Access.I have query for same thing in MySQL but this thing is not working in MS Access using pdo php. query in MySql SELECT MachineNo, ...
0
votes
0answers
16 views

Need to aggregate data from multiple tables with multiple same foreign keys Access

I need to add coHours and BaseBidHours and then compare to SumofActHours all per CodeID per jobID. See image below. I only loaded everything in to one query to visualize all the tables. Any thoughts ...
0
votes
0answers
15 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
584 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
32 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
16 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
1answer
36 views

Cannot login to a MS Access database

Below is some VBA code to authorize users to login into an MS Access database. I am trying to fix this code and I don’t understand what is the issue in this code snippet. Private Sub cmdLogin_Click() ...
0
votes
1answer
29 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
82 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
19 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
74 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
12 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
15 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
30 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
26 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
5 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
11 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
19 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
24 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
79 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
29 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
117 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
19 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
18 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
47 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
25 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
2answers
26 views

How to show records for a particular month [closed]

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.

1
2 3 4 5
13