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

learn more… | top users | synonyms

0
votes
1answer
74 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 ...
0
votes
3answers
84 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
68 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 ...
2
votes
1answer
422 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
1answer
910 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
29 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
75 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
513 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
0answers
136 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
2answers
166 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 ...
0
votes
3answers
31 views

Column Concatenation

Is it possible to concatenate the rows from two/more different columns into one new column ? Example: C1 C2 C3 ---- + ---- => ---- a d a b e b c f c ...
0
votes
2answers
63 views

In what way are Access tables linked with SQL server?

I have a mdb file with lots of OBDC linked tables that are linked to the tables in SQL server elsewhere. I can not see any information on how they are "linked". It is a little scary not knowing ...
1
vote
0answers
29 views

How to append records from one complete table into a partly populated differently formatted table?

I have two tables of interest linked in a MS Access 2007 database. The master table called EMPL_MASTER (from which I only have read access, I cannot make changes) updates every time a system ...
0
votes
0answers
114 views

Converting Microsoft Access to Libre Office

Is there a method of converting a Microsoft Access (2010) Data table to a Libre Office Base table? I should like to get rid of Microsoft and concentrate on using Ubuntu but I have a lot of data that I ...
0
votes
1answer
67 views

Update query for Minimum absolute difference in Access [SQL]

I have 3 tables in an Access db. Table_1 and Table_2 are where the source data comes from and I am filling Table_3. Table_1 has the following fields: Acct_Name Amt Table_2 has the following ...
0
votes
0answers
145 views

Is it possible to automatically convert/load an Access database into a CSV or TXT file?

I'm working on moving an Access database to ultimately Teradata. Now I know that Teradata can't read Access files (.aacdb). So what a colleague has tried was manually convert one of the tables in the ...
0
votes
1answer
52 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
90 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
81 views

Query with a sequence of “and not like”

I have a table called VHS_Metadata_Aug52014 with columns: Title, Description,Tag, Speaker, VIP, FilmingLocation, Notes I'm trying to write a query that returns all records for which the word ...
0
votes
1answer
460 views

JOIN on Microsoft Access derived table not working

Can you please help me why my below SQL is not working in Access 2010? SELECT Table2.Product, Table2.Color, SEQMAX, Table1.Attribute FROM ( Table2 LEFT JOIN ( SELECT ...
0
votes
0answers
18 views

Disabling foreign keys

I am migrating data out of access and into MySQL but am having issues with access automatically detecting foreign keys and finding a description of the value from the foreign table. For example a ...
0
votes
0answers
66 views

Last few rows from a non-indexed table in Oracle

I'm trying to run a query on an Oracle DB through SQL Server [dont' ask, it's a requirement] The Oracle table in question [lets call it hugeTable] has over 200 million rows and no index. I'm not ...
1
vote
0answers
451 views

MS Access 365 When selecting Lookup Wizard, datatype is changed to Number

I want to create a relationship between my Contacts table & Ref_State table. Contacts table has field called State/Region which I want to make Data Type = Lookup Wizard Ref_State has fields ID ...
1
vote
1answer
687 views

MS Access query-by-form opening query, but not running it with new form data

I have created a query-by-form in MS Access. The form has a text field for each field in my table. I'm only using one starting out to test. The query criteria for that field is Like "*" & ...
0
votes
2answers
163 views

Split date time, with only time, into minutes and seconds

I'm creating an Access database from an excel file that contains metadata about vhs tapes and DVDs. The person who created the excel file had the running times as a date/time field in minutes:seconds. ...
1
vote
1answer
1k views

Combining count queries into one table row

I'm banging my head against the wall because I'm sure this is super easy. I have a few queries set up that get counts for a few related tables. This is for an arcade game tracking system. The ...
1
vote
0answers
44 views

Can I automate data pulling from VistA databases using MUMPS? [closed]

I apologize if this is on the wrong StackExchange website. This seemed to make the most sense because it's a database question and there's no longer a Healthcare IT site. I'm an intern at the VA ...
0
votes
1answer
1k 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
1answer
262 views

Access Sharing database over Network vs Mysql multiple users [closed]

Something no one mentions and I find important to stress is that Access has a file locking mechanism for sharing the database on a network share which is orders of magnitude more efficient than any ...
1
vote
1answer
276 views

How can I split Date column values in Access into 2 columns?

I have a date column that stores values for begining to end date as: 070314-073114 So I need to split it to 2 columns that has the Start Date as 070314 and End Date as 073114, any suggestions? This ...
0
votes
1answer
72 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
1k views

How to delete from two tables same field name in single query?

Help me, I want to delete same filed name from two tables in single query, I Attached query but it's not working... DELETE PersonalTrainerMasterData ,PersonalTrainerCheckboxData FROM ...
1
vote
3answers
1k views

Many one-to-many relationships between two tables

In the process of creating a small database for a therapeutic boarding school with Access 2013, I have a problem when designing the relational database model. Two times at least, I ran into a ...
3
votes
1answer
33 views

Function which evaluates conditionally?

I am using MS Access 2010 and trying to create a parameterized query on one table. My table has many latitude/longtitude coordinates. I wish to pass one lat long point (two parameters) into a query ...
0
votes
2answers
972 views

Access the database by different users simultaneously [duplicate]

My two databases(.mdb) are placed at a network shared folder. Now at the same time few users are connected to database from the network place and doing their job. In the middle get the error like : ...
0
votes
2answers
96 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 ...
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
99 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
3k 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
54 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
119 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
1answer
60 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
533 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
3k 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
654 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
175 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
257 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
360 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
309 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 ...