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

learn more… | top users | synonyms

1
vote
1answer
31 views

Is hosting the back end in the cloud supposed to significantly slow performance?

I moved my back-end from a local .accdb source to Microsoft's online Access App. Ever since then, forms have been taking more than 20 times longer to load. Is this normal? Or is there something wrong ...
1
vote
1answer
42 views

Mysql trough access

EDIT I solved the half, that i made a pass through query, so now I only need this: (Licenszek.verz_id)=[Forms]![Hasznalat]![verzio]; to be implemented To the pass trough, ot be the passtrough and a ...
0
votes
1answer
69 views

Is there a way to use my Access accdb or accde file (Created on the desktop) on an ipad? [closed]

It would need to be able to read [AND write]***redacted. I only need it to read info. I can store the database either on the network or on the cloud (Microsoft Azure). Is there an app or another way ...
0
votes
0answers
71 views

Pulling Records from Linked Tables in MS Access, throwing Syntax error

I'm currently working with an MS Access database that I'm supposed to be modifying a bit. I've finished the work I was assigned to do but am now struggling with deploying it accross a multi-user ...
0
votes
1answer
45 views

Count in an other table and show only theese records in query which has more than they used in other table

I have for example 2 tables: used(us_id, code_id); codes(code_id, amount) I want something like this: If for example I have 5 eggs, and egg code is 1, then if the used table have reached 5 of ID ...
2
votes
1answer
521 views

MS Access: How to automatically fill in ID field based on value of another field

I have an MS Access inventory database where I imported some data about our food purchases from Excel. In Excel, the Vendors were simply listed in a "Vendor Name" column, which looks like this: ...
1
vote
1answer
382 views

Automatic creation of unique Alphanumeric ID?

All the accounts in my database have a unique ID, that begins with the letter "G" (always), and has a 3 digit number following (e.g. "G026", "G123","G005","G999", etc.) When a user is inputting new-...
0
votes
1answer
40 views

Deploying Shared MS Access DB — Summer Intern first time with Access

So to give a brief background I've got a summer internship and was asked to modify and add features to an already existing MS Access DB. I don't actually take databases until next semester, so I was ...
4
votes
1answer
57 views

How to create a database with “polymorphism”

I'm sorry I'm new when it comes to databases, I'm using Access right now to develop a database to store calibration data for a bunch of different types of transducers. Each type of item is ...
0
votes
1answer
1k views

How to export an Access database and import to MySQL?

I am working on a Java project that sources data from an MS Access database, but I want to use MySQL because I have found it to be very easy to manage. How can I export an Access database that has ...
1
vote
0answers
289 views

How to autopopulate MS Access fields with info from another table

I am creating a food purchasing and inventory database for a restaurant. Originally, the invoice/ordering data was stored in Excel. I created several tables in Access: "Vendors", "Invoices", and "...
2
votes
0answers
119 views

Microsoft Access Export to Excel

I have an Excel spreadsheet that is filled with a ton of data which is organized by column (a column for names, a column for occupation etc.). I have recently moved all of this data into Microsoft ...
3
votes
1answer
341 views

Any reason not to add 'rowversion' column?

The TechNet article, "Optimizing Microsoft Office Access Applications Linked to SQL Server", recommends adding a rowversion column to SQL Server tables linked from MS Access. From the Supporting ...
0
votes
1answer
351 views

Why are some of my migrated tables showing “The given key was not present in the dictionary” in WebMatrix's interface?

I'm having an issue while using the SQL Server Migration tool to convert Access accdbs into SQL Server 2014 Express. I am converting the tables using SQL Server Migration Tool and I have a connection ...
1
vote
1answer
38 views

Basic Access database help [closed]

I am trying to create a basic database using access but I'm just learning at the minute. I have a text file which contains, customer account code (contains duplicates), customer address type, ...
0
votes
0answers
878 views

Removing Replication from MS Access mdb file using External Data->Access, is anything lost?

The new version of MS-Access 365 does not support replication as evidenced by the following error message: "The current version of Microsoft Access does not support replicated databases. To use ...
0
votes
1answer
197 views

