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

learn more… | top users | synonyms

-2
votes
1answer
18 views

How to implement a distributed database system [on hold]

I have been tasked to find out how to implement a distributed database system using the various database management software available like: MS Access 2013, MySQL and PostgreSQL. How would I be able ...
0
votes
0answers
3 views

Access 2010 delete and append queries run partially then give “Read Only” error

I have a number of append and delete queries written in Access 2010 that link to and modify tables on our SharePoint 2010 site. These queries have run without problem for months, but suddenly they've ...
1
vote
1answer
990 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
11 views

Why is my Make Table query pasting 0 rows?

I have 3 tables that I am trying to merge into 1 table using a make table query. They have thousands of rows of information. They all have multiple columns, but the first column on each will contain ...
0
votes
0answers
18 views

outer join more than 2 tables in access [migrated]

After following this thread. I am getting an error as "Syntax Error in JOIN Operation" Here Is my query SELECT StudentMaster.Student_id, ExamDetails.Subject_id, ...
0
votes
1answer
142 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
7k 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 ...
0
votes
0answers
11 views

Add user level permissions to MS Access by using a MySQL backend

I have a large Ms Access 2013 .accdb application which runs a lot of VBA code, with almost 60 users. I developed a user level permissions mechanism using vba but now plan to migrate the back-end to ...
0
votes
2answers
264 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 ...
0
votes
1answer
649 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
596 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 ...
0
votes
0answers
37 views

Good way to harmonize data from different databases [closed]

