Microsoft Access is a relational database management system that is part of the Microsoft Office suite.
2
votes
2answers
2k views
Database to track employee performance
This is going to be very basic as I'm a complete newbie when it comes to database design.
I've been tasked with setting up a way to track employee data over a number of months and potentially years. ...
1
vote
3answers
371 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
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 ...
4
votes
1answer
393 views
How to perform the dreaded double hop with linked servers?
The situation:
I have SERVER1, SERVER2, ACCESSDB on SERVER3.
I have successfully created a linked server connection from SERVER1 to SERVER3's ACCESSDB.
I want to be able to access the linked server ...
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
480 views
Ms-access ODBC calls for linked table behaviour
I'm curious if anyone knows how ms-access goes about generating ODBC calls for linked tables.
The reason I ask is that I'm trying to make the front-end of a system super efficient and too minimise ...
3
votes
3answers
670 views
Database Performance Tuning
I have a MySQL backend, MS Aaccess front-end system that is nice and responsive over a local network but becomes sluggish over a broadband connection. I haven't done any performance tuning as of yet. ...
4
votes
2answers
170 views
Concurrency question?
I have a MySql (5.5) database with a MS Access frontend. If two users are viewing the same record at the same time how can I make each user aware of each other? For example how would I go about ...
4
votes
1answer
1k views
Using a Parameter Query to generate Charts in MS Access Reports
I am using Microsoft Access 2007 and I have a query which looks something like this;
PARAMETERS Identifier TEXT(255);
SELECT
DateDiff('h', (SELECT Min(SampleDateTime) FROM Specimen WHERE ...
1
vote
1answer
771 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.
...
0
votes
0answers
372 views
Best online database [closed]
My wife is running a childcare company. We employ people who offer childcare in their home.
We have today a Microsoft Access database where we add information about our employees, our customers ...
5
votes
3answers
332 views
Online resource for writing Access SQL statements
I am looking for an online resource for writing Access SQL statements. I write queries using SQL because the UI puts limitations on what can be queried. I have been using w3schools for reference, ...
6
votes
3answers
853 views
How to log data changes in Access at the table level?
I support an Access database for a non-profit organization. We have some issues with data mysteriously changing, and there been some, um, friendly debate over whether this is caused by users who are ...
