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

learn more… | top users | synonyms

1
vote
1answer
182 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
23 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
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
0answers
24 views

Is there a public dataset that contains the most commonly used fake email addresses? [closed]

I have a table in Microsoft Access with user data. Some of these users enter in fake emails like "no@noemail.com" or "none@none.com". I need to scrub these types of email addresses so that we only ...
0
votes
1answer
5k 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 ...
-1
votes
0answers
12 views

MS Access Report - Calculating more than one field

I am building Return Parts Access database and on my Form I have 2 fields Restock_Fee_Percent and Restock_Fee_Amount. When I generate Report I want to calculate and Sum extended cost amount into one ...
0
votes
0answers
5 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 ...
0
votes
2answers
25 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
31 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
2answers
122 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
1answer
17 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 ...
0
votes
1answer
37 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
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
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 ...
0
votes
1answer
118 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 ...
1
vote
1answer
14 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 ...
1
vote
1answer
460 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
0answers
47 views

Set-up Record Counter

I have a problem in the receipt DB I am hoping to get some help with. I have to track physical receipts from the database to the binder that houses them and vice versa. The Receipt Table has 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
0answers
12 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 ...
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 ...
1
vote
2answers
32 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
30 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
18 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
0answers
18 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 ...
4
votes
2answers
4k views

Access 2010 linked table - solve the “decimal field's precision” error

I have an Access 2003 database (running on Win 7 64-bit, Office is also 64-bit) that has many linked tables pointing to an Oracle 11g instance through 64-bit Oracle ODBC driver. Most of the tables ...
0
votes
1answer
40 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], ...
0
votes
1answer
34 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 ...
-3
votes
4answers
92 views

Number of movies that belongs to comedy genre and also belongs to animation genre

Given database of the website "eMovies" that manage data about cinema movies. Write in SQL query the number of movies that belongs to comedy genre and also belongs to animation genre. The ...
-4
votes
3answers
166 views

Finding the most common genre for “eMovies”

Given database of the website "eMovies" that manage data about cinema movies. Write in SQL query the most common genre (that have the biggest number of movies) The tables: Actors ActorID ...
1
vote
1answer
48 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 ...
0
votes
1answer
289 views

Why are some of my migrated tables showing “The given key was not present in the dictionary” in WebMatrix's interface?

I'm having an issue while using the SQL Server Migration tool to convert Access accdbs into SQL Server 2014 Express. I am converting the tables using SQL Server Migration Tool and I have a connection ...
0
votes
0answers
28 views

How can I prevent users from accessing certain data?

Here is a screenshot of my database in MS Access 2016: On the left, I have all my tables, queries and forms. I would like to prevent users from accessing these data as well as the VBA code (i.e ...
1
vote
1answer
18 views

Updating a table with a not-joined query

I'm using Access and have a task that I want automated using an query. I have a table (IncentiveAssignments) that lists out all of the Gift Card numbers (GiftCode, all are unique) I currently have ...
0
votes
0answers
30 views

Group by periods in SQL

Each register is an event in a location with an id, but events take place "in clusters" (e.g zero to two events every day from 31/02/2014 to 10/03/2014, all with the same id). I need to detect the ...
0
votes
3answers
29 views

Aggregate and GROUP BY conflict with HAVING?

I don't know if my logic in my query is incorrect, or if I simply have a syntax error, or both. For each customer that had more than two orders, I want to list the customerID and the total number of ...
1
vote
1answer
27 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 ...
1
vote
0answers
568 views

SQL Server 2014 Import Wizard missing data source option

I have already run the upsizing wizard from my production Access 2010 .accdb database to create all the table structures and move the data on to our new SQL Server 2014. This included adding some PKs ...
0
votes
0answers
10 views

Access Database VIewing Area

Somehow I've made my area where the tables, queries, etc too small and I can't find line to enlarge. where can i go to default back to normal view
0
votes
0answers
20 views

Update MS Access table from Constantly changing Excel Spreadsheet

I have an excel spreadsheet that looks something like this: modelNum | serialNum | Data ------------------------------ 478389 | 1Z431G | 4 478389 | 1Z43A1 | 6 438584 | ...
1
vote
0answers
64 views

SQL Server Linked Server with Microsoft OLE DB Provider for Visual FoxPro?

We were having some issues with our old Microsoft Visual Fox Pro ODBC driver that we shoehorned into Windows 7 and is no longer supported by Microsoft and has not been for quite a long time... So ...
0
votes
0answers
26 views

Microsoft Access Form's Combo Boxes Help

I have a database in access and I am creating a form to enter transactions for investors in our hedge fund. The form is supposed to create new records in the table tblTransactionsAccrued. I created a ...
2
votes
1answer
51 views

Distinguishing Records with Related Fields

I'm a newer user (obviously) and would greatly appreciate question writing suggestions as well as answer suggestions: I have a lot of interrelated tables which largely depend on my Products table, ...
1
vote
1answer
354 views

Calculating Open Days field and stopping with status change

I had a question but wasn't sure where I needed to post or view if someone has done this before. I have a dilemma on my hands. Background Info: I have been trying to figure out what to do since I ...
1
vote
0answers
40 views

Database table(s) to record investor activity

I've never asked a question here before. I am currently designing my first database by learning from the web and some books I got, using MS Access to start. I work in operations for a small hedge ...
1
vote
1answer
32 views

Back-end with encription and user-control for MS Access2003-VBA

My client has an Access 2003 "multi-user" (<6) "database" (<3k records) with "encryption" located in a LAN folder and an easy Form I polished with VBA(DAO library). Access 2003 encryption can be ...
2
votes
1answer
24 views

De-duplication method for fields that are identical except for Unique ID

I'm looking for a decent de-duplication method. Basically I have a table which has five fields plus a Unique ID (key) field. I've run a duplicate which detection query which finds any records where ...
1
vote
1answer
111 views

SQL Server Trigger does not update all table records

This is my first question so please go easy on me. We are using Access 2013 as a front-end and SQL Server 2012 with MS SQL Server Management Studio 11.0.2100.60 backend with ODBC connections. I am ...