I have three databases (an access database with user data in-house, a MySQL database of a data provider also with user data but stored in a slightly different structure (e.g. different field names or ...
0
votes
1answer
2k 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
1answer
18 views

How to define destination for an append query Microsoft Access

I'm trying to append two tables in MS Access at the moment. This is my SQL View of my Query at the moment: INSERT INTO MainTable SELECT FROM Table1 INNER JOIN Table2 ON Table1.University = ...
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 ...
0
votes
1answer
23 views

Linking two fields from different tables (are relationships required?)

For example, I have two tables. Employees and Products. Inside Employees I have the fields: emp_ID, emp_fname, emp_lname, emp_products Inside Products I have the fields: pro_ID, pro_name, ...
1
vote
1answer
453 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 ...
0
votes
1answer
52 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
35 views

Displaying only the most recent activity of an item

I have made a database that tracks the shipping and receiving of the tools that my company has. I am now wanting to make a query that shows only the most recent activity of all the tools. I have a ...
1
vote
1answer
312 views

Install Access Database Engine on Linux Centos

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 ...
3
votes
0answers
2k 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
0answers
16 views

How to find if a prefix is inside another in a database?

Good morning, I have a table with two columns: Table: Number1 Country 12063 USA 120634 USAW2 1206344 USAW3 1356 ATG Considering Number1 is a prefix, in my example, the number ...
1
vote
1answer
94 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 ...
0
votes
1answer
84 views

Handling empty fields

SELECT Name, SUM(Switch([Date] = DateAdd('d', - 7, DATE ()), NetAmount) )AS DAY1 FROM Customer GROUP BY Name My question is how to return the value 0 when the date is not present (an empty field). ...
0
votes
1answer
37 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
57 views

User can see Oracle tables via ODBC that her account does not have access to [closed]

We have a user whose Oracle account, according to ALL_TAB_PRIVS, has access to tables A, B, and C. However, when the user creates an ODBC and connects to Oracle via Microsoft Access (using her Oracle ...
1
vote
1answer
311 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 ...
0
votes
1answer
132 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
20 views

Markup language for dynamic in-text citations in report

I'm a self-taught novice handling an Access DB as part of an internship, so I apologize in advance if this question offends. BACKGROUND: My DB is a set of summaries of analyses. Each analysis has ...
0
votes
1answer
110 views

Access Database that is shared with my company on a network drive..When I copy and paste it to my desktop there linked some how?

I have an Access Database that is shared with my company on a network drive..When I Click on the drive and copy and paste it to my desktop and make changes to it the database that is on the drive also ...
0
votes
0answers
14 views

Getting exception in Servlet due to ODBC

I am getting exception which is as follow - Exception[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specifiedjava.sql.SQLException: [Microsoft][ODBC Driver ...
1
vote
0answers
22 views

Replicating Multiple SQL Servers to Azure and Accessing From Web Apps

I am setting up quite a large system with multiple servers (MS SQL Server), and Office 365 Access DB, and a custom SharePoint web app for reporting purposes. The system should work as follows: Each ...
0
votes
1answer
72 views

How do I count and order by unique entries?

I have this: SELECT tblClient.[Printed Name], tblClient.[Address 1], tblClient.[Address 2], tblClient.City, tblClient.State, tblClient.Zip, tblClient.Phone, tblClient.[Email Address] FROM tblClient ...
0
votes
0answers
36 views

Are documents made with MS Access 32/64 bit compatible with the other “bitness” version?

I don't have a copy of 64 bit MS Access installed so I can't try this. I'm a developer looking at what's involved with adding support for 64 bit. I'm just using the MS Access database as a back-end. ...
1
vote
1answer
30 views

MS Access - protecting backend file

I'm creating a split database in Access which has the backend on a drive accessible to all employees in the company at the moment. This isn't such a big deal at the moment because I'm still developing ...
1
vote
1answer
38 views

Updating one table from another table where non-primary-key field is similar string

I have a database in Access that I am trying to fix (actually, I'm working on a copy of the original). There are two tables, one with data input errors, and a second that is a copy of those errors, ...
0
votes
0answers
45 views

How can I track changes across 60 local databases with 1 million+ rows each?

The files are mdb and I have them locally on my computer. Just trying to track changes across the 60 databases. Realistically I want to compare two at a time and find the differences in the reports, ...
0
votes
1answer
199 views

What are the problems with sharing an Access database through online storage service, like Dropbox?

I have a desktop database I created in Access. I'd like to share the database with a single collaborator, who can have full privileges to the database (table access). However, my collaborator is much ...
1
vote
0answers
33 views

Fetch Top 2000 Records

I have following query: strfinal = " TRANSFORM Format(Sum([Mandays].[Hours]),""#0.0"") AS [The Value] SELECT Mandays.WorkTypeCode AS WONo, ...
0
votes
0answers
38 views

Database design for varying prices from multiple vendors

I am designing a database where the products are sold in bulk with multiple pricing options, from 4 different vendors. What is the best table configuration to store this information? Id like to be ...
2
votes
1answer
214 views

How to UPDATE/DELETE/INSERT with Microsoft.ACE.OLEDB.12.0 as Linked Server in SQL Server 2012?

I need to update an Access 2003 database from SQL Server 2012 with the Microsoft.ACE.OLEDB.12.0 provider. As an administrator, everything works great. I can do Select, Insert, Update and Delete ...
1
vote
0answers
21 views

MS Access Residual Query Parameters on Copied Report

I've been working on an ms access database which was put together prior to my employment, I wanted to create a new report in order to display Quality Control information, in order to do this I copied ...
0
votes
1answer
52 views

Exporting Access DB to SQL Server: unexpected EOF?

How do I correctly export a table from an old Access .mdb to SQL Server 2012? In Access I do: right click on table, export as text file and use comma or tab separator. My line endings are CRLF as ...
0
votes
1answer
73 views

SQL access query to count and delete rows > n

Can someone help me with a SQL (Access) query to delete all rows greater than n entries ordered by ID? I.e. say I have 1200 rows of data with ID incremented . I need delete the first amount leaving ...
1
vote
0answers
59 views

Importing mdb to AWS RDS SQL Server

I have a small and very old access DB, it is just one .mdb file and it was made before Access 2003. How can I import it to SQL server running on AWS RDS? I actually only need to import one table from ...
0
votes
0answers
65 views

Access 2013: Use macro to update table based on new entry

I'm trying to get a macro for 1 table to update another table based on the latest entry by the user. I have 2 tables. Product(ID, Inventory) and Sales(Sales ID, Product ID, Amount) I ...
0
votes
2answers
52 views

MS Access Query to update

Trying to update Packet.MSGState to P where if not R or D and it is Y in table Packet.MSGState UPDATE Packet SET Packet.MSGState = 'P' Where (MSGState <> 'R' and MSGState <> 'D') and ...
0
votes
0answers
62 views

How to design a Many to Many relationship table?

I'm new to DB's, so I'm not really sure how to even formulate the question. Please feel free to edit the question itself. Anyways, let's describe! I should advise that I am using MS-ACCESS for this ...
1
vote
1answer
48 views

Duplicate table structure with different data [closed]

I am looking for a way to resolve a design issue with a Microsoft Access project that is being converted to use SQL Server 2014 as a backend. We have several Access backend files, two of them have ...
0
votes
0answers
50 views

Deploy existing ms access file with forms as web application

We are using the following: a ms access file with local tables remote tables which are connected through the odbc connector to a external mysql database with many forms When using the ms access ...