Questions tagged [microsoft-access]

Microsoft Access is a rapid application database development tool.

Filter by
Sorted by
Tagged with
0
votes
0answers
25 views

How to Authenticate windows login credentials via Microsoft Access in vba

I need to have a login form in my access project where i will be displaying the user name of the user currently signed in and will be prompting for password. After user enters the password i need to ...
-2
votes
0answers
20 views

How to publish ms access database forms to client?

I have developed a ms access database project for a client. I need to submit the project to the client. But i want the client to use only the forms created and other options displayed in toolbar such ...
0
votes
0answers
5 views

Optimize data import to MS Access 2016

I am having a problem where I attempt to import a file to Access, but the import process bogs down and Access crashes. I am doing this in a desktop environment, and must use a specific desktop for it: ...
1
vote
0answers
24 views

During data import Access doesn't recognize all of the named_ranges available in excel file

As I described in the subject, during importing Excel file into an Access made database I'm facing an issue of Access not seeing all of the named_ranges I created in my Excel file. This is the data I ...
0
votes
0answers
19 views

One of three users can't work on access DB

I'm having a problem with a costumer after a recent change. Situation before the change: - 3 PCs in a workgroup: PCs 1 and 2 are WIN10, PC3 WIN7 - PC 1 has an acceess DB (rather small 60MB) in a ...
0
votes
0answers
15 views

MS ACCESS Database

