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

learn more… | top users | synonyms

0
votes
0answers
2 views

How can I transfer a list of tables from SQL Server to Jet in SSIS

When supplied with a table name in a variable (e.g. "SHIPPING"), how can I use SSIS to pull data from that table in SQL Server and push it to a Jet database into a table with the same name and data ...
0
votes
0answers
9 views

Issue with Relationships in Access Overview

I am currently working within Access 2013. I have a simple task that has been really driving me crazy these past few days, as I thought my relationships where correct. But when adding more data into ...
0
votes
0answers
11 views

Database and internal website [on hold]

I wanted to know what are the different possible ways of creating a database using an internal website. I want to make workers enter some data in a form on a tablet and that the data is directly ...
0
votes
0answers
17 views

UNION Query rendering 2 columns

I am using Access 2013 SQL. I have the following query qry structure: SELECT TOP 10 [Sub Category] AS Category_1 FROM tbl WHERE [Category]='1' GROUP BY [Sub Category] ORDER BY SUM([Value]) DESC; I ...
0
votes
0answers
13 views

Access 2013 and VBA

Guys just joined and i have the problem and i hope you guys can help me. I have two tables one called File Cabinet Table and Request Table, and three forms In-Take Re-retrieve and request. Basically ...
0
votes
0answers
5 views

How to group and number query results with a resetting counter

I apologize for the quality of the title and the following description since I'm having a hard time explaining (and searching for) what I need. I have a query that returns a list of customers and ...
0
votes
0answers
5 views

Msaccess Duplicate entry check for date [migrated]

