Microsoft Access is a relational database management system that is part of the Microsoft Office suite.
0
votes
0answers
25 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
1answer
31 views
Get Maximum Value
I am using MS Access database. I have a table (Proposal) with the following properties:
ProposalID - PK, Title, RequestedAmount, ResearcherID - FK
I want to run an SQL query to get the candidate that ...
3
votes
1answer
123 views
Normalizing a database without access to source data?
I've started a new role which deals with large amount of related data. Our source of all this data is various Excel dumps pulled from databases we do not have access to. The previous person filling ...
0
votes
0answers
14 views
Performance Slow After CompactRepair Access
I am performing a large number of insert operations using VBA - Access. the VBA code is in a file "control.accdb" performing operations on "data.accdb"
Few tables in the process are created from the ...
0
votes
0answers
44 views
How to update column value in MS-Access by comparing two columns?
I have an Access 2000 table with 10 fields. I want to compare the 2 column and update the third one.
To elaborate :
keyfield cno entno uno
(Text) (Text) (int) (int)
...
0
votes
0answers
50 views
Access 2007 - Splitting single record into component parts similar to Microsoft Money's split transaction (Updated)
I currently import a bank statement into an Access 2007 table and then use a lookup within the table to categorise each transaction. I then use a report to group the transactions into category types.
...
0
votes
2answers
43 views
How to write a script to push the server time to out?
Background:
I am programming a database in Ms-Access and using SQL-server as the Back-end. But since my database will be a multi-user platform I need to make sure that whenever a user is posting data ...
2
votes
1answer
74 views
Would using timestamps solve consistency issues with snapshot isolation?
I'm considering using Snapshot Isolation for some large queries being send from an Access 2007 frontend. These queries are occasionally causing ASYNC_NETWORK_IO waits, and some blocking as well. I'm ...
6
votes
7answers
178 views
Main Considerations When Moving From MS Access Programming to SQL Server
First post, be gentle...
I am a 100% self taught MS Access programmer (main part of my job is programming), I am now building larger databases; still using MS Access as the UI but SQL Server to store ...
0
votes
2answers
145 views
Backup Access Database Daily/Weekly
We have a Microsoft Access database split into backend/frontend. What I am looking for is to be able to automatically backup these files on a daily or weekly basis - what is the best way to go about ...
0
votes
0answers
137 views
Is there any in-depth tutorial for ACCESS 2007 Northwind Traders template?
I wanted to learn a little bit more about Access in order to create a sales/inventory analisys tool to use at work. Now I came across this beautiful template on microsoft office's official website: ...
1
vote
3answers
143 views
Database Design Relationship for Patient Visit in MS Access
I am designing a database to store records for research purposes, and I am having trouble picturing how I can create a relational database based on the information I have.
There are a total of 6 ...
2
votes
2answers
632 views
Ms-Access 2007-2010 SQL - from single row record how to create multiple rows
I need help in below table updation using SQL in Ms-Access 2007-2010 database.
I've a table called table1 which has below entries:
table1:
--------------------------------------------------
| col1 ...
1
vote
1answer
64 views
Database Relational Design for Multiple Categories
I am building a database for participants who are grouped into studies. There's a total of 5 different studies - A, B, C, D, and E. The participants may be in more than one studies, and participants ...
0
votes
0answers
44 views
MS Access client: store (OLE) documents in Oracle table [closed]
I would like to try storing documents in an attached Oracle table from MS Access, exactly like one can do with OLE Object fields in Access tables.
Is that working ?
Which field type can be used in ...
2
votes
0answers
51 views
How can we achive the replica of databases for SQL Server?
I have been working in VB6 to VB.NET migration project.In VB6 project they have individual databases (access db .mdb) for every user now we made that to centralized database using SQL Server.
In the ...
1
vote
0answers
28 views
Defining the Relationship - Some Basic Help [closed]
I thought I had this figured out but I am starting to doubt myself on something that should be simple. I have a table of Group, and a table for Activity. Each Group has one Activity. Different groups ...
0
votes
2answers
300 views
MS Access ER diagram
I have database scheme for Microsoft Access. I'm interested how I can convert the scheme into an ER diagram? Is there any tool that can do this based on scheme relations?
0
votes
1answer
70 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 ...
1
vote
2answers
79 views
Pull Access schema into a SQL Server table
We had an assembly that used to pull a list of tables and their columns from an Access database and place the listing into a SQL Server table for later use. For various reasons the assembly is no ...
0
votes
1answer
77 views
MS ACCESS: sql query not showing results expected [closed]
I'm having a little problem.
In my Access DB, I have a table named customers.
In this table I have a field DateEntered that is set to short text data type.
I am trying to run a query to pull all ...
0
votes
1answer
95 views
Microsoft Access - performance difference between index and constraint?
I've looked around a bit but haven't come across anything talking specifically about MS Access. So: what, if any, is the performance difference between a field with a constraint and a field with an ...
0
votes
0answers
183 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
1answer
191 views
How to set up data entry in many-to-many database in Access 2010 with forms/subforms?
I have a simple two table database in Access 2010 tracking landowners and properties. They are related in a many-to-many (M:M) relationship with a link table. Forms for viewing data have been ...
1
vote
0answers
290 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
1answer
63 views
What is a proper way to handle a “sequence number” like field?
The fields of a trimmed-down version of a database I'm working with looks like this:
Model Number, Model Name, Customer, Date, SeqNum
The customer can purchase the exact same item on the same date ...
0
votes
0answers
108 views
What are the improvements of OpenOffice Base and LibreOffice Base in the last 2 years? [closed]
I wonder how the database parts of the 2 products have changed or improved in the last 2 years.
I need a tool for working with ODBC Databases, MS Access and SQL Server and I have been using the old ...
2
votes
0answers
428 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
188 views
Connecting to a SQL Server database from a Flash program
I currently have the ability to utilize Microsoft SQL Server 2012. I am developing a project with Adobe Flash Builder 4.7.
If I link my database with Adobe Flash Builder is there any additional ...
3
votes
1answer
310 views
Removing duplicates from a query with conditions in Access 2007
I have a table of transactions with 880,095 records that I am querying.
There are duplicate Transaction ID's in the table that I would like hidden/removed when querying the table.
Eg 1.
...
1
vote
1answer
87 views
Pivot a table to repeat the first column for each following column
i'm not sure how to explain so I'll try and write out an example.
I'm currently using an access database with a table in the following format
1 A B C D
2 A B C D
I'm trying to perform a query ...
3
votes
1answer
101 views
I need help to migrate denormalized table content to normalized form- MS Access
I have a staff database where we are storing information in Normalized form. There are 3 entity tables and 2 mapping tables connecting these with m-n relationships
However, for ease of collecting ...
3
votes
2answers
143 views
COUNT (*) = 0 does not work?
Alright, I'm trying to make a query for a library that will show which students have never borrowed a book. For this, I have done the following:
SELECT
LEERLINGEN.LLNR,
LEERLINGEN.VOORNAAM,
...
0
votes
1answer
208 views
Microsoft Office Access database engine could not find the object 'tableName'
First a little background:
I am using MS access to link to tables in an advantage database. I created a System DSN. In the past in Access I've created a new database, and using the exteranl data ...
3
votes
1answer
162 views
MS Access database in a network
I would like to ask if MS Access database supports working in networks & multi-user access?
2
votes
0answers
273 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
1answer
69 views
I get the error “You are attempting to execute a query in which the selected expression is no part of a statistical function.” in MS Access 2010?
Please note: my copy of Access is in Dutch, so any English parts are translated from Dutch.
I'm currently working on a database in Access using SQL, with the exercise being:
Create a query that will ...
2
votes
1answer
1k 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
1answer
410 views
Access query to select multiple records with matching field
I have a table with a list of people ([FirstName], [Surname], [Age]). Some of these people are in the same family. I'd like to return a list of people who have another family member in the table (same ...
0
votes
1answer
257 views
May a query update a source table?
I work with a few tables with given data. I run a query built in Design View just like
result:![table1].[qty]*![table2].[expenses]
and I get the output in query table in field result. Is it possible ...
1
vote
0answers
272 views
how to connect values of a new record in a form to a table? [closed]
I have just started working on MS Access 2007. I know how to create a form and add buttons, textboxes, etc
I don't know how to connect my values entered in textbox to my table in database.
How do I ...
1
vote
2answers
160 views
Good tool for making MySQL queries graphically?
After working a while with Access 2010 I have fell in love with the way you make queries. You just pick the tables you want in your SELECT query, then you get all the JOINs laid out automatically, and ...
1
vote
2answers
108 views
Replacing the MS-Acccess frontend for accessing linked tables with SQL Server?
Is it possible to use SQL Server / SQL Server Management Studio to do queries across linked tables the way that you would do them in MS-Access?
The MS-Access front-end is frustrating and time ...
1
vote
1answer
264 views
Exporting data from Microsoft Access table file subsets to plain text
I have a problem in exporting data from Microsoft Access. I have an Access file made of several rows and columns, like this:
Every row contains a subset of data, tha could be observed by clicking ...
4
votes
2answers
1k 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 ...
5
votes
1answer
997 views
Is it possible to synchronize two ms access db?
We have a flower store where we use MS Access and a client program to work with the database. But this program can work only with one database.
We are going to open a new store, so now we have to ...
2
votes
1answer
559 views
SQL Server ODBC Mirror/Failover Partner
Background/Context
We are in the process of moving our SQL Server 2000 databases to a mirrored SQL Server 2008 R2 server with a witness and automatic failover. We have both .Net and Access ...
0
votes
0answers
28 views
Duplicate Customer Records for SQL Query from ODBC with Joins and Group Bys [duplicate]
Possible Duplicate:
SQL Query with ODBC, Joins and Group Bys
I am getting duplicate customer records with the query below. The main purpose of the query is to pull a list of customers into ...
0
votes
0answers
85 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 ...
2
votes
5answers
321 views
SQL Query with ODBC, Joins and Group Bys
I am having issues with the statement below. The main purpose of the query is to pull a list of customers into an Access db from ODBC (our customers are stored in DB2 on IBM i). The query is ...
