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

learn more… | top users | synonyms

0
votes
1answer
6k views

Access 2010 After Insert data macro to update another table

I have an Access DB with 3 tables. Table 1 Appointments Fields with Data that is not used anywhere else, but some of the information is inserted into 3 with a after insert Script. Table 2 Usage Data ...
0
votes
0answers
2 views

How can I get more than one result in an unbound form list from sql query

I have an Access form named frmSearchMenu. In the old code, when I entered a StateID (unbound text), I could open another form, frmSearchSite, and get a list of all records that are related to this ...
1
vote
3answers
245 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 ...
0
votes
0answers
8 views

What is an effective method for populating a Jet and SQL database with a quantity of identical data for testing purposes

I'm testing an application that works with either a Jet or SQL Server back end. Part of that testing includes performance testing, but I don't want to manually populate both databases with identical ...
0
votes
0answers
8 views

How can I transfer a table with unknown columns from SQL to Jet

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
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 ...
1
vote
2answers
155 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
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
1answer
2k 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 ...
0
votes
1answer
116 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
1answer
191 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
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
1answer
22 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 ...
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 ...
-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
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
46 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 ...
0
votes
2answers
166 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
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 | ...
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 ...
1
vote
0answers
87 views

Alter schema of Access 2013 database with linked table

I'm trying to change the schema of an Access 2013 table. I want to lengthen some of the text fields. When I change the schema and try to save I get dialog with Operation is not supported for this type ...
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 | ...
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
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 ...
2
votes
1answer
535 views

Display a one-to-many relationship in one row

I have a "one to many" relationship in two tables: Table "products" contains: product_id, product_descr Table "packing" contains: product_id, package_id, package_desc One product has often more ...
0
votes
1answer
129 views

Update query for Minimum absolute difference in Access [SQL]

I have 3 tables in an Access db. Table_1 and Table_2 are where the source data comes from and I am filling Table_3. Table_1 has the following fields: Acct_Name Amt Table_2 has the following ...
3
votes
2answers
83 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? ...
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 ...
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: ...
0
votes
1answer
1k views

How to export an Access database and import to MySQL?

I am working on a Java project that sources data from an MS Access database, but I want to use MySQL because I have found it to be very easy to manage. How can I export an Access database that has ...
-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 ...
0
votes
1answer
117 views

Linking MS Access 2010 to Outlook Inbox: Including Attachments

I'm trying to set up a MS Access table linked to an Outlook folder. I've been able to use the external data wizard to set up a linked table, but the table seems to only include subject lines and ...
2
votes
1answer
11k views

Linking Fields From 2 Different Tables (Microsoft Access)

I am trying to link 2 fields from 2 different tables on Access but I will give an example to try and make the issue clearer. I have 1 table called "Employee Details" which contains the field '...
2
votes
5answers
131 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
1answer
1k views

Allow access to enter data through forms, but not full database access

Using Access 2013 or Sharepoint 2013 is it possible to give someone access to data entry forms that work with a back end database whether Access database or Sharepoint SQL. But from everything I've ...
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 ...
1
vote
1answer
196 views

Update Table Query: Automatically handle “Enter Parameter Value” prompts?

EDIT: Here are two database Files that demonstrate an applied example of the problem: Example_DBs.zip (Zipped due to 2 link limitation.) Note: The missing Field in "Not Working.mdb" is ...
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
1answer
198 views

Auto increment form field

I am working with a database, with some forms. What I am trying to do is an auto increment field in my form. For example ID -- every time when I type some new record, this field ID should increment ...
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 ...
1
vote
0answers
42 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
15 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 ...
3
votes
2answers
32k views

Merging two Access tables into one

I have mostly identical tables, however there are slightly differences like missing columns in older ones. I want to merge 5 tables into one. Is there any easy way to do this?
3
votes
2answers
248 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
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 ...
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 ...
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
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 ...