Auto increment form field

I am working with a database, with some forms. What I am trying to do is an auto increment field in my form. For example ID -- every time when I type some new record, this field ID should increment ...
3
votes
2answers
1k 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 ...
1
vote
2answers
177 views

Trying to design database for eSports Teams - Issue with dependencies

I am trying to design a database in Access for an eSport league (specifically League of Legends North America). I will post what I have and then explain my issue. My issue comes when I try to ...
2
votes
1answer
233 views

Adding two columns results in concatenation instead of addition

I need help using addition. When I do it populates using the concatenate function. I used the following in my access database Total: [ANTI TERROR]+[Records] and instead of returning 1 + 1 = 2 it ...
1
vote
0answers
86 views

Alter schema of Access 2013 database with linked table

I'm trying to change the schema of an Access 2013 table. I want to lengthen some of the text fields. When I change the schema and try to save I get dialog with Operation is not supported for this type ...
0
votes
1answer
224 views

Access 2010 ODBC Connection to SQL Server 2005

I'm trying to code an ODBC connection to SQL Server in Access 2010 and hoping someone can help me, as I've lost the plot. This is my code, it simply accesses one SQL Server database/table and insert ...
1
vote
1answer
53 views

Access Data stored in SQL Server

I'm currently working on a project to convert our Access Apps to store the table data in SQL Server. Using SSMA to migrate the data results in the foreign keys and Look-ups work as expected in ...
0
votes
1answer
102 views

How to prevent #Error values derived from Nulls in an outer join

Suppose I have two tables to outer join Tab1: ID Nam 1 Joe 2 Moe 3 Flo Tab2: ID Val y w 1 stuff 66 33 2 duff 67 44 and one of the resulting columns is derived -- i.e., it'...
1
vote
0answers
173 views

Problem forming a query with subqueries in design view? (MS Access 2010)?

I just started a new job as a dbase admin intern, and due to the database being very large, it is better to do queries in design view, rather than hardcoding the sql. That being said, I cant seem to ...
0
votes
1answer
184 views

Joining two database tables into one

I have a database with two tables. Each table has different structure but they do share few common fields. Simplified example: Table1 field structure: Field1, Field2, Field3, Field4 Table2 field ...
0
votes
1answer
105 views

Rounding mixed data types

I have a column with a mixture of letters and numbers, and I need to round only the cells that contain numbers using SQL. I currently have my data saved as strings only, and when I try to use a round ...
1
vote
1answer
214 views

PostgreSQL ODBC and Microsoft Access date/time in aggregate functions

I am trying to replace our MS Access 2003 databases with PostgreSQL 9.3. The first step is to use our MS Access front end to the upsized databases in PostgreSQL. Everything seems to work very well ...
1
vote
1answer
2k views

How to set user-level security in 2007+ MS Access?

I've read this MS info which should cover my problem. There are quite clear steps: Open the .mdb or .mde file that you want to help protect. On the Database Tools tab, in the Administer group,...
0
votes
1answer
396 views

ORA-01461 in a msaccess linked table

In an Oracle 11 database I have a table that all fields are varchar2. This table is linked in an access database, and when I try to do an insert from a data aggregate query, it throws the error ‘can ...
1
vote
0answers
269 views

Most effective way to manage a growing list of time series data in an MS Access database

I am building a database to store time series data along with some other summary statistics. Since this is a local application I do not have access to more robust database solutions and am confined to ...
1
vote
1answer
922 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() ...
1
vote
1answer
326 views

MS Access: adding column if not exist (or try/catch it)

this is an easy question, but I can't find out the solution... I have to check if a column exists and add it if the test is negative. How can I do with only sql code? This is the syntax for SQL ...
1
vote
1answer
492 views

Wrong data type while using linked tables in MS Access

I have a SQL server database which needs to be linked to MS Access forms. I have a table with one column as both Identity and is a also a primary key and is big int But after linking the table , if ...
0
votes
0answers
411 views

