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

learn more… | top users | synonyms

1
vote
1answer
98 views

Error at line 1, column 25: ORA-00923: FROM keyword not found where expected

I have some code that works in Access but now I want to forward the code to our IT department to make a view in our SQL database. Could anyone please help me convert it so it is correct for normal ...
1
vote
0answers
44 views

Need ODBC connection to postgresql to include materialized views

I have an Access front end user interface that links to tables in a postgreSQL database using the most recent ODBC driver. I can link to the postgreSQL tables and views but can't get to the ...
-3
votes
4answers
91 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 ...
1
vote
2answers
86 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 ...
0
votes
0answers
22 views

relationships in access

I am making the database design of my website in Microsoft Access 2013 because it has a nice user interface and I believe it will help me understand everything a whole lot better with the UI. I have ...
1
vote
1answer
53 views

Combining GROUP BY and JOIN

This seems like a really simple request, but I can't find the answer. I'll admit that I only have a very limited understanding of JOINs, so it could just be that I just don't fully understand the ...
1
vote
0answers
150 views

Permission Error when creating Linked Server from SQL Server to Access DB

I created a linked server from my SQL Server 2008 R2 64 bit Windows Server 2008 machine to an Access 2000 Database that resides on another server. The Linked server was created with no trouble using ...
0
votes
0answers
26 views

Help creating database schema to build database off

not sure if this is the right area for a question such as this but I am looking to create a database for an IS warehouse who deliver laptops, desktops, monitors and other peripherals to different ...
1
vote
1answer
36 views

“Network connection was interrupted” error with shared Access database

We have an Access database with a split front/back end. The back end resides on a Samba 4.1.6 share with around 15-20 users. Frequently the database will popup with the error "Network access has been ...
6
votes
5answers
378 views

SQL queries to only show most recent purchase records for individual food items

I'm working with a food purchasing / invoice system in MS Access 2013 and am trying to create an SQL query that will return the most recent purchase price for each individual food item. Here is a ...
0
votes
2answers
87 views

Access Database - Linked Table “Not Responding”

I have an Access 2013 database that has a local front end, and a network based back end. The database works fine for everyone. Network connections are usually pretty decent, so it's not so bad. Users ...
0
votes
0answers
47 views

Set-up Record Counter

I have a problem in the receipt DB I am hoping to get some help with. I have to track physical receipts from the database to the binder that houses them and vice versa. The Receipt Table has the ...
0
votes
0answers
102 views

Update form after append query runs

I have an item table called 350_ITest with ISort = vendor item no and GSort company Item no. I have to assign a new GSort to every new Isort. The form has an unbound field linked to the sub form. If ...
0
votes
1answer
73 views

Pulling data into Access from an external API

[Apologies in advance if this has been asked an answered elsewhere.] I have recently dived into Microsoft Access 2016 to handle a relatively small (but still too big for Excel) database with somewhat ...
0
votes
0answers
14 views

Access - two unique autoincrement values for project/task relations

