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

learn more… | top users | synonyms

2
votes
0answers
76 views

Moving data from MS Access to MS SQL Server

I'm trying to migrate data into SQL Server from an existing legacy set of MS Access databases. Currently everything is working except a few core tables that are wide and contain a number of ...
2
votes
0answers
557 views

Parameters in queries using vba

I am trying to write a process to run several prewritten Queries in a row without any human interaction. I tried to write a macro, but the after saving it it still prompted for the date range in the ...
2
votes
0answers
301 views

MYSQL & Access ODBC

I am trying to connect mysql with access, i am settings up the ODBC correctly from the data sources, however i get a driver error. I am using access 2010 and the driver version of the ODBC conector ...
2
votes
0answers
459 views

How do I auto-fill data in Microsoft Access 2003?

I am creating a Purchase Order Form at work using Microsoft Access 2003 so that it can be saved and archived in a database and reduce paper costs. These are my current dilemmas: I am unable to ...
1
vote
0answers
18 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 ...
1
vote
0answers
30 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, ...
1
vote
0answers
18 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 ...
1
vote
0answers
50 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 ...
1
vote
0answers
28 views

How to append records from one complete table into a partly populated differently formatted table?

I have two tables of interest linked in a MS Access 2007 database. The master table called EMPL_MASTER (from which I only have read access, I cannot make changes) updates every time a system ...
1
vote
0answers
246 views

MS Access 365 When selecting Lookup Wizard, datatype is changed to Number

I want to create a relationship between my Contacts table & Ref_State table. Contacts table has field called State/Region which I want to make Data Type = Lookup Wizard Ref_State has fields ID ...
1
vote
0answers
246 views

How to upload a PDF to Access database?

I have 100+ pdf files that I would like to load into an access database. When the pdf is uploaded, I would like for the data retrieved to update in an access form. How to do that?
1
vote
0answers
128 views

Link up an ms access database to SQL Server 2008 R2?

I've installed the OLE DB Provider for JET by downloading this and installing it. I closed and reopened Microsoft SQL Studio, and connected to my SQL Server Instance. In <instance-name> ...
1
vote
0answers
48 views

Microsoft Access database performance

I wonder how MS Access manage to show long list of records when we want to browse theme in Datasheet view. 1 - Does it load limited amount of records on start-up and then load the remainder upon user ...
1
vote
0answers
122 views

Combine a running balance SQL statement as a column

I have two Select Statements which are collecting data from 1 table, one is a totals select statement. Could anyone assist me with combining them into 1 statement? Any assistance is appreciated ...
1
vote
0answers
534 views

In the Import/Export Wizard inside SSDT, why is the MSAccess DB Engine data source looking for a workgroup information file?

Running MSSQL12, VS10 Shell, MSA2013 with local .accdb files, Microsoft Access Database Engine 2010 Redistributable (x86_64) and Microsoft Access Database Engine 2007 Redistributable (x86) installed. ...
1
vote
0answers
172 views

Pivot table with many columns, a bad practice?

I am constructing a pivot table with many columns (300) and I wonder if I this is a bad practice. Here are some details why I need to contruct this table. A (very) simplified presentation of my ...
1
vote
0answers
162 views

MySQL Link to PHPMyAdmin/MS Access

I have a mysql database stored on a server via phpmyadmin. I want to link this to MS Access for other users. I often link mysql databases to MS Access which are stored locally, but never DB's stored ...
1
vote
0answers
218 views

SET IDENTITY_INSERT equivalent in Access

In sql server i can explicitly insert value to a identity column of a table by using SET IDENTITY_INSERT ON . For an Access database i am using Autonumber column datatype. For this column i am not ...
1
vote
0answers
47 views

A pre-existing hierarchial table as relational

Currently the database contains something like so (these are the main fields but there's a large amount more): +----------+----------------+----------+ | Agency | parent | main_term ...
1
vote
0answers
120 views

Supressing the Confirm box in an access vba function

I've got an Access database and in there I have macro which outputs a query to a csv file ready for import into another system we are using. As part of this macro it makes a backup of the base table ...
1
vote
0answers
613 views

Connection to MS Access from Oracle over a DB Link

I need to establish a connection between a MS Access database, which is placed on a network share on a windows box, and an Oracle database on a Unix Box. I need to query the Access tables from the ...
0
votes
0answers
12 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 ...
0
votes
0answers
8 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 ...
0
votes
0answers
33 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. ...
0
votes
0answers
43 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
0answers
26 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 ...
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
0answers
36 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
0answers
57 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 ...
0
votes
0answers
13 views

Access Form Help. Similar Match in 1 Table, Alter Another Table

I have two tables (Access 2010). One with a list of names (List1) and another with a very similar list of names (List2), but they differ in very small ways. For example, List1 might have John Smith, ...
0
votes
0answers
38 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 ...
0
votes
0answers
35 views

Building an economic time series database with aggregation/dis-aggregation capabilities

I am trying to build a database in MySQL and MS Access that contains economic indicators and financial time series. Initially, I wanted to solve the problem by setting up a table for each major ...
0
votes
0answers
62 views

Left Outer Joins in Access

I'm working on an existing Access database trying to implement some changes which will allow the estimation of cutting times for my employer (We're an industrial company who fabricate Flight Cases). ...
0
votes
0answers
154 views

