We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [ms-access]

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

Filter by
Sorted by
Tagged with
2
votes
1answer
26 views

Store long number in MS access

How can I store 12 character long number in MS Access 2016, if the field cannot be empty?
0
votes
2answers
106 views

Microsoft access to Sql Server Data Migration [closed]

I need to migrate some old MS Access data to a SQL Server Database. Which tool is easier for a newbie to work with: SQL Server Import/Export or Migration assistant for access(SSMA)
0
votes
1answer
100 views

How can I turn each record on my Access table into 6 records?

I've spent all day googled one issue: please help. I have a table like the one below that I want to expand, turning each single record into 6 records. TableName: -------------------------------------...
1
vote
1answer
79 views

Totals on alias columns

I have a table in MS Access that has the following fields/data: School number Traditional Forms Sparring Traditional Weapons Combat Weapons ------------- ----------------- ---------------...
4
votes
2answers
144 views

Access not properly translating TOP predicate to ODBC/Oracle SQL

I have a MS Access query that is based on a linked ODBC table (Oracle). The DDL for the underlying Oracle table is: create table road_insp ( insp_id integer, road_id integer, insp_date ...
0
votes
1answer
863 views

Trace ODBC commands: What is the registry path for TraceSQLMode and where is SQLOUT.TXT?

In the Optimizing Microsoft Office Access documentation, it mentions that we can: ...edit a Microsoft Windows registry setting that allows you to see the commands that the Office Access database ...
3
votes
2answers
90 views

why the last function in msaccess allow me to bypass the group by?

I have the following query on msaccess SELECT Trim([T13_RefSupplier_France_List].[Supplier_code]) AS Supplier_code, Trim([T13_RefSupplier_France_List].[Art]) AS Internal_reference, Trim(...
3
votes
1answer
184 views

Strange UPDATE results in presence of merge replication

I have an MS Access front-end database that accesses an SQL Server backend. This (as far as we can tell) works flawlessly when the SQL Server database is not replicated. Once we introduce replication (...
1
vote
0answers
31 views

Save Access SQL code to text file or Python variable?

This may not have a good answer but maybe? So I have a number of Access databases that query a SQL Server through ODBC to generate reports. The SQL Server backend is being changed out and I need to ...
1
vote
2answers
11k views

Access Query - Count distinct values [closed]

I have a dataset similar to the one below in Access: I am wanting to create a query which generates a table summarising how many sites each company is at. I.e. it will return something like this: ...
6
votes
2answers
14k views

Import from Access .accdb file to SQL Server [duplicate]

How to import data from Access .accdb file to SQL Server? What should I choose in SQL Server Import and Export Wizard? Suppose we choose OLE DB Provider for SQL Server Integration Services, then if ...
1
vote
1answer
100 views

MSAccess: creating a new row in a related table and linking it back to the “master” table

In a hypothetical 'cars' database, assume there's a model table and a make table: models modelID int model varchar make int makes makeID int make varchar Model's make column has a foreign ...
1
vote
0answers
52 views

MS Access: automatic creation of row in a table based on field in another table

I have a Table A with an ID field and a Question field. The question has a yes/no answer. I want MS Access to automatically create a new observation (row) in another table, Table B, if I answer yes. ...
2
votes
1answer
102 views

Form isn't reading table records

I am really new at dB building. I created a table that is to read from records of a few other tables. However, i needed to add another table and i placed the input field into the form. My problem is ...
1
vote
1answer
13 views

How do I by pass startup code in access

I am struggling to by pass my startup code in MS Access using the SHIFT + ENTER keys. How else can I accomplish this?
1
vote
1answer
35 views

MS Access 2007: Combining data from tables caused combinations of data

So my query in Microsoft Access 2007 is taking data from three different tables: a, b, c. In these tables are double values all named as "Time" that were run to record how long an event occurred. ...
1
vote
2answers
1k views

Can I pass a single record from a recordset to a module?

I am creating a module, RedemptionEstimate, in MS Access 2016 that requires 13 parameters to be passed to it and calculates how much is owed on delinquent property taxes. Some of the parameters can be ...
2
votes
1answer
415 views

Populating one foreign key based on entry of another foreign key in Access 2016

I currently have three tables as shown below: The user enters Certificates via a form. I want CertCounty to populate based on selection of TownshipID. I've attempted the following Data Macro: But, ...
0
votes
2answers
2k views

Joining two tables with different fields through a link-table

Im a complete novice to Access (2013). Im doing some History research and thought it would be easier to use Access. I have created two table so far. People, Details info about them Events (...
1
vote
1answer
27 views

MS-Access: How do I go about building a database with inconsistent data sources?

I'm working on building a database to aggregate various data sources and feed a set of Tableau dashboards. The data is all employee data, the problem is, I only have one file of seven with a unique ...
0
votes
1answer
71 views

Need help with relationships in MS Access

I am in need of some assistance. I'm fairly new at access & dbs, and have managed to get a bit accomplished, but have run into a wall. I'm not sure it is my inexperience or if access cannot ...
-1
votes
1answer
393 views

How to Input a time series set of data into MS Access 2010

I am trying to create a database with time series data in MS Access 2010. More specifically, I have order history over 30 months. What is the most efficient way to input this into MS Access? ...
1
vote
1answer
77 views

How to add data to sql server using MS access front end, when user will not always have sql connection

I have a SQL Server backend and an Access Front end database which is working fine. However, I now have a user that needs to use this database (on a tablet) for some equipment checks out in the ...
0
votes
1answer
815 views

OleDBConnection.Close() very slow on server

I am working on a few applications which connect to an MS Access database backend (.mdb) to read/insert/update records. Everything is working fine, but I noticed that my db operations were quite ...
1
vote
1answer
60 views

Access Db `Long Text` Unicode Byte Corruption

I have a column that is Long Text when I attempt to edit a cell it randomly inserts characters and does other weird things. The column has French HTML text in it. What could be causing this and what ...
0
votes
1answer
631 views

MS Access- Attachments to SQL Server -Images or Varchar(max)

I am trying to move a database from MS Access to SQL Server 2014 and I am using SSMA for Access. A few of the tables have attachments (pdfs, jpgs, emails, etc.). When I move it to SQL Server, the ...
0
votes
1answer
9k views

MS-Access RANK() function

I have a table in Access like this: ID | Op_ID 1 | 1 1 | 2 2 | 3 3 | 4 3 | 5 3 | 6 Is there a SELECT query that I can run in Access that would give me something like ...
1
vote
2answers
236 views

Emulate row count on 2 columns in Access

I have the following table in Access I have a number of lines where there are duplicates when you filter on the first and second column. I need to remove these duplicates. The best way I found is to ...
0
votes
1answer
75 views

JOIN type for MS-Access report query

I have 7 tables, 6 of which are in a one-to-one relationship with a table named SLD joined with SLD_ID. SLD has 17 records and I need them all displayed regardless of matches in other tables. Which ...
1
vote
0answers
435 views

Using VBA to open Access in full screen and in foreground

I have 2 issues. I am using VBA code to create a macro in PPT that opens an Access report. The macro works but does not open it in full screen. I have tried to add the DoCmd.maximize but not sure ...
0
votes
1answer
365 views

Access Macro: ApplyFilter w/values from 2 combo boxes

I'm getting started with databases in Access for a work project (technically a work-learn for my non-CompSci degree). I have experience using multiple filters on multiple columns through Access/Excel, ...
1
vote
1answer
2k views

Query input must contain at least one table or query error

I'm working on a java program that connects to a Microsoft Access database and displays the data in a GUI. I'm currently trying to code a button that adds a new row to a table called Grade that holds ...
0
votes
1answer
44 views

How to query for something like “last active” per column in Access

Let's Say i have two Tables, let's call them PC-Info | ID | Hostname | Location | |:---|----------:|:-----------------:| | 1 | Hostname1 | This Room | | 2 | Hostname2 | That Room ...
2
votes
1answer
169 views

Shortcut to select all SQL text in Access

When working in the SQL view in MS Access, is there a shortcut to select all the text in a SQL query. For example, most text editors in Windows follow the {Ctrl+ a} combination, but this doesn't seem ...
2
votes
1answer
1k views

ODBC Connection Lost… Close Database

I have a Access 2013 frontend linked to a 2014 SQL server. When users leave their workstation with their copy of the frontend open their computer will go often into sleep mode and lose their ODBC ...
1
vote
0answers
164 views

Access linked to SQL with SSMA slow performance

I'm working on migrating a legacy application's DB (in Access 2003 format) to a SQL Server 2008 back-end (This will be upgraded later on). We are close to hitting the 2GB size limit in Access and ...
1
vote
0answers
30 views

Switch Between Windows Authenticated Users On Single Windows Account

We have a CRM that has been developed in house in Microsoft Access 2003. We are also in the process of moving from an MS Access backend to a SQL Server backend. I have been researching different ...
2
votes
1answer
818 views

What is the equivalent of MS Access InStr function in SQL Server 2008?

This query runs in Access 2013 but I need it converted to SQL Server 2008. The issue is that the INSTR() function does not exist in SQL Server and the query references the field generated in same ...
1
vote
1answer
1k views

Microsoft Access database to FileMaker Pro

I have all my customer details in Microsoft Access. I want to transfer all this data to FileMaker Pro. I hope there is a way to do this. If so please help me.
2
votes
1answer
168 views

Relationship between two multi-valued child tables

Scenario In my system, there are a number of different TradeBaskets. Each TradeBasket contains a number of different Securities. The Securities have a Type, Value, Sector etc... and new Securities ...
1
vote
3answers
695 views

Transfer datas from Access to PostgreSQL

I'm trying to insert some data from Access to PostgreSQL database, but it's not a simple query, because it's a nested query. For example : rst.Open "INSERT INTO car(id, model, color, type) SELECT (...
1
vote
1answer
347 views

How to create data tree in MS Access

I am trying to build a database in which I am going to need to have a tree to keep track of cars. Unfortunately, I don't always know what level of detail I am going to have, and the level that I do ...
2
votes
3answers
32k views

Bypass MS Access 2GB file size limitation

I am creating a MS Access *.accdb database with multiple tables and specific relationships. This database will be used for a one time data transport to another system, containing order of a few ...
0
votes
1answer
3k views

How to minimize full ms-access window in vba? [closed]

I have some code to minimize like docmd.minimize but it does not work. Please let me know how to minimize whole window of access in vba?
0
votes
1answer
406 views

MySQL read only slave - how to create views

After a lot of resistance I have recently been given MySQL access to our CRM system, via a read-only slave. I have an issue now in that I am really limited to what I can do with the data in MySQL - ...
0
votes
1answer
65 views

Manipulate duplicated records

In a table ( in Microsoft Access), I have a large number of records that have duplicated field, for example field-1. I have to change the table and set field-1 as primary key. But as you know, it is ...
1
vote
1answer
1k views

MS Access replace entire table contents

Info: I am setting up a new MS Access database for a small team (~10 person) project. There is a table "A" which is never modified but has relations to another table based on the field "Tag Number". ...
1
vote
1answer
80 views

Relating two fields of one table to one field of another

I have two tables that look as such: Table1 Table2 ID | Appname ID | App | Dependency ------------ ----------------------- 1 | App1 1 | 2 | 3 2 | ...
0
votes
1answer
30 views

Need to change existing design to accomodate more detailed tracking of time

Currently I have a relationship between contact and time_log (contact is a verb here - could be a meeting/phonecall/email). Time_log holds both a date and time, each contact is associated with one ...
0
votes
1answer
53 views

Access Send Email. Loop Not Building Table

I’m stumped on this one. I have an action item list on a fairly large Project Management DB. This list is datasheet that is embedded as a subform on a PopUp form from the Main Menu. On the Action Item ...