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

learn more… | top users | synonyms

0
votes
1answer
761 views

Grouping and counting rows by existence of matching criteria in any of several columns

Disclaimer: I've inherited a database which is probably not quite as "normal" as I would like, and I'm limited to Jet/MS Access 2010 for my db backend and interface, as well my choice of reporting ...
0
votes
1answer
1k 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 ...
1
vote
0answers
14 views

Microsoft Access Export to Excel

I have an Excel spreadsheet that is filled with a ton of data which is organized by column (a column for names, a column for occupation etc.). I have recently moved all of this data into Microsoft ...
0
votes
1answer
172 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 ...
3
votes
1answer
46 views

Any reason not to add 'rowversion' column?

The TechNet article, "Optimizing Microsoft Office Access Applications Linked to SQL Server", recommends adding a rowversion column to SQL Server tables linked from MS Access. From the Supporting ...
0
votes
1answer
198 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
9 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 ...
1
vote
1answer
21 views

Basic Access database help [closed]

I am trying to create a basic database using access but I'm just learning at the minute. I have a text file which contains, customer account code (contains duplicates), customer address type, ...
0
votes
0answers
14 views

Removing Replication from MS Access mdb file using External Data->Access, is anything lost?

The new version of MS-Access 365 does not support replication as evidenced by the following error message: "The current version of Microsoft Access does not support replicated databases. To use ...
0
votes
1answer
3k 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
5 views

Part of query is not properly performing in access design view(2010)?

So, I have been trying to figure out why this query is not running in the design view properly. I am trying to create a list of IDs of individuals who have an invoice(Gift table) between 1/1/2014, but ...
1
vote
1answer
2k 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 ...
3
votes
2answers
76 views

Best design for a tree-like structure database

I'm designing a database in MS Access which is used for tracking the locations of a variety of chemical solutions, made in batches. Each batch can be split (aliquoted) practically indefinitely. That ...
0
votes
0answers
25 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 ...
1
vote
2answers
26 views

Trying to design database for eSports Teams - Issue with dependencies

I am trying to design a database in Access for an eSport league (specifically League of Legends North America). I will post what I have and then explain my issue. My issue comes when I try to ...
3
votes
1answer
3k 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
2k views

VBA Maximize Access Application Main Window

I need my access application window to open up in full screen. I have tried using: DoCmd.RunCommand acCmdAppMaximize and DoCmd.Maximize (which I think only maximizes a Form). Neither is working ...
2
votes
1answer
22 views

Adding two columns results in concatenation instead of addition

I need help using addition. When I do it populates using the concatenate function. I used the following in my access database Total: [ANTI TERROR]+[Records] and instead of returning 1 + 1 = 2 it ...
0
votes
2answers
2k views

Sum of different values on the same row in a table

I have a table with numbers from 0-5, under different field names (Score1, Score2 etc. all the way to Score50) that need to be summed at the last column of that same row. Each row represents a ...
1
vote
0answers
14 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 ...
0
votes
1answer
23 views

Access 2010 ODBC Connection to SQL Server 2005

I'm trying to code an ODBC connection to SQL Server in Access 2010 and hoping someone can help me, as I've lost the plot. This is my code, it simply accesses one SQL Server database/table and insert ...
0
votes
1answer
22 views

Rounding mixed data types

I have a column with a mixture of letters and numbers, and I need to round only the cells that contain numbers using SQL. I currently have my data saved as strings only, and when I try to use a round ...
1
vote
1answer
34 views

Access Data stored in SQL Server

I'm currently working on a project to convert our Access Apps to store the table data in SQL Server. Using SSMA to migrate the data results in the foreign keys and Look-ups work as expected in ...
0
votes
1answer
17 views

How to prevent #Error values derived from Nulls in an outer join

Suppose I have two tables to outer join Tab1: ID Nam 1 Joe 2 Moe 3 Flo Tab2: ID Val y w 1 stuff 66 33 2 duff 67 44 and one of the resulting columns is derived -- i.e., ...
0
votes
0answers
27 views

Problem forming a query with subqueries in design view? (MS Access 2010)?

I just started a new job as a dbase admin intern, and due to the database being very large, it is better to do queries in design view, rather than hardcoding the sql. That being said, I cant seem to ...
0
votes
1answer
36 views

Joining two database tables into one

I have a database with two tables. Each table has different structure but they do share few common fields. Simplified example: Table1 field structure: Field1, Field2, Field3, Field4 Table2 field ...
0
votes
0answers
7 views

Accessing Unidata DB over Access 2003 through ODBC driver

My apologies if it sounds like gibberish, I work extensively with MS SQL and not much else. I have an Access SQL query that selects data in a linked table in Access 2003. That table is linked using ...
0
votes
1answer
153 views

Concatenate 2-3 table field values in 1 table field in access

I have a project that in Access. The problem is I am a newbie in this application and I really couldn't figure out what to do, I have checked out several ways but am still stuck. I'll be handling a ...
0
votes
0answers
12 views

When to use tags vs binary fields in a constituent management system?

I have a table of Constituents and I want to track yes or no qualities like: are they a teacher? are they an elected official? are they philanthropists? There will be less than a dozen of these ...
0
votes
1answer
28 views