Good morning, Please I am trying to write a VBA code on msaccess to validate the data entries to avoid duplicates on a fault log database. it works for the stLinkCriteria which is a string datatype (...
0
votes
1answer
45 views

EXEC xp_dirtree

I developed a stored procedure with a call to this extended SP EXEC xp_dirtree @path, 1, 1 Database: SQL Server 2008 R2 Express I run the store procedure from difrentes sources: ASP. Net with ...
1
vote
0answers
15 views

#deleted in all fields using ODBC driver between PostgreSQL and Access 2013

I planning to use MS Access (2013) as a front end to a PostgreSQL database server (version 9.5.2). However, when updating a table in Access the new row appears with “#deleted” in every column until I ...
-1
votes
0answers
14 views

msaccess data duplicate entry for date (Date/Time) [closed]

I am trying to write a code to validate the data entries to avoid duplicates on a fault log database. it works for the stLinkCriteria variable which is a string datatype (short text) but not for ...
0
votes
0answers
13 views

Multiple Criteria in Count not working properly

I am trying to create a count query in Access 2010 that counts a column where the parameter Spot in the CityData table is equal to 'Y' and where the last entry in the FeedOut parameter in the ...
0
votes
0answers
14 views

Merging 3 tables in Access

I have three tables in Access. I want to merge them together removing all duplicates however there are many blank records under the FirstName and LastName tab. The common columns between the three ...
0
votes
3answers
41 views

Access: How to Combine Data from Two Rows in a Query

I have a base dataset formatted like the one below. Sex1 | Sex2 | Number| F | | 5 | M | | 8 | M | F | 5 | F | F | 3 | ...
1
vote
0answers
17 views

Create multiple rankings and a table

Here is my problem: I am using SQL for Access 2013; I have a table tbl with some fields Category, Subcategory and Value: Category | Subcategory | Value | | C1 | ...
-1
votes
1answer
24 views

How to take a field value and use it as a parameter in a URL

So I am trying to implement an automatic search of ebay completed listings of an item, based on the value of a field in my table. I am using access and I cant work out how to do this. I have tried ...
1
vote
0answers
35 views

UPDATE based on the occurence of the same string within two other columns

I am currently using Microsoft Access 2007. I wonder if there is a way to find whether two specific columns in one table contain the same (undetermined) string. The table may look as follows: ...
3
votes
0answers
45 views

ODBC Connections locking tables in SQL Server

We have an ERP system that is a little less than modern, the backend is currently sitting on a SQL Server 2008 R2 installation. We have through mandate of management (isn't that always the case) the ...
3
votes
2answers
82 views

Am I doing a security breach if I am connecting a MS-Access front end (multiple computers) to a SQL Server back-end?

I have a MS Access frontend that I would like to install on 5-7 computers, so they can access a SQL Server stored on a shared network drive: If possible, is it safe and can my data be corrupted? ...
0
votes
1answer
18 views

Where clause returns null, but need to return 0

Need an SQL Statement for the following: Table a partID partNumber Table b partID purchased SELECT a.partNumber FROM a WHERE (SELECT SUM(b.purchased) WHERE b.partID=a.partID) > 0 If ...
0
votes
0answers
21 views

With regards to an ms access to sql migration

I am aware there is lot of information on the web about how to migrate from an access database to a SQL one. However most of the tutorials are about moving from MS Access to MS SQL Server, what If I ...
0
votes
0answers
14 views

Generating a formatted Excel datasheet from Access data [migrated]

The title basically sums up my question. Essentially I'd like to generate a formatted excel sheet from access table data with the click of a button in my form. I know you can export access data to ...
0
votes
1answer
24 views

Sharing Front-End Access Database

I have an Access back-end database with tables, queries, reports...and I have an Access front-end database with a data-entry form that will be used by 3 users. Both back- and front-ends are in same ...
1
vote
0answers
40 views

Access 2010-2016 Compatibility Error

I was just updated to Access 2016, while my users are still at Access 2010. I opened our database in MS Access 2016 once, didn't make any changes, and closed it out, and now all the users are having ...
1
vote
0answers
12 views

How do I hide the “read …save as” notification for an accdr file

When I make the accdb file to an accdr file and open it with Access 2010, the database is created with Access 2010 and OpenGateSoftware’s UI builder. I get a notification bar at the top saying: Read ...
0
votes
1answer
21 views

Query showing a number instead of the column value

I have a query (query_clients) based on a table (Person). One of the columns I am pulling is a StateAbbr column, which is a lookup to the StateAbbr table. The primary key in the StateAbbr table is the ...
1
vote
2answers
242 views

MS Access Unable to Select Number Field Size

I'm using Microsoft Access 2016 32bit on Windows 10. My issue is the Field Size property list is empty for the Number data type. Why is this empty? How can I change a number's field size? I am trying ...
2
votes
5answers
130 views

How can I allow part of a key to be null and enforce uniqueness of records with nulls?

I have an Access table called Engagement with four fields: Emp_id, Year, Week, Act_id It records when an employee is/was engaged in an activity. Each field is Number and each makes up part of the ...
0
votes
0answers
22 views

Modify records in a query list and adding back the modified records into the master table

We have a MS Access 2016 database. We queried the DB to find some parts in inventory. The first few rows of the query results are below. We have a primary key called DBID with a unique number for all ...
3
votes
2answers
247 views

Non unique one to many relationship

I am a noob to database design so bear with me. I have two tables in Microsoft Access: Table 1: | ID | Field1 | Field2 | |:---|--------|:-------| | 1 | A | 1 | | 2 | A | 2 | | ...
0
votes
0answers
19 views

How to cascade the creation of a record through a relationship?

I am attempting to cascade the creation of a record through a 1-to-1 relationship in Access. Does anyone know if this is even possible? I have two tables, TableA and TableB. I also have a 1-to-1 ...
1
vote
1answer
28 views

Search a Table for a Lack of Records

Please understand this is not my field. I have inherited an access database from a previous employee. I have a database which logs training so I have 1 table with employees names trade etc. I then ...
1
vote
1answer
45 views

SQL query to check a table against a “rules table”

I have a table PIT that looks like this: PIT_TYPE PIT_STYPE PIT_APID 1 1 1313 1 7 1313 3 25 1316 247 1 1318 247 ...
0
votes
1answer
49 views

How to connect to a password protected Access 2010 database from SQL Server 2014 x64

I have the following situation: An Access 2010 database (.accdb) on a shared folder of a remote server. A domain account that can access the shared folder and files. A SQL Server 2014 x64 running on ...
0
votes
0answers
10 views

MS Access - how to specify frontend settings

I would like to set the direction of data pushing of backend end fronend Access files. There is on central backend. There is a forntend for each user. When a user edits his frontend, the ...
-1
votes
2answers
32 views

Tryng to use and or queries

In MS Access, I have a table with six columns. A name and (let's say pets) so the columns are marked cat, dog, fish, rabbit and hamster. I want to do a query that I can check cat and it will show all ...
1
vote
0answers
36 views

Distributing MS Access Database

I develop an application that saves records in MS Access DB. Each user has it own DB copy on his local machine, and there is a central DB that reflects all the copies from everyone. The central DB is ...
0
votes
1answer
34 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 ...
0
votes
0answers
23 views

Calculate total number of faults that occurred today?

I have created a database application in Access that can be used to view fault reports that have been logged against a computing department's inventory. So far I have created queries which enabled the ...
1
vote
1answer
16 views

Is DISTINCTROW in MS-Access the same as selecting all the fields and doing a group by on all of them?

I was looking though some queries in MS Access, and I found an SQL keyword I was unfamilar with called DISTINCTROW, from what I can tell, it's the same as an SQL GROUP BY which includes all the fields,...
0
votes
1answer
38 views

How to create a table in access and automatically fills it with information from a query? [closed]

Is it possible if I create a table that will lookup for a value filtered from a query (consult), in this case is duplicated "Name"s from a Employees registring table and automaticly fills up that ...
0
votes
0answers
13 views

Using Microsoft Acess from remote computer

I work for a non-profit that has a part-time worker who works from her home, and she needs to use a Microsoft Access database that we have on our network. I'd really like to stay away from VPNs, and ...
1
vote
2answers
38 views

Help with Access many-to-many relationship (beginner)

I'm a beginner with MS Access hoping for some help with a database I am trying to create. This is (will be) a database of land parcels in a given area, and their associated landowners. Here are my ...
0
votes
1answer
66 views

MS Access Data Type for time in hh:mm:ss format

My database contains three different sporting events with finishing times imported from an Excel spreadsheet in the hh:mm:ss format. How do I customize the Access data type field to accept this ...
0
votes
1answer
35 views

Can't list columns or query in MS Access 2003 linked server in SQL Server 2008 R2 using Microsoft Jet 4.0 OLE DB Provider?

I can however list the tables... If I run Exec sp_tables_ex 'LSTest' I get a result with a list of tables. But if I run Exec sp_columns_ex 'LSTest', '<one of those table names>' I get an ...
0
votes
1answer
42 views

SQL Server accepting Access queries?

I am currently working on migrating a legacy codebase from VB6 and Access to VB.NET and SQL Server. I have run the Microsoft SQL Server Migration Assistant successfully and populated a SQL server ...
0
votes
1answer
31 views

Restrict Front Ended User access to Form entry only

I have a front end database that I want to restrict user access to only enter data into a form. I do not want them to be able to scroll through other entries via the form. How can I restrict this in ...
0
votes
1answer
76 views

Remotely Connect to MySql from MS Access

Does anybody know if it is currently possible to remotely connect to a MySql server from MS Access? What does one need to do to go about doing this?
0
votes
1answer
20 views

Records creates double entry, should only be one

Need an assist on a database design. I'm creating a system to track students in a course. Currently, I have courses. Courses are made up of modules. A given module can be in multiple courses (eg 2 ...
0
votes
1answer
47 views

VB.Net error with CASE SELECT

The following VB.Net code runs fine on SQL Server but gives an error on Access: sql = "SELECT sr.itemcode, sr.itemname, SUM(CASE WHEN sr.transdate='4/14/2016' THEN sr.temunits] END) AS [Units Sold], "...
1
vote
1answer
49 views

How do I calculate a field based on multiple non-numeric records

I have a several tables that I have joined together to get raw data. Some information about my query in the most basic form: Table1 has a column [FacilityID] that is a unique identifier in that ...