What's the deal with Deno? We talk with a major contributor to find out. Listen now.

Questions tagged [ms-access]

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

Filter by
Sorted by
Tagged with
8
votes
5answers
14k views

Can I be automatically notified of prolonged blocking in SQL server?

About once a week I have to resolve a blocking chain on a SQL Server 2005 database, caused by a long-lived read lock from an Access 2003 front-end. The lock is taken out whenever a user opens a ...
4
votes
1answer
25k 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 ...
3
votes
3answers
17k views

Easiest way to import access db (.accdb) into SQL Server 2016?

I have a .accfb file from an access 2016 database and am trying to import this database into a SQL Server 2016 developer edition instance. While I found posts online discussing using import/export ...
7
votes
1answer
11k views

MS Access database in a network

I would like to ask if MS Access database supports working in networks & multi-user access?
3
votes
2answers
6k views

Best design for a tree-like structure database

I'm designing a database in MS Access which is used for tracking the locations of a variety of chemical solutions, made in batches. Each batch can be split (aliquoted) practically indefinitely. That ...
3
votes
5answers
2k 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 ...
2
votes
1answer
248 views

MS Access + SQL Server for 1160 users - Is it worth it? (Please Help!) [closed]

Our school in Delhi (India) wants to develop a professional and robust in-house database (SIS) that should handle vast amount of student information, including admissions, registration, re-enrollment, ...
1
vote
1answer
586 views

Access 2007 Work in a separate file using ACCDE

Have been working in an Access 2007 application for over 3 weeks and it should be ready now. Anyway, I know (and tried) that "Make ACCDE" can actually split the raw data from the application itself so ...
1
vote
2answers
223 views

Finding the names and the year of the movies that have at least 5 actors

Given database of the website "eMovies" that manage data about cinema movies. Write in SQL query that finds the names and the year of the movies that have at least 5 actors. My attempt: The idea:...
3
votes
1answer
11k views

How to get the equivalent of array or string GROUP BY aggregate functions in Access?

From SQL Aggregate Functions (Office 2007) there are only these GROUP BY aggregate functions in Access SQL: Count(), Sum(), Avg(), First(), Last(), Min(), Max(), StDev(), StDevP(), Var(), VarP() ...
5
votes
2answers
45k 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 ...
4
votes
2answers
2k views

What principles should I follow when entering data into a complex relational database?

I'm new to Databases, so forgive me if this is a basic question. I'm attempting to parse a complex open source dictionary, and output the data into an Access database, which is equally complex: I ...
2
votes
2answers
2k 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 ...
2
votes
2answers
9k 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 ...
2
votes
1answer
1k views

Trace ODBC commands: What is the registry path for TraceSQLMode and where is SQLOUT.TXT?

In the Optimizing Microsoft Office Access documentation, it mentions that we can: ...edit a Microsoft Windows registry setting that allows you to see the commands that the Office Access database ...
1
vote
2answers
98 views

Help with Access many-to-many relationship (beginner)

I'm a beginner with MS Access hoping for some help with a database I am trying to create. This is (will be) a database of land parcels in a given area, and their associated landowners. Here are my ...
4
votes
1answer
80k views

IF IS NULL then SINGLE else keep the value of the field

I am working with a DB in Access and I'd like to be able to fill the field in this row with a result of SINGLE if it is not already filled with another value. I wrote Iif(MaritalStatus) is null, "...
2
votes
1answer
99 views

Fill percentage of total field with MS Access SQL

I am trying to fill, with a SQL query, a field F with the percentage over the total of some field f, such that each record F(i) in field F is given by: F(i) = f(i)/SUM_i(f(i)) Both fields f and F ...
2
votes
2answers
40k views

Combine multiple row's records in one row with MS Access Query?

I have a table (name- tbl2) with 21 column but I want to combine multiple rows records in a row by using a unique reference number as below: Table Field and Records Type Expected Result: Please ...
1
vote
1answer
18k views

Query Multiple tables in MS Access

I have three tables: Table City has Two columns: City_ID, CityName <City_ID is Primary Key> Table Accommodation has Two Columns: Accommodation_ID, CategoryType <Accommodaton_ID is Primary ...
1
vote
1answer
107 views

Totals on alias columns

I have a table in MS Access that has the following fields/data: School number Traditional Forms Sparring Traditional Weapons Combat Weapons ------------- ----------------- ---------------...
0
votes
1answer
559 views

MySQL read only slave - how to create views

After a lot of resistance I have recently been given MySQL access to our CRM system, via a read-only slave. I have an issue now in that I am really limited to what I can do with the data in MySQL - ...
0
votes
2answers
39 views

MySQL Allows ODBC With Any Username

I have a MySQL Community database on a remote server and I am trying to get Microsoft Access to read data from it. This data is sensitive. The problem is, MySQL doesn't care about the username that I ...
0
votes
2answers
700 views

Help with preventing double bookings with variable lengths

I'm designing a sample database for a venue where members can create bookings for venues. I'm looking for a method to prevent double bookings (possibly by creating a button on a form that checks ...
0
votes
1answer
8k views

Remotely Connect to MySql from MS Access

Does anybody know if it is currently possible to remotely connect to a MySql server from MS Access? What does one need to do to go about doing this?
0
votes
3answers
3k views

Querying a many to many relationship in access

I have just created a many to many relationship in MS Access with three tables as shown below AE Career Fair - Struc contains a list of companies where the company name is distinct. Office Locations ...
-3
votes
4answers
284 views

Number of movies that belongs to comedy genre and also belongs to animation genre

Given database of the website "eMovies" that manage data about cinema movies. Write in SQL query the number of movies that belongs to comedy genre and also belongs to animation genre. The tables: ...
-3
votes
3answers
2k views

Finding the most common genre for “eMovies”

Given database of the website "eMovies" that manage data about cinema movies. Write in SQL query the most common genre (that have the biggest number of movies) The tables: Actors ActorID ...
-5
votes
2answers
5k views

Query that finds the names of the directors that played in movies that they directed

Given database of the website "eMovies" that manage data about cinema movies. Write in SQL query that finds the names of the directors that played in movies that they directed The tables: Actors ...