Importing OLE Object from Access to SQL Server

I am trying to import a table from MS Access to MS SQL Server which contains a BLOB field which contains a .zip file. The zip file has two images. This field is null sometimes. I am using the Import ...
0
votes
0answers
121 views

Update Duplicate record in select query of access

I have a select query (test) in access with below mentioned column ID 2561 2562 2563 2343 2561 2563 2563 Now in ID, i have duplicate records , for example here 2561 , 2562 , 2563 are ...
0
votes
0answers
35 views

How does indexes work on an Access query

I'm working on an Access 97 Db and I'm trying to speed up some low performance issues, as of right now I'm wondering how indexes works in Access. Using this table with 300k rows i get awful results ...
0
votes
0answers
45 views

MS Access using MYSQL database and error in SQL (memo, hyperlink OLE)

I have a SQL statement that works fine in MYSQL workbench but when used in Access it produces a "invalid Memo, OLE or Hyperlink Object in subquery 'custom_values.value'. SELECT ccr1.value, ...
0
votes
0answers
58 views

MS Access database corruption

I have been searching for an answer to this, but no luck. Has anyone ever seen the below error when loading an Access 2010 database? "[database name] has detected corruption in this file. To try to ...
0
votes
0answers
79 views

Allowing certain users to edit drop-down list values

Current situation: I've created a purchase orders database application for a company in MS Access. The data is stored in a back-end database on a server. There is a front-end master copy on a ...
0
votes
0answers
80 views

Converting Microsoft Access to Libre Office

Is there a method of converting a Microsoft Access (2010) Data table to a Libre Office Base table? I should like to get rid of Microsoft and concentrate on using Ubuntu but I have a lot of data that I ...
0
votes
0answers
63 views

Is it possible to automatically convert/load an Access database into a CSV or TXT file?

I'm working on moving an Access database to ultimately Teradata. Now I know that Teradata can't read Access files (.aacdb). So what a colleague has tried was manually convert one of the tables in the ...
0
votes
0answers
15 views

Disabling foreign keys

I am migrating data out of access and into MySQL but am having issues with access automatically detecting foreign keys and finding a description of the value from the foreign table. For example a ...
0
votes
0answers
63 views

Last few rows from a non-indexed table in Oracle

I'm trying to run a query on an Oracle DB through SQL Server [dont' ask, it's a requirement] The Oracle table in question [lets call it hugeTable] has over 200 million rows and no index. I'm not ...
0
votes
0answers
88 views

Converting MS Access queries with parameters to an ADP (client for SQL Server)

I am in the process of converting an old MS Access database to SQL Server, so naturally I started off by using the upsizing wizard. Unfortunately, out of about 80 queries, the upsizing wizard was only ...
0
votes
0answers
69 views

Microsoft Access Query: “System resource exceeded”

I have a simple query in my DB and I received this error message: "System resource exceeded". But the query is really simple! Here it is: PARAMETERS [@FILTRO] Text ( 255 ); SELECT [POLIZZE ...
0
votes
0answers
73 views

Spotting foreign key relations in a database that doesn't define all relationships as constraints?

At work I use a rather old MS Access database which defines some relations between tables, but does not outright define all of them. If the database application used an ORM, I would think that this ...
0
votes
0answers
92 views

Are heterogeneous joins between MS Access and SQL Server tables really so bad?

I'm developing a multi-user Access 2013 application with an Access backend on a fileserver. At first I'm going to finish my stable Access application which works fine for the moment. However, I plan ...
0
votes
0answers
23 views

Using Access database Total function with an iif expression

I am making a database for a garment company. Each garment is defined by the following attributes. Date, Style, Colour, S ( this refers to the garment size), Transaction ( which can be in or out) ...
0
votes
0answers
114 views

Connecting Access 2010 front end to Pervasive database with ODBC

We have an Access 2003 front end attached to a Pervasive database used with Sage Platinum. Access is used for reporting and its running on XP. We switched to Access 2010 on a different client machine ...
0
votes
0answers
97 views

MS Access: ODBC Err 3146 - Timeout related?

I have an AccessDB that queries that appears to function as expected under light loading (i.e., 1-2 users), no errors, SQL Server returns the desired results. We tried to test using 8 concurrent ...