Microsoft Access is a relational database management system that is part of the Microsoft Office suite.
1
vote
3answers
369 views
EXCEL sheets batch input to Access
I have a lot of Excel datasheet (in one file)
I want to batch input to Access
but I can't find a sample code to do it
the name of datasheet in access is same as in excel
is there any code of ...
1
vote
3answers
116 views
If A is next to B, how to automatically assert that B is next to A
I am working in Access 2010.
Let's say I have a database that tracks where packages sit in a warehouse.
Table: Packages
PackageID (PK)
PackageHeight
PackageWidth
PackageWeight
PackageOwner
(etc)
...
1
vote
1answer
770 views
Query Linked Access database on network share via SQL Job Agent
I have an MS Access database on a shared network location which I've added as a linked server to my SQL Server instance. I'm authenticated on the network location via the server's main Windows login.
...
1
vote
3answers
145 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
67 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 ...
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 ...
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 ...
1
vote
1answer
266 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 ...
1
vote
2answers
443 views
is it possible to create a form in the intranet that can be stored in a database?
I am trying to create a form for my companies intraNet site. The idea is as follows:
An employee wants to make a purchase, so they will go to the appropriate page in the intraNet
They will fill out ...
1
vote
2answers
306 views
Merging two Access DB's
Our workflow requires two users to work on the same Access database. The problem is that users are geographically separated and can't work on same .accdb file simultaneously.
So, the only way i see ...
1
vote
2answers
514 views
Acceptable size for MS Access Database?
I have developed an Access 2010 database.
It has three main tables:
HOUSES
id,
address,
number_stories,
garden,
parking,
imageAttachments (~1-4 per record),
etc...,
about 60 fields total
...
1
vote
2answers
109 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
278 views
Unable to add records to query in Access 2007
I've found this excellent resource that covers why a query might be read-only. I have a query that is not read only, yet I'm unable to add new records to it.
There are three tables. Let's call them ...
1
vote
1answer
530 views
Why do I only see SYS and INFORMATION_SCHEMA tables? Access 2007 ODB to SQL Server 2008
I was finally able to create my ODBC connection but now when I go to External Data > ODBC > LINK TABLES using my ODBC connection in Access 2007 I get a huge list of tables such as
...
1
vote
2answers
419 views
Model a family tree database in Access 2007
I designed my database with the intention of implementing it with MySQL, but have now decided to implement it in Access 2007 using form and subforms. While creating my UML diagram, I realised I have ...
1
vote
1answer
67 views
Microsoft Access constrain view by date in outer query
I'm working on a query in Microsoft access and it does not appear to allow me to filter the inline view by a date that exists in the table outside of the inline view. A simplified version that ...
1
vote
1answer
1k views
Records in table not showing on form Access 2007
Excuse my ignorance in asking this question - I am a database novice and need help!
I will explain as best I can...
In the table on my DB I have 235 records. I have created a form which references ...
1
vote
1answer
230 views
Microsoft Access 2003 vs SQL Server 2005 Express
There is an Access 2003 database that each "corps" has to manage themselves containing personal, training and material data. It's written very poorly. Besides that, the server only runs Windows 2000, ...
1
vote
2answers
420 views
Access exporting to CSV is weirdly slow
I have searched but could not find anything similar. If I just run the query, I can get the result pretty quickly (~5 mins); but after I saved the query to export as CSV, the exporting part is ...
1
vote
1answer
188 views
Get data from database and put it back to a new datasheet
I want to get the data from the database and put it back with the new format
I have a lot of datasheet like follow
ID a b c d
1 1 5 9 13
2 2 6 10 14
3 3 7 11 15
4 4 8 12 16
and I want to put ...
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 ...
1
vote
0answers
291 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
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
0answers
242 views
Implementing a family database using Access 2010
A while ago I asked this question about using Access 2007 to implement a family tree model. I had all the tables and relationships mapped out in a UML diagram but realised it was getting out of hand ...
1
vote
1answer
56 views
Rename cell based on duplicate compound key in MS Access
I'm using MS Access (I know, I know...), and I'm trying to rename a cell when there are duplicates of mutliple columns.
Here's an example:
Col_1 Col_2 Col_3 Note
A1 B1 C1
A1 ...
1
vote
0answers
186 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
2answers
346 views
Is it possible to join derived tables to actual in Access 2007
Is it possible to join derived tables to actual tables in Access 2007 like in SQL Server 2008? I have an example below:
SELECT *
FROM
--MyOtherTable is a "real" table
MyOtherTable ...
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 ...
0
votes
1answer
446 views
Access 2007 sql editor
Is there an ACCESS 2007 JET SQL editor or client (not sure the right term is) that can be used to code Access Jet SQL queries? It is very difficult to write SQL queries in ACCESS 2007 since it's like ...
0
votes
1answer
182 views
Write Access Client App for SQL Server 2005 Backend [closed]
I'm writing an inventory/payroll system, and I'm storing all the records on a remote server running SQL Server 2005 on Windows Server 2008 R2. I was wondering how I could start writing forms(very ...
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
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
2answers
301 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
197 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 ...
0
votes
1answer
413 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 ...
0
votes
1answer
107 views
Select products for an order via check boxes in Access 2010 [closed]
I have a lookup table where I have defined some products. I have another table that defines orders. This table defines which products is in the order by having a ID that is linked to another table ...
0
votes
1answer
130 views
Sorting Report entries on alphanumeric combination
I am trying to move over a database that was previously stored in an excel workbook. The previous setup had a different worksheet for each bookshelf and the individual shelves were listed at ...
0
votes
1answer
234 views
Select DISTINCT records with extra information
I have a MS Access database full of customer names and addresses. I want to send out a mailing but only one per address. Therefore if there are 3 different customers at the address I want only one ...
0
votes
1answer
247 views
Print filter parameters on a report
I'm using MS Access 2010.
I have a form with a number of fields of various types (number, text, lookup, checkbox).
Users can right click on any field to filter the form.
Then I have a button that ...
0
votes
1answer
186 views
access 2003 to sql server 2008
I search a way to export an access 2003 database to sql server express 2008.
the export is on la (other computer than the server).
the computer have office 2003.
the computer doesn't have admin ...
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 ...
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
46 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
51 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
142 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: ...
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 ...
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 ...
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 ...