I have this error displayed on my connection wizard: Cannot establish a connection to jdbc:odbc:userdsn using sun.jdbc.odbc.JdbcOdbcDriver ([Microsoft][ODBC Driver Manager] The specified DSN ...
0
votes
0answers
16 views

Organize tables in MS Access relationship view?

Are there any tools to organize/sort tables in MS Access's Relationships view? Is there any snap-to-grid functionality?
1
vote
0answers
28 views

Disable shift key on startup in ms-access (Doesn't want to work)

I'm an advanced Access VBA programmer, and even though I have programmitcally set the 'Use Access Special Keys' to FALSE (using VBA), or set that option through the Access Options screen, I can still ...
0
votes
1answer
32 views

Need to format an email in Excel or access

I have an exported excel file from MS ACCESS that is fine but some don't have email addresses, But they are all the same that is, Lastname. (put in a '.')Firstname@dcf.nj.gov I have a formula that ...
0
votes
0answers
22 views

Display all dates that are before the current date - Access

I am creating a project in access and need to display a field that is in the time frame of this week; however, I need it to update with each week that goes by automatically. Summary: I need the field ...
1
vote
1answer
10 views

How to display date fields that are before the current time - Access

I am creating a database for a school project and am trying to create a query for the 'clients' that have had their appointment completed already. I have a field with the date inside and would like ...
0
votes
0answers
27 views

Find most recent date for ID with multiple records in access

I have a field, ID, and it has multiple entries with a time stamp for every time a recording was taken. I want to create a query that finds the most recent date for each station ID. Additionally, I ...
0
votes
0answers
55 views

Crystal reports Logon Failed: ADO Error Code: 0x80040e4d - Microsoft Access Database Engine (Workgroup information is missing or opened exclusively)

I get the following error while trying to connect MS-Access 2016 MSO 32-bit to Crystal Reports VS13SP25_0-10010309 using C# 2017 (Community). Logon failed: Detail: ADO Error Code: 08x80040e4d ...
0
votes
0answers
7 views

Combine Access Row Text According to the Column Valua

I have a table like below where I want the query output to be like the right expected table. I want to combine the texts in "Partner" column according to the "Location" column. Picture:Table and ...
0
votes
1answer
19 views

Get Front end of Access DB to work across multiple users without mapped network drives

Is there a way to get front end of the Access DB to work across multiple users without mapped network drives?
0
votes
0answers
24 views

MS Access with SQL Server table checkbox disappear

I have an Access database with an ODBC connection to a SQL Server table. In my main form I have several subforms that are visible to the user. All the subforms appear correctly but in few minutes ...
0
votes
1answer
230 views

How to fix 'Microsoft Access can't be started. Microsoft Access was unable to initialize the Windows Registry'?

I've encountered an issue with trying to use MS Access on Windows 10 Enterprise 1809 that happens whether I open Access itself or try to open an .accdb file. This is the first time I've tried to run ...
0
votes
1answer
14 views

Microsoft Access: How to autofill every record in a field in a table?

I'm working with 2 existing tables. The primary table (Table1) has thousands of existing records and I need to add a field with data (State) and autogenerate the entry for every record at the same ...
0
votes
0answers
30 views

Any Work-Arounds for the IBM DB2 ODBC exception 0xc0000005 in db2clio.dll?

I'm running MS Office 2016 64 bit and trying to connect to an IBM DB2 server to attach tables in MS Access 64 bit through 64 bit ODBC, but I keep running into this error - https://www.ibm.com/support/...
0
votes
0answers
21 views

Making a second back end database in Access when the first gets full

I will start this by saying that I am a mechanical engineer, and I am in no way familiar with Microsoft Access, I don't even know the right terminology to describe the small amount of knowledge I do ...
0
votes
2answers
32 views

how to work with many to many relationships in Microsoft access?

I'm trying to set up a new access database relating plants to the chemicals they contain. I understand that it's a many to many relationship, because many plants can contain the same chemical, and the ...
-1
votes
1answer
48 views

Microsoft Access: Runtime error 3142. Characters found after end of SQL statement

This is my code from Microsoft Access. I am trying to do a search of a certain keyword in a subform. I get the following error: runtime error 3142. Characters found after end of SQL statement. When I ...
0
votes
3answers
198 views

Uneditable Transformed Row Source for MS Access Chart Keeps Resetting Sort Order

Inserting a bar chart object into a Microsoft Access form brings the data into view with a sort order I did not preset when I first designed the underlying query. I can see that the unwanted sort ...
0
votes
1answer
19 views

Alternative to MS Access

I am using MS Access for my small office for data management and reporting. I was good with RAD feature of this software e.g. quick form design for data entry and reporting but now a days I am ...
0
votes
0answers
16 views

Connect Oracle 11g Express with Microsoft Access

I have a database instance Oracle 11g Express. I' ve done this and now i have to make the front-end using Microsoft Access. I tried to link my Database with Access by doing this: (on Access) Exernal ...
0
votes
0answers
26 views

MS-Access: Active Directory Integrated SQL Server Login

Ok, I'll lay it out: I have access to a Azure SQL server database that uses the Active Directory - Integrated authentication type. I have access to only a specified database, not every database ...
0
votes
0answers
27 views

Microsoft Access keep disconnecting from MySQL database

I have two virtual machines within the same host (Hyper-V 2016 if it does matter): - Windows 10 PRO 1903 fully patched with Microsoft Office 2016 (also I've tried Office 2007 SP3) with MariaDB ODBC ...
0
votes
1answer
16 views

Linking to or importing from Microsoft Graph in Access for Office 365

https://support.office.com/en-ie/article/link-to-or-import-data-from-microsoft-graph-448d8bf1-0f54-46c4-91bc-490d5ebfdadd allegedly tells how to import or link to Microsoft Graph from Microsoft Access ...
0
votes
0answers
34 views

Import Text Wizard - Error in loading DLL

Clicking the Finish button on Access' Import Text Wizard generates "Error in loading DLL". Current suite: MS Office 365 ProPlus a/k/a E3, 64bit, Version 1902 (Build 11328.20392 Click-to-Run). ...
0
votes
1answer
68 views

Unable to import access database to SQL Server - unrecognized database format '.mdb'. (microsoft jet database engine)

I am trying to import .mdb (Access database file) to SQL Server. Adding the sys-admin privilege username and password also does not help and gives an error - not a valid account name or password.
0
votes
0answers
32 views

Unable to connect to MySQL with ODBC Driver

I'm unable to connect to MySQL via Remote MySQL using ODBC Driver for our Microsoft Access Application. I have the same setup at the office and it's working fine but not at home. That's my setup. 1. ...
1
vote
1answer
94 views

DlookUp Function in ACCESS Query

I am working on 2 databases that are linked together: Action Items List and UserInfo. I have imported the Action item List from my Sharepoint site. I am trying to display only the "actions" that ...
0
votes
0answers
11 views

Merging to Access databases without losing information or creating duplicates

As of this moment I have two databases with the same fields that I am trying to merge. Each entry has a date associated as well as a name. Database 1 has four people that use it and database 2 uses a ...
0
votes
0answers
107 views

Cannot install SQL Server Migration Assistant for Access due to missing Data Access Object libraries

I have a requirement to migrate some MS Access databases to SQL Server, and would like to use the Microsoft SQL Server Migration Assistant 8.3 for Access. One of the pre-requisites for installing SSMA ...
0
votes
0answers
57 views

Synchronizing Combo Boxes in two different Access subforms

I found the below internet article on synchronizing linked subforms helpful, but I wanted to adapt it for use with combo boxes, instead of datasheet forms. Synchronize Two Related Subforms on a ...
0
votes
0answers
10 views

MS Access 2003 size mode behaves differently on single PC

One of our computers display the MS Access form image differently. Our computers share a single .mdb file and the image size mode is set to 'Clip'. All of our computers use MS Access 2003. Most of ...
0
votes
0answers
12 views

How to edit multiple records at once via a form in Microsoft Access 2016?

I'm currently using access to keep track of our sim cards... basically when we give a sim card to a customer I then use a form to find the sim number and fill out other fields such as customer name, ...
0
votes
0answers
35 views

Looking for an alternative to Google Fusion Tables’ card layout

As Google is turning down Fusion Tables next December, I'm looking for alternatives for the following: What I need: A string of hyperlinks based on values in a CSV-file, preferrably automatically ...
0
votes
1answer
89 views

Autohotkey to conditionally ignore native keystroke

How can I make a hotkey be specific to an application, but conditional to some factor so that if the condition is not true the hotkey will be handled by the native/default handler? I've made a hotkey ...
0
votes
0answers
21 views

Microsoft Access not displaying numbers from drop down list

I have an Access database to collect numbers from a scale of 0-3. When I go to enter it through the form, it only allows me to pick from 0-3 from my list BUT when I go back to my database, it's ...
0
votes
2answers
264 views

MS Access: how to create joins to avoid “cannot add record(s); join key of table…not in recordset” error

I'm new to MS Access. I have a very simple plant taxonomy database that I am using to try to learn and understand the program. The database has three tables shown below: The relationships between ...
0
votes
1answer
24 views

Link two fields in one table to one field in a second table, and create qry in Access

I am not sure if this is possible to do in Access; I have been googling forums and have not found a solution yet that works... Essentially there are a list of patients who provide multiple blood ...
0
votes
1answer
33 views

MS Access form doesn't reflect recent data updates in Split Database's FrontEnd Forms

I have a front end and a backend to my access database. The VBA code, forms, queries etc are on the frontend and tables on the backend. The backend is on a server, about 5 different users are using ...
0
votes
1answer
14 views

Access 2016 IIF (more that 2 conditions)

I need help I need correction in the code below. I have 3 conditions that need to be met. If all 3 are met then give me the word "Active" if not, give me the word "Inactive". Expr1: IIf([Master COA ...
0
votes
0answers
7 views

Automatically expand row height in Access report to match height of field with wrap text

I have a question concerning a report in Access 2016 where one or more fields are set to wrap the text. My problem is I need the height of the entire row in my report to expand to match the tallest ...
0
votes
0answers
8 views

Does Access change the field names when you use the SQL Design tool to join two tables that have identical field names?

Do you know why this occurs? My only guess is that this is occurring because these two fields are in both tables that I joined. 1DSF5D1D2F55DF1 below is not the actual string. I just replaced it with ...
0
votes
0answers
76 views

Microsoft Access ODBC Call to MySQL Failed with No Error Information

I'm trying to connect Access to a View Table in an MySQL Database that I have access permission to. However, when I select the table to import, the following error message pops up: Which is great - ...
0
votes
1answer
14 views

MS Access (365) Forms: One ID links to two fields (primary, secondary). How can I get a subform to retrieve both fields?

I have a company table and a contractor table. The contractor table has a primary contractor and secondary contractor field. Both fields pull a company name from the company table. I've created a ...
0
votes
1answer
31 views

Link/share Macros between Access files

I have several accdb files. Most of them (I will call them slaves) have only tables and queries and only one (I will call it master) have vba macros that actuate over the other files as an engine. ...
0
votes
0answers
26 views

Speed up vba for Access

Excel has means to speed up macros by adding statements like Application.ScreenUpdating = False Application.Calculation = xlManual Application.DisplayStatusBar = False Application.EnableEvents = ...