Access 2010 delete and append queries run partially then give “Read Only” error

I have a number of append and delete queries written in Access 2010 that link to and modify tables on our SharePoint 2010 site. These queries have run without problem for months, but suddenly they've ...
0
votes
1answer
270 views

How to define destination for an append query Microsoft Access

I'm trying to append two tables in MS Access at the moment. This is my SQL View of my Query at the moment: INSERT INTO MainTable SELECT FROM Table1 INNER JOIN Table2 ON Table1.University = Table2....
0
votes
1answer
168 views

Linking two fields from different tables (are relationships required?)

For example, I have two tables. Employees and Products. Inside Employees I have the fields: emp_ID, emp_fname, emp_lname, emp_products Inside Products I have the fields: pro_ID, pro_name, ...
0
votes
1answer
1k views

Allow access to enter data through forms, but not full database access

Using Access 2013 or Sharepoint 2013 is it possible to give someone access to data entry forms that work with a back end database whether Access database or Sharepoint SQL. But from everything I've ...
1
vote
1answer
91 views

Displaying only the most recent activity of an item

I have made a database that tracks the shipping and receiving of the tools that my company has. I am now wanting to make a query that shows only the most recent activity of all the tools. I have a ...
2
votes
1answer
534 views

Display a one-to-many relationship in one row

I have a "one to many" relationship in two tables: Table "products" contains: product_id, product_descr Table "packing" contains: product_id, package_id, package_desc One product has often more ...
1
vote
1answer
246 views

User can see Oracle tables via ODBC that her account does not have access to [closed]

We have a user whose Oracle account, according to ALL_TAB_PRIVS, has access to tables A, B, and C. However, when the user creates an ODBC and connects to Oracle via Microsoft Access (using her Oracle ...
1
vote
0answers
235 views

Replicating Multiple SQL Servers to Azure and Accessing From Web Apps

I am setting up quite a large system with multiple servers (MS SQL Server), and Office 365 Access DB, and a custom SharePoint web app for reporting purposes. The system should work as follows: Each ...
0
votes
0answers
54 views

Are documents made with MS Access 32/64 bit compatible with the other “bitness” version?

I don't have a copy of 64 bit MS Access installed so I can't try this. I'm a developer looking at what's involved with adding support for 64 bit. I'm just using the MS Access database as a back-end. ...
1
vote
1answer
105 views

MS Access - protecting backend file

I'm creating a split database in Access which has the backend on a drive accessible to all employees in the company at the moment. This isn't such a big deal at the moment because I'm still developing ...
1
vote
1answer
996 views

Updating one table from another table where non-primary-key field is similar string

I have a database in Access that I am trying to fix (actually, I'm working on a copy of the original). There are two tables, one with data input errors, and a second that is a copy of those errors, ...
0
votes
0answers
52 views

How can I track changes across 60 local databases with 1 million+ rows each?

The files are mdb and I have them locally on my computer. Just trying to track changes across the 60 databases. Realistically I want to compare two at a time and find the differences in the reports, ...
1
vote
0answers
45 views

Fetch Top 2000 Records

I have following query: strfinal = " TRANSFORM Format(Sum([Mandays].[Hours]),""#0.0"") AS [The Value] SELECT Mandays.WorkTypeCode AS WONo, Format(Sum([Mandays].[Hours]),""...
0
votes
0answers
151 views

Database design for varying prices from multiple vendors

I am designing a database where the products are sold in bulk with multiple pricing options, from 4 different vendors. What is the best table configuration to store this information? Id like to be ...
1
vote
0answers
64 views

MS Access Residual Query Parameters on Copied Report

I've been working on an ms access database which was put together prior to my employment, I wanted to create a new report in order to display Quality Control information, in order to do this I copied ...
0
votes
1answer
544 views

Exporting Access DB to SQL Server: unexpected EOF?

How do I correctly export a table from an old Access .mdb to SQL Server 2012? In Access I do: right click on table, export as text file and use comma or tab separator. My line endings are CRLF as ...