im trying to make access database from which i will get data into excel sheet which will be shared for multiple users. In database i want to store project and task data (this data are nearly same so ...
5
votes
1answer
76 views

What is the meaning of this operator: *=

I have a very old Access application that uses SQL Pass-Through Queries. This application has been nursed along through multiple server upgrades, and we recently moved up to SQL 2012. I now get a ...
0
votes
1answer
244 views

MS Access: Update data from one table to another based on a choice [closed]

Help! I have a patient form where their referring doctor is chosen and that ID for the doctor is stored in a variable. When I click "Save record" I need it to copy the data form the ReferringDoctors ...
0
votes
0answers
32 views

Composite Primary/Clustering Key vs GUID for Merge Replication scenario

I need to decide on a primary key for my tables in a merge replication scenario (currently one laptop taken into the field during the day while another user works on a desktop; both users need ...
0
votes
0answers
74 views

How can I layout a schema that will track monthly installments?

I'm pretty new to database design and have a beginner's understanding of SQL, mostly simple SELECT statements. I find myself in a situation where I have to create a system that will track monthly ...
1
vote
0answers
48 views

Invoice Number Generation

I started a small business and have created an accounting DB with advice from my accountant. In Part of my business I generate invoices for the same customers every month. I use a unique invoice ...
0
votes
1answer
37 views

Referring to a network location without volume label in VBA for Access 2013

I run a database at work in Access 2013. The VBA corrupted after a day from the amount of people using it, so I attempted to split the database to solve the problem. The split worked after I ...
0
votes
2answers
39 views

What would cause an UPDATE statment to hang when executing from an .mdb file to SQL Server 2008 R2 over ODBC?

Is there anything that would cause an UPDATE statement INNER JOINed between a separate MS-Access linked table and an SQL Server 2008 R2 table to hang, when the values are being set on the SQL Server ...
0
votes
0answers
51 views

MS-Access linked tables Azure intermittent connection failure

I have an MS-Access front-end with linked tables to Azure SQL db. It has been running for about 6 months without any major problems. In the last week I have had increasing intermittent connection ...
1
vote
1answer
117 views

ADO connection suddenly starts failing Intermittently

I have an Access 2010 front end connecting to a SQL Server 2014 back end. I've got SSMS 2014 installed on my machine, and everything was working fine. (Running Win7 64-bit with 64-bit Office.) Long ...
0
votes
0answers
37 views

Convert Access query to SQL Query

I am converting Access query to SQL server. I want to convert below lines to SQL 1. Format (210.6, "Standard") 2. Format (210.6, "#,##0.00") How do i convert it to SQL query. I have tried with ...
-1
votes
1answer
81 views

How do you translate this into SQL Server 2008 statement?

I'm not sure how to translate this from Access to SQL. We are currently using SQL Server 2008. I am trying to migrate Access reports into SQL views. SELECT ...
1
vote
1answer
46 views

Getting intervals between time from all succeeding rows? (Time is in text data type)

NAME DATE TIME INTERVAL a 10/19/2015 5:00 PM a 10/20/2015 5:00 PM 86400 a 10/20/2015 5:30 PM 1800 This is easy to do in Excel. But considering we ...
0
votes
1answer
40 views

Select Unique Fields with Max Values in Each?

I have a table with names, numbers, and timestamps on the data. I want to know how to select a unique instance of each name based on how recent the timestamp is. Addy (text), NW (number), UDate ...
1
vote
1answer
72 views

leading 0 missing in column when exporting to csv

I have a query I export which is then used to import products into our website. One of the ways we help people find products more easily is by using a long and short item code. It's basically the ...
1
vote
0answers
5 views

select Concatenated field in Access Form [closed]

I have Created a Report whith a Listbox which contains concatenated fields: Cname: SELECT tbl_Employee.GID, tbl_Employee.Sname, tbl_Employee.Gname FROM tbl_Employee ORDER BY tbl_Employee.Sname, ...
0
votes
0answers
35 views

Shared access database file connected with MySQL server

Currently I have an access database in a dropbox folder, used by a lot of people knowing nothing of IT and DBMSes (imagine them being grannies that just learned to use access after a course of five ...
4
votes
2answers
283 views

Loop through tables or copy paste

I have to do a migration where I should retrieve data from 40 Access tables, which should contain several of the same columns (but not all, the schemas are different). To make it simpler, I used SSMA ...
1
vote
1answer
150 views

Linked servers on SQL Server 2008 R2 through linked tables in MS-Access?

We have a really old data source (file-based) in Visual FoxPro, that we currently use via linked table through an ODBC data source. Recently, we started having an issue because the latest update to ...
17
votes
3answers
398 views

Access (Jet) SQL: DateTime stamps in TableB flanking each DateTime stamp in TableA

First Words You can safely ignore the sections below (and including) JOINs: Starting Off if you just want to take a crack of the code. The background and results just serve as context. Please look at ...
0
votes
1answer
34 views

How do I corrupt an mdb intentionally for test purposes

I'm creating a process to check for corrupt tables in an MDB on server. There's no code, just tables. I would like to corrupt an mdb intentionally for testing. Has anyone ever done this?
1
vote
1answer
30 views

MS Access 2010 adds unwanted wildcard at end of select clause

MS Access 2010 has a vey weird behaviour for me. Whenever I create a new Query, it silently adds a wildcard (i.e. ', *') to the end of the SELECT clause. The wildcard is visible only in the SQL and ...
0
votes
0answers
153 views

Converting SQL Server query to MS Access

I have the following query in SQL Server: SELECT p.Company Advertiser, COUNT(DISTINCT t.ID) [Sales Call Count], COUNT(DISTINCT j.ID) [Job Count], 100.0 * COUNT(DISTINCT j.ID) / COUNT(DISTINCT ...
0
votes
0answers
52 views

Merge two data tables with different time preferably in access

I appreciate if I could help on this issue. I am relatively beginner to database designs. I have two tables (see link below) which I would like to combine: Tbl_1: Date, Product, Sold Tbl_2: Date, ...
1
vote
0answers
474 views

SQL Server 2014 Import Wizard missing data source option

I have already run the upsizing wizard from my production Access 2010 .accdb database to create all the table structures and move the data on to our new SQL Server 2014. This included adding some PKs ...
0
votes
1answer
31 views

Access 2013 update rows from multiple rows

I need help to construct an update query to populate MynewField with contents from multiple fields and rows where the MapID is the same. RowID---MapID-----Extension----- Name------ MynewField 7 ...
3
votes
1answer
707 views

Designing a simple library database

I am currently developing a simple book library system in ms access 2007 and need some help with the database design. I want to register books, borrowers and loans, so I assume that my database could ...
1
vote
1answer
38 views

Query - Match Name to Multiple Unique Types

I'm trying to create an Access 2013 database query to display all insurance policy holders that have more than one type of insurance. I am not interested in policy holders that have only one type of ...
1
vote
1answer
118 views

How to password protect a field in access?

I'm looking to password protect a field in my database containing confidential customer information. Is there a reasonable way of doing this in a timely manner? Thanks
0
votes
2answers
48 views

Useful formats for the results of a database “audit”? [duplicate]

My company has tons of disparate databases - Oracle, SQL Server, and (shudder) MS Access - lying around, and the CIO wants to bring in a third party to track them all down and document them. But, ...
1
vote
0answers
105 views

MS Access 2010 report - SQL pivot query WHERE criteria not working

I have created a report that has a list of actions which are populated from an "Actions" table. (See Below) However, each action will have multiple updates populated from an "Updates" tables and I ...
4
votes
2answers
100 views

What flavor of SQL is used inside Microsoft Access?

I don't have much Access experience, and I took on a new Access project. I can use SQL to query the Access databases. What SQL specification/flavor is used inside Access? Is it the same as SQL ...
0
votes
0answers
82 views

VBA open SELECT query with parameters

How can I open a SELECT query with parameters using VBA? There exists some useful information on running insert or update queries with parameters, but the same principles don't seem to work when ...
0
votes
1answer
97 views

Linking MS Access 2010 to Outlook Inbox: Including Attachments

I'm trying to set up a MS Access table linked to an Outlook folder. I've been able to use the external data wizard to set up a linked table, but the table seems to only include subject lines and ...
1
vote
0answers
19 views

MS Access : Navigation pane is suppressed

I received a MS Access form client. It is in access 2007 format. Initially Navigation Pane was not available. Only form was visible. Then I choose options->Current database->checked Display Navigation ...
2
votes
1answer
82 views

Should I maintain relationships diagrams in the back-end and the front-end?

I’m developing an Access 2010 database application. It is split into a back-end, holding all the tables, and a front-end, holding all the queries, forms, etc. I find the Relationships tool helps ...