Microsoft Access is a relational database management system that is part of the Microsoft Office suite.
1
vote
0answers
28 views
Merging two Access tables into one
I have mostly identical tables, however there are slightly differences like missing columns in older ones. I want to merge 5 tables into one. Is there any easy way to do this?
1
vote
1answer
19 views
MySQL Workbench connect to MS Access
I have a .mdb file on my computer that I would like to convert into a MySQL Schema and I have found that there is a migration tool within Workbench. However it doesn't seem to allow you to connect to ...
0
votes
1answer
210 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 ...
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
193 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 ...
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
127 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
1answer
72 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
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
53 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
0answers
49 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
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 ...
6
votes
7answers
183 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 ...
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 ...
4
votes
3answers
579 views
Query best possible matches and order them
I'm trying to write a query along these lines:
select *
from tbl
where
col1 = 1
and col2 = 2
and col3 = 3
order by
...
;
I want first all the results where all 3 WHERE ...
0
votes
2answers
151 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
149 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: ...
2
votes
2answers
653 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
3answers
146 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 ...
1
vote
1answer
70 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
46 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
311 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?
1
vote
2answers
83 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 ...
1
vote
1answer
270 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 ...
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
190 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
208 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
298 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
64 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 ...
4
votes
5answers
1k views
What is the easiest way to get started using databases with real data?
I have a project that could benefit from using a database, but I have no experience with databases, don't have access to a server, and have relatively little experience working with things living ...
2
votes
0answers
431 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 ...
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 ...
3
votes
1answer
312 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
88 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
770 views
MS Access displays alle columns in SQL Server tables as “deleted”
I have created an ODBC connection to a SQL Server 2005.
When I link to the tables from MS Access, some tables have only "deleted" data.
This means the rows and columns are displayed, but all data ...
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
146 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,
...
3
votes
1answer
168 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
259 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 ...
0
votes
1answer
415 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 ...
1
vote
0answers
275 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 ...
2
votes
4answers
3k views
Full Outer Join in MS Access
I have two staff lists:
List A:
StaffID Supervisor
====================
0001234 NULL
0001235 0001234
0001237 0001234
0001239 0001237
and
List B:
StaffID Supervisor
...
1
vote
2answers
163 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 ...
