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

learn more… | top users | synonyms

0
votes
2answers
90 views

How do I translate this query from MS Access into SQL Server

How do I translate this into SQL Server: select -Sum((12=[GroupNum])*[BoardStatus]) AS G12 FROM QryAllBoardsByPacketIDs INNER JOIN tBsReportGroups ON ...
0
votes
0answers
95 views

Microsoft Access Query: “System resource exceeded”

I have a simple query in my DB and I received this error message: "System resource exceeded". But the query is really simple! Here it is: PARAMETERS [@FILTRO] Text ( 255 ); SELECT [POLIZZE ...
1
vote
1answer
34 views

Product table with possible duplicate part numbers from different manufacturers

I am making a database. It has a product(aka component or part) table with a ID, ManufacturerID, and PartNumber. The ID is obviously the primary key and is unique. The ManufacturerID is pulled from ...
1
vote
0answers
90 views

Converting Query to Pass-through query [closed]

Below query is row source of a form with a list box and some fields for search. the tables are linked in sql server 2008. it works fine. I am trying to convert the query to pass-through query as the ...
1
vote
1answer
1k views

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

I am in need of a query string assistance please. 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 ...
0
votes
1answer
45 views

“key violation” when trying to import data into MS Access

I am trying to import data into an MS Access table from a flat ASCII file. I've done this many times before but now I am getting a "key violation." There is only one key in the table and it's an ...
0
votes
0answers
106 views

Spotting foreign key relations in a database that doesn't define all relationships as constraints?

At work I use a rather old MS Access database which defines some relations between tables, but does not outright define all of them. If the database application used an ORM, I would think that this ...
0
votes
0answers
101 views

Are heterogeneous joins between MS Access and SQL Server tables really so bad?

I'm developing a multi-user Access 2013 application with an Access backend on a fileserver. At first I'm going to finish my stable Access application which works fine for the moment. However, I plan ...
0
votes
1answer
54 views

Access ('07 -'10) form is not showing entered records

I have a form that I enter data into that is broken into a number of different tables for normalization. However, once I reopen the form, only the first record is shown. I have it set as "single ...
1
vote
1answer
1k views

How do I connect my MS Access database to the LAN? [duplicate]

I wrote a database program in MS Access a couple of years ago, and it is used to keep track of some personal stuffs. I now want to expand this personal project and allow several computers to have ...
1
vote
1answer
421 views

Cannot add or change records

I'm designing a database structure wherein I like to apply the concept of inheritance. There's a base tables and derived tables in which the relationship is one-to-one. I'm quite new as of how could ...
2
votes
1answer
2k views

Time out errors - MS access front end with SQL backend

First of all I don't know anything about SQL, so I apologise if I make no sense. I have created a MS access database and our IT area migrated the tables to SQL server 2008 and linked the tables to ...
1
vote
1answer
558 views

VBA @ Access on replacing values on a huge list

I have a question (that's why I'm here actually :P ) about VBA @ MS Access. So, I have a huge database (well, for me it is huge, about 23K+ ID) on shoes. It has 5 columns: ID, Article number, size ...
0
votes
1answer
140 views

Sql statement to count sum and campare it with another table

I would like to write an sql statement in microsoft access that group items and count their sum in order to compare it to another table I have two table like below : Product: list of demanded ...
0
votes
1answer
205 views

sql statement in access that group items and count their sum

I would like to write an sql statement in microsoft access that group items and count their sum My table is like below : id : Auto-Increment Items : String Quantity : Number Eg : id | Items | ...
1
vote
0answers
313 views

How to upload a PDF to Access database?

I have 100+ pdf files that I would like to load into an access database. When the pdf is uploaded, I would like for the data retrieved to update in an access form. How to do that?
0
votes
1answer
249 views

Randomly failing SQL Server 2008R2 used by Access 2010 front-end via ODBC

From time to time (sometimes days apart, sometimes several times a day) users of a multi-user Access front-end, which has ODBC connections to a SQL Server back-end, see a variety of problems. Most ...
1
vote
1answer
65 views

Translating a query from MS Access to SQL Server

I have a legacy query from years ago that was written for an MS Access backend: DELETE category.* FROM category LEFT JOIN product_category ON category.id = product_category.categoryid ...
0
votes
1answer
105 views

How to link a MySQL Table with a binary key into Access?

In MS Access I've created a linked table via ODBC to a MySQL table with a binary(16) primary key column (UUID). MS Access only shows the first row, all other rows have #deleted entries. I guess the ...
1
vote
0answers
147 views

Link up an ms access database to SQL Server 2008 R2?

I've installed the OLE DB Provider for JET by downloading this and installing it. I closed and reopened Microsoft SQL Studio, and connected to my SQL Server Instance. In <instance-name> ...
1
vote
0answers
50 views

Microsoft Access database performance

I wonder how MS Access manage to show long list of records when we want to browse theme in Datasheet view. 1 - Does it load limited amount of records on start-up and then load the remainder upon user ...
0
votes
0answers
523 views

SQL query to return a column per date in date range with sum of contract utilisations (value/duration)

My question is similar but more elaborate than another already in stackexchange.com "SQL query to return a column per date in date range?" I have the following data: Customer Start_date ...
0
votes
3answers
9k views

MySQL vs. Microsoft Access [closed]

I'm trying to aggregate about 500-1000 MS Excel files that deal with various small business issues (inventory, purchase orders, etc) and I'm currently trying to decide what kind of RDMS I should use. ...
0
votes
3answers
242 views

How to create an Access query to find # symbol into a field?

It seems easy but I'm missing something. I have a MySQL database that is connected from access through ODBC connector. I'm looking for the fields where there are # symbol but I'm getting zero ...
0
votes
1answer
174 views

How to shift a value one record 'down'

Suppose we have a field ("Flag"). How we can shift records of this flag in another field ("ShiftField") by using SQL code? See the example: ID Flag ShiftFlag 1 0 2 1 0 3 1 ...
0
votes
1answer
126 views

Access Database that is shared with my company on a network drive..When I copy and paste it to my desktop there linked some how?

I have an Access Database that is shared with my company on a network drive..When I Click on the drive and copy and paste it to my desktop and make changes to it the database that is on the drive also ...
0
votes
1answer
45 views

Ms Access SQL problem

in this table Customer is actually storing CUSID (i have pleased the caption customer and made it display the name to which the CUSID corresponds to) now in the CUSnum field i want it to ...
0
votes
0answers
84 views

How can I number my groups using an Access “Find Duplicates” Query?

I have a query created by the MS Access 2010 find duplicates wizard. It is: SELECT * FROM fbExpenses WHERE [expense_date] In (SELECT [expense_date] FROM [fbExpenses] As ...
0
votes
1answer
6k views

How to convert sql server table data into MS Access(.mdb) file

I have SQL Database table with 6664055 rows, I want to convert this SQL Server table data to MS Access format(.MDB), How Can I do this?
-2
votes
6answers
867 views

Missing import function in SQL Developer like MS Access has

At my work we used to use MS Access now we are forced to use SQL developer to create queries and export the data. Details: We can only query to the database We cannot create a new database We use ...
1
vote
0answers
150 views

Combine a running balance SQL statement as a column

I have two Select Statements which are collecting data from 1 table, one is a totals select statement. Could anyone assist me with combining them into 1 statement? Any assistance is appreciated ...
0
votes
2answers
201 views

Separating a date column in Access into Month, Day and Year while keeping the new columns ordered by a seperate column(primary key)

I have a column titled DateOpen which lists the date files were opened in d/m/yyyy format. I want to split the entries in that column into new columns titled MonthOpen, DayOpen and YearOpen while ...
-1
votes
1answer
34 views

Grouped Data tracking [closed]

I have a MS Access Database that tracks clients, client regions and transaction types. Users are keying in transactions and once done, the system needs to create letters to the client regions ...
0
votes
1answer
1k views

SQL Query: Join Tables using two partial string matches

Using MS Access, I have to combine two tables where two criteria must be met: Container = Container AND Booking = Booking. I have two tables where fields are missing a value: Table1 and Table2 have ...
0
votes
1answer
150 views

Calculating Open Days field and stopping with status change

I had a question but wasn't sure where I needed to post or view if someone has done this before. I have a dilemma on my hands. Background Info: I have been trying to figure out what to do since I ...
0
votes
1answer
265 views

linked server hanging

We've been using a linked server to an access database for close to a year now with little issue. Now when I run a select query against the linked server the query sits there and never finishes. ...
1
vote
0answers
611 views

In the Import/Export Wizard inside SSDT, why is the MSAccess DB Engine data source looking for a workgroup information file?

Running MSSQL12, VS10 Shell, MSA2013 with local .accdb files, Microsoft Access Database Engine 2010 Redistributable (x86_64) and Microsoft Access Database Engine 2007 Redistributable (x86) installed. ...
0
votes
0answers
129 views

Attendance Database using sql in MS Access

I'm currently working with a simple database for the attendance of the professor in our college. I'm using MS Access 2010 with a Main table that includes the Attendance log of all the professor with ...
0
votes
1answer
2k views

VBA Maximize Access Application Main Window

I need my access application window to open up in full screen. I have tried using: DoCmd.RunCommand acCmdAppMaximize and DoCmd.Maximize (which I think only maximizes a Form). Neither is working ...
2
votes
1answer
167 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, ...
0
votes
1answer
380 views

Importing data from MS Access database to an existing Postgres database

I'm developing a Django based website with a Postgres DB. The problem I'm having is importing the data from an Access DB into it. To be specific, I'm not trying to translate/import the schema from ...
0
votes
4answers
610 views

Can migration from MS Access to SQL Server or … make database faster? [closed]

A company asked me to migrate their database from MS Access to SQL Server or MySQL because they think that on those engines their database will run faster. But I wonder if their problem isn't because ...
2
votes
1answer
80 views

False positive error message in MS Access (concurrent users)

I have discovered a strange apparent bug in MS Access and would like to know if others know it already and hopefully how to get around it. Trying to count records based on known column categories. ...
1
vote
0answers
201 views

Pivot table with many columns, a bad practice?

I am constructing a pivot table with many columns (300) and I wonder if I this is a bad practice. Here are some details why I need to contruct this table. A (very) simplified presentation of my ...
1
vote
0answers
204 views

MySQL Link to PHPMyAdmin/MS Access

I have a mysql database stored on a server via phpmyadmin. I want to link this to MS Access for other users. I often link mysql databases to MS Access which are stored locally, but never DB's stored ...
0
votes
1answer
873 views

Deleting Record from Linked Table Slow in MS Access

I have a Microsoft Access database that is linked to a SQL Server 2000 backend. It has one form with several subforms, all using information from linked tables. When I try to delete a record from one ...
0
votes
1answer
35 views

Access: search for more than one parameter?

I need to perform several queries, looking for more than one parameter. for example: in my field "lenght" I want to extract values matching both 4.6 and 4.7. then, next time I need 5.8 and 5.9, and ...
1
vote
1answer
167 views

Access Linked Tables and Their Network Connections

I need to know some simplistic details about how Microsoft Access' linked tables work. I think I know the answer, and this question is more about asking for a confirmation than anything else. A ...
0
votes
0answers
135 views

Populate the columns of one table with the records of another

I have one table, FRUIT, describing some measurements that I make: ID Tag Amount Units 1 A 75 Apples 2 B 23 Bananas I would like another table, HISTORY, that tracks the ...
1
vote
1answer
4k 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 ...