PostgreSQL ODBC and Microsoft Access date/time in aggregate functions

I am trying to replace our MS Access 2003 databases with PostgreSQL 9.3. The first step is to use our MS Access front end to the upsized databases in PostgreSQL. Everything seems to work very well ...
0
votes
0answers
24 views

Cannot access MS Access DB with non-Admin users

I have created several users in a MS Access database using "User-Level Security Wizard" in Access 2013. The problem: I am only able to log in with users belonging to Admins group. Other users ...
1
vote
1answer
85 views

How to set user-level security in 2007+ MS Access?

I've read this MS info which should cover my problem. There are quite clear steps: Open the .mdb or .mde file that you want to help protect. On the Database Tools tab, in the Administer ...
0
votes
1answer
38 views

ORA-01461 in a msaccess linked table

In an Oracle 11 database I have a table that all fields are varchar2. This table is linked in an access database, and when I try to do an insert from a data aggregate query, it throws the error ‘can ...
0
votes
0answers
8 views

Trouble updating row in access

Here is what my table currently looks like. The two blue and pink lines indicate repeating OpIDs I used INSERT INTO to pull data from the Wednesday table into the Weekly table but that doesn't ...
0
votes
0answers
11 views

What is a .cof file that the database is linked to?

I am on working on creating a script that de-link and re-links all the linked tables from the front-end. I'm working on an exisiting database that has been created and pre-configured. When I click ...
0
votes
0answers
12 views

Access form remove all fields with new table adds

this is a very basic question that drove me crazy for the past few hours. I have a database (attached) in the "Events" form I'm trying to add "Resource Name" from "Resource". Both "Resource" table and ...
6
votes
5answers
6k views

Can I be automatically notified of prolonged blocking in SQL server?

About once a week I have to resolve a blocking chain on a SQL Server 2005 database, caused by a long-lived read lock from an Access 2003 front-end. The lock is taken out whenever a user opens a ...
1
vote
0answers
53 views

Most effective way to manage a growing list of time series data in an MS Access database

I am building a database to store time series data along with some other summary statistics. Since this is a local application I do not have access to more robust database solutions and am confined to ...
1
vote
1answer
494 views

Cannot add or change records

I'm designing a database structure wherein I like to apply the concept of inheritance. There's a base tables and derived tables in which the relationship is one-to-one. I'm quite new as of how could ...
1
vote
1answer
1k views

Missing 'Microsoft Office 12.0 Access Database Engine' in SSMS

I've got several users that need to import / export ACCDB Access files into out of SQL Server. Unfortunately, I have been unable to get 'Microsoft Office 12.0 Access Database Engine' to show up as a ...
0
votes
0answers
15 views

Multiple images but one user

Hello i am trying to build a small website. I have a database(MS Access) with two tables images and user Images has userID and filename. User has email password etc.. A user can upload multiple ...
0
votes
2answers
306 views

Access 2003 (SQL Server 2000) migration to SQL Azure

As my old Windows 2003 RAID controller started throwing errors, I am seriously thinking about switching current Access 2003 (adp/ADO) clients to use a Windows SQL Azure solution, in place of current ...
3
votes
1answer
8k views

Joining 3 tables using SQL Query?

I'm having problems joining three tables. It works well when I use the same query for joining two tables (after removing LEFT OUTER JOIN C ON B.No = C.No). However, it doesn't work when I use three ...
1
vote
1answer
62 views

How to get the equivalent of array or string GROUP BY aggregate functions in Access?

From SQL Aggregate Functions (Office 2007) there are only these GROUP BY aggregate functions in Access SQL: Count(), Sum(), Avg(), First(), Last(), Min(), Max(), StDev(), StDevP(), Var(), VarP() ...
1
vote
1answer
3k views

IF IS NULL then SINGLE else keep the value of the field

I am in need of a query string assistance please. I am working with a DB in Access and I'd like to be able to fill the field in this row with a result of SINGLE if it is not already filled with ...
1
vote
1answer
502 views

Install Access Database Engine on Linux Centos [closed]

I want to read mdb file from linux centos. To read that file, we must already install access data engine. Is there any access data engine for linux? Now I'm using mdbtools to configure ODBC connect ...
0
votes
0answers
37 views

How do I modify an access query to select a row based on one column when other column information is not distinct?

I have three main tables in Access 2007 that I query to get the Class, Skills, and Students. Mutliple other tables are included in the query to pull other information. If a person learned the same ...
5
votes
2answers
4k views

MS Access / MySQL: unlock locked Records

I have a Microsoft Access database that is connected to a MySQL server via ODBC and is accessed by multiple users. Over time many records are locked and editing is not possible anymore. Is there a ...
0
votes
1answer
99 views

MS Access: adding column if not exist (or try/catch it)

this is an easy question, but I can't find out the solution... I have to check if a column exists and add it if the test is negative. How can I do with only sql code? This is the syntax for SQL ...
1
vote
1answer
95 views

representation in ms-access

I have a database in microsoft access. I want to know how to look up a singular datum from a reference table giving a dynamic set of values. Here is a representation of what I mean: I have the ...