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

learn more… | top users | synonyms

0
votes
2answers
173 views

linked server to specific access table

I have built a linked server which links my SQL Server database to an Access DB. Using this object someone is able to see all tables in Access. What I would like to do is to isolate it just to 1 ...
0
votes
2answers
178 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
76 views

How to check with SQL whether a column is an identity column for an Access database?

Knowing how to check whether a column is an identity column for Microsoft SQL Server, I currently still found no solution for doing the same with SQL for a Microsoft Access database. My question: ...
1
vote
1answer
50 views

False positive error message in MS Access (concurrent users)

I have discovered a strange apparent bug in MS Access and would like to know if others know it already and hopefully how to get around it. Trying to count records based on known column categories. ...
1
vote
1answer
68 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
35 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
1answer
41 views

Re: How do you translate this into SQL Server

How do I translate this into SQL Server: select -Sum((12=[GroupNum])*[BoardStatus]) AS G12 FROM QryAllBoardsByPacketIDs INNER JOIN tBsReportGroups ON ...
0
votes
1answer
39 views

IF NOT 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
1answer
23 views

“key violation” when trying to import data into MS Access

I am trying to import data into an MS Access table from a flat ASCII file. I've done this many times before but now I am getting a "key violation." There is only one key in the table and it's an ...
0
votes
1answer
35 views

Access ('07 -'10) form is not showing entered records

I have a form that I enter data into that is broken into a number of different tables for normalization. However, once I reopen the form, only the first record is shown. I have it set as "single ...
0
votes
1answer
28 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
65 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
336 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 ...
2
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 ...
2
votes
0answers
401 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
264 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 ...
1
vote
0answers
63 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
73 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
33 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
204 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
118 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
81 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
129 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
46 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
80 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
684 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 ...
1
vote
0answers
340 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 ...
0
votes
0answers
24 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
19 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
30 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
51 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
82 views

Randomly failing SQL Server 2008R2 used by Access 2010 front-end via ODBC

From time to time (sometimes days apart, sometimes several times a day) users of a multi-user Access front-end, which has ODBC connections to a SQL Server back-end, see a variety of problems. Most ...
0
votes
0answers
51 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 ...
0
votes
0answers
172 views

SQL query to return a column per date in date range with sum of contract utilisations (value/duration)

My question is similar but more elaborate than another already in stackexchange.com "SQL query to return a column per date in date range?" I have the following data: Customer Start_date ...
0
votes
0answers
57 views

Ms Access lock a field based on its current value in datasheet

I have a check box named post in a datasheet i want it to be automatically disabled i.e. locked if post=true while the rest of the post in the datasheet which are post=false remained enabled i.e. ...
0
votes
0answers
13 views

Is it possible to have 1 piece of code do Global Error Catching in Access 2007 VBA

I know I can use code like On Error Goto ErrorHandler: in individual subs for error catching but I was wondering if there was a way for me to place just one "On Error" somewhere in my VBA code that ...
0
votes
0answers
29 views

How can I number my groups using an Access “Find Duplicates” Query?

I have a query created by the MS Access 2010 find duplicates wizard. It is: SELECT * FROM fbExpenses WHERE [expense_date] In (SELECT [expense_date] FROM [fbExpenses] As ...
0
votes
0answers
43 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 ...
0
votes
0answers
71 views

Attendance Database using sql in MS Access

I'm currently working with a simple database for the attendance of the professor in our college. I'm using MS Access 2010 with a Main table that includes the Attendance log of all the professor with ...
0
votes
0answers
65 views

Populate the columns of one table with the records of another

I have one table, FRUIT, describing some measurements that I make: ID Tag Amount Units 1 A 75 Apples 2 B 23 Bananas I would like another table, HISTORY, that tracks the ...
0
votes
0answers
40 views

Access table converted to system table… Help changing it back?

Somehow the business unit managed to change a regular table into a system table. Now nobody can read it or edit it. Engine is the owner and nobody has administer permissions. I noticed in ...
0
votes
0answers
158 views

Missing values in INNER JOIN MS-Access?

When I run the following query in MS-Access: SELECT a1.ConStateNumber, a2.ConStateNumber FROM qryW2_yr_sum_slash_qryW2_q4_sum_result a1 INNER JOIN qryW2_q3_sum a2 ON a1.ConStateNumber = ...
0
votes
0answers
1k views

MS Access trigger

I got a trigger to update a table in SQL. My actual need is in MS Access but I could not make it. So please help me to write the same trigger in MS Access. Query is as follows: Create trigger ...
0
votes
0answers
99 views

Being careful about additional records being added in a duplicate record merge?

We have a multi-user MS-Access 2003 database. Connecting to it using SQuirrel SQL, and the JDBC/ODBC bridge, I've managed to eek transactions of some sort out of JET by turning off autocommit. I've ...
0
votes
0answers
1k views

How to bulk import multiple CSV files into master tables with variable field names?

As a learning exercise, I am trying to map several data files into a few master tables. Right now, I have a file hierarchy as follows: <Root> - Client 1 - CustomerInfo.csv - ...
-1
votes
0answers
25 views

How to connect to MS Access x86 from LocalDB x64 as Linked Server via Management Studio?

I have x64 CPU so i cant install x32 Local DB (throws me an error). So i installed x64. I have installed x86 Office 2007 with Access DB. I installed x86 Microsoft.ACE.OLEDB.12.0 Driver (Microsoft ...