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

learn more… | top users | synonyms

3
votes
3answers
845 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
199 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
2k 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
876 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. ...
6
votes
3answers
411 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, ...
7
votes
3answers
1k 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 ...