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

learn more… | top users | synonyms

1
vote
1answer
170 views

Install Access Database Engine on Linux Centos

I want to read mdb file from linux centos. To read that file, we must already install access data engine. Is there any access data engine for linux? Now I'm using mdbtools to configure ODBC connect ...
1
vote
1answer
84 views

representation in ms-access

I have a database in microsoft access. I want to know how to look up a singular datum from a reference table giving a dynamic set of values. Here is a representation of what I mean: I have the ...
0
votes
0answers
10 views

Make a field in a form that count values [on hold]

i have a form that`s named classes and has a sub form named assignments i would like to create a field that will count the values in the sub form how much descriptions is in the assignments sub form ...
0
votes
0answers
14 views

Deploy existing ms access file with forms as web application

We are using the following: a ms access file with local tables remote tables which are connected through the odbc connector to a external mysql database with many forms When using the ms access ...
2
votes
0answers
49 views

Moving data from MS Access to MS SQL Server

I'm trying to migrate data into SQL Server from an existing legacy set of MS Access databases. Currently everything is working except a few core tables that are wide and contain a number of ...
0
votes
1answer
80 views

Handling empty fields

SELECT Name, SUM(Switch([Date] = DateAdd('d', - 7, DATE ()), NetAmount) )AS DAY1 FROM Customer GROUP BY Name My question is how to return the value 0 when the date is not present (an empty field). ...
0
votes
1answer
159 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
121 views

How to UPDATE/DELETE/INSERT with Microsoft.ACE.OLEDB.12.0 as Linked Server in SQL Server 2012?

I need to update an Access 2003 database from SQL Server 2012 with the Microsoft.ACE.OLEDB.12.0 provider. As an administrator, everything works great. I can do Select, Insert, Update and Delete ...
0
votes
1answer
168 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 ...
0
votes
2answers
237 views

Access 2003 (SQL Server 2000) migration to SQL Azure

As my old Windows 2003 RAID controller started throwing errors, I am seriously thinking about switching current Access 2003 (adp/ADO) clients to use a Windows SQL Azure solution, in place of current ...
0
votes
0answers
6 views

Access Form Help. Similar Match in 1 Table, Alter Another Table

I have two tables (Access 2010). One with a list of names (List1) and another with a very similar list of names (List2), but they differ in very small ways. For example, List1 might have John Smith, ...
0
votes
1answer
252 views

Access 2010 After Insert data macro to update another table

I have an Access DB with 3 tables. Table 1 Appointments Fields with Data that is not used anywhere else, but some of the information is inserted into 3 with a after insert Script. Table 2 Usage Data ...
0
votes
1answer
118 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
0answers
17 views

Building an economic time series database with aggregation/dis-aggregation capabilities

I am trying to build a database in MySQL and MS Access that contains economic indicators and financial time series. Initially, I wanted to solve the problem by setting up a table for each major ...
0
votes
1answer
494 views

Grouping and counting rows by existence of matching criteria in any of several columns

Disclaimer: I've inherited a database which is probably not quite as "normal" as I would like, and I'm limited to Jet/MS Access 2010 for my db backend and interface, as well my choice of reporting ...
0
votes
1answer
69 views

How do I count and order by unique entries?

I have this: SELECT tblClient.[Printed Name], tblClient.[Address 1], tblClient.[Address 2], tblClient.City, tblClient.State, tblClient.Zip, tblClient.Phone, tblClient.[Email Address] FROM tblClient ...
0
votes
1answer
75 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
985 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 ...
0
votes
1answer
165 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
19 views

Additional info on some rows in the table

I am trying to design an MS Access 2013 database to keep track of an inventory of items. All items have certain common properties, like name, date they were stored, location of the physical item, ...
1
vote
1answer
529 views

Convert SQL Server query to MS Access syntax

I have this query in SQL Server: SELECT Dated, AccountID, AccountName, Rate, case (when (Credit-Debit) > 0 then Credit-Debit END) as Credit, case (when (Credit-Debit) < 0 then Credit-Debit ...
2
votes
1answer
43 views

I am Trying to Write an Access Query to Get a person having a First Name and Last Name but not all People having any of those names

I am using Microsoft Access. In my search form I have 3 text boxes that I enter text to search for: First Name; Last Name; Last 4 of SSN. With the current query when I enter text into multiple boxes ...
0
votes
2answers
26 views

Should I backup or copy

Access has the option of creating a backup of dbase, but is there any difference between doing this and 'saving database as'? Thanks for your time and patience for the ignorant.
0
votes
0answers
29 views

Left Outer Joins in Access

I'm working on an existing Access database trying to implement some changes which will allow the estimation of cutting times for my employer (We're an industrial company who fabricate Flight Cases). ...
0
votes
1answer
23 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 ...
1
vote
1answer
36 views

Find and Replace performance issue

Table 1: linked native access table Table 2: linked pgsql table Both tables have same records but searching for a record using built-in Find and Replace dialog box in selected field is a lot lot ...
2
votes
1answer
68 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
1answer
107 views

MS-Access vba sql update where not working

I am having trouble with an MS-Access VBA sql update command. I have a form which has a combobox of GroupMembershipIDs, and a button. I am trying to write code which will iterate through the ...
1
vote
1answer
83 views

Query performance issues

I need help in improving the performance of the following query. It has the purpose to select one record out of a group of records with an identical ID (doublettes). Rules are that Date2 must be the ...
0
votes
1answer
179 views

Applying normalization to a relational Database (Access & SQL Server)

This question is pretty specific but I hope it can get answered on here. There is a wide range of information about normalization but I feel what I have read so far isn't as effective as just stating ...
0
votes
0answers
126 views

Importing OLE Object from Access to SQL Server

I am trying to import a table from MS Access to MS SQL Server which contains a BLOB field which contains a .zip file. The zip file has two images. This field is null sometimes. I am using the Import ...
0
votes
2answers
72 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
1answer
45 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 ...
0
votes
0answers
68 views

Update Duplicate record in select query of access

I have a select query (test) in access with below mentioned column ID 2561 2562 2563 2343 2561 2563 2563 Now in ID, i have duplicate records , for example here 2561 , 2562 , 2563 are ...
0
votes
0answers
32 views

How does indexes work on an Access query

I'm working on an Access 97 Db and I'm trying to speed up some low performance issues, as of right now I'm wondering how indexes works in Access. Using this table with 300k rows i get awful results ...
1
vote
3answers
569 views

convert nvarchar to int

I have a table in access linked to SQL.I am doing a query where I am using a field named comment from this table. The field is designed in SQL as nvarchar(255) . I am writing integers numbers in this ...
0
votes
3answers
56 views

Column A or Column B required MS Access DB

I'm in the situation where I would like to enforce the requirement where a record must contain either one column or another at a data level, I'm not sure whether it's achievable. I've got an Enquiry ...
0
votes
0answers
36 views

MS Access using MYSQL database and error in SQL (memo, hyperlink OLE)

I have a SQL statement that works fine in MYSQL workbench but when used in Access it produces a "invalid Memo, OLE or Hyperlink Object in subquery 'custom_values.value'. SELECT ccr1.value, ...
0
votes
1answer
32 views

Access not reading extended parameters

We have an ADP Access 2010 project, linked to a MS SQL 2012 server. I am trying to set up a table that has a combo box to select appropriate values, which are supplied by another table. A table ...
2
votes
1answer
93 views

Importing external data with specific time format into MS Access

I need to import data from a flat file to MS Access. Part of the data is time information in the format HH:MM:SS.SSSS (i.e. 24-hour time, fractional seconds). I have tried all of the standard time ...
0
votes
0answers
54 views

MS Access database corruption

I have been searching for an answer to this, but no luck. Has anyone ever seen the below error when loading an Access 2010 database? "[database name] has detected corruption in this file. To try to ...
0
votes
1answer
47 views

Creating a database base

I'll start of with what I have already: I've learned at uni how to create databases and now I'm trying to create my own for personal use and possible use for my customer base. The people I work for ...
0
votes
1answer
97 views

Alternative to sub query in MS Access

I'm looking into the possibilities for writing queries in MS Access, as my client currently uses Access and would be reluctant to move away to SQL Server. I've been using the data macros (which are ...
1
vote
1answer
24 views

Easiest way of porting data into a database

Recently, I received a lot of information from one of my friends who made a quiz type program. He asked me to help port it into an Access database. His program places all the info in a grid; around ...
0
votes
1answer
35 views

Access write conflicts with views and insteadof triggers?

I have a legacy linked table in a msaccess database that is linked to a sql-server table. The linked table is being synced periodically to a different set of tables that have been split up for ...
0
votes
1answer
59 views

What are the problems with sharing an Access database through online storage service, like Dropbox?

I have a desktop database I created in Access. I'd like to share the database with a single collaborator, who can have full privileges to the database (table access). However, my collaborator is much ...
0
votes
1answer
39 views

Which version of VB does MS Access use?

Which version of VB does MS Access use in the code editor? Is it VBA, VB.Net, other? I sometimes get confused when searching for help/solutions. For instance, in Access, you can't do: Dim s as ...
0
votes
2answers
284 views

MS Access .mdb & .ldb database corrupted

I am using a A.mdb database. You know when connecting the database Microsoft automatically create a .ldb file. Unfortunately my pc shutdown when connecting the database. As a result after restart the ...
0
votes
0answers
56 views

Allowing certain users to edit drop-down list values

Current situation: I've created a purchase orders database application for a company in MS Access. The data is stored in a back-end database on a server. There is a front-end master copy on a ...
0
votes
1answer
48 views

Concatenate 2-3 table field values in 1 table field in access

I have a project that in Access. The problem is I am a newbie in this application and I really couldn't figure out what to do, I have checked out several ways but am still stuck. I'll be handling a ...