849 questions with Access Development tags

Sort by: Updated
Updated Created Answers
1 answer

Tengo una base de datos .accdb que no me abre me da un error

Estuve trabajando en la base de datos la cerré y al querer abrirla para seguir trabajando me sale el siguiente error ".. no se reconoce como una base de datos..". Hay alguna forma para recuperar lo ya hecho. Gracia por su respúesta

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
849 questions
asked 2024-01-23T01:06:43.31+00:00
Antonio Lopez 0 Reputation points
answered 2024-01-24T15:58:22.8+00:00
Daniel Alejandro Rivera Dominguez 410 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

How to connect an Access 2010 database to a SQL Server database on a seperate computer

Hi All: I have a Microsoft SQL Server database stored on a separate computer MRM-WINX-002. I wish to create a Microsoft Access 2010 frontend (GUI) and have it link to the selected database on the server computer. Does anyone have illustrated Step-by-Step…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,203 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
333 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
849 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,058 questions
asked 2024-01-19T15:33:23.1466667+00:00
Mark McCumber 431 Reputation points
edited the question 2024-01-23T07:49:20.8433333+00:00
Emi Zhang-MSFT 23,351 Reputation points Microsoft Vendor
6 answers

How to insert data into Access DB table from a C# class dataTable?

I have a datatable that has thousands of rows and columns and I need to copy this data into AccessDB table with exactly the same table structure. There are several tables in AccessDB that need to get populate with rows from dataTable. Some of the table…

.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,572 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,573 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
849 questions
asked 2024-01-11T07:01:18.3833333+00:00
Josh S 26 Reputation points
commented 2024-01-19T18:09:33.06+00:00
Josh S 26 Reputation points
2 answers

Access Europe Meeting - Wed 3 Jan

The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check https://www.worldtimebuddy.com/ In this month's session, Ramachandran (APR)…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
333 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
849 questions
asked 2023-12-29T16:13:21.54+00:00
Colin Riddington 85 Reputation points
answered 2024-01-12T13:47:39.24+00:00
Colin Riddington 85 Reputation points
2 answers

¿Qué operador se debe usar en Access 2019 para concatenar dos campos o cadenas en una consulta?

¿Qué operador se debe usar en Access 2019 para concatenar dos campos o cadenas en una consulta?

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
849 questions
asked 2024-01-10T15:29:55.1366667+00:00
Jose Luis mr 0 Reputation points
commented 2024-01-11T15:33:22.4766667+00:00
José Pablo Ramirez (a. k. a. webJose) 440 Reputation points
0 answers

From an Access Database, how can I tell if the user is signed in locally or via web based remore access

GetSystemMetrcis32 SM_RemoteSession will tell me if the user if signed in via RDP but not if the user is coming in via a web based tool like DWService

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
849 questions
asked 2024-01-07T23:54:31.49+00:00
Bob Vitter 181 Reputation points
1 answer One of the answers was accepted by the question author.

Mac OS 10.10 and Outlook

Hello, Running Office Mac 2011. Operating system is Mac OS 10.10 Yosemite. There is a Mail issue that i am trying to overcome. Purchased a copy of 365 after reading about the possibility of downloading Outlook for Mac 2016 (for os 10.10) so I could…

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
849 questions
Office Mac
Office Mac
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Mac: A family of Apple personal computers that run the macOS operating system.
481 questions
Outlook Management
Outlook Management
Outlook: A family of Microsoft email and calendar products.Management: The act or process of organizing, handling, directing or controlling something.
5,040 questions
asked 2023-12-16T16:59:02.7266667+00:00
Leo Frankenberger 20 Reputation points
accepted 2024-01-07T16:38:57.7933333+00:00
Leo Frankenberger 20 Reputation points
1 answer

MS Access 2000 on Windows 10 suddenly crashing anytime I try to add a listbox or combo box on a new form.

Have been using MS Access 2000 on my Windows 10 computer without problems since windows 10 came out. Suddenly started having issue with existing database crashing and startup form failing to load (believed to have started after April 13, 2023 windows…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
333 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
849 questions
asked 2023-04-22T00:30:16.0733333+00:00
ChrisH 0 Reputation points
commented 2023-12-27T17:43:34.23+00:00
Anatolis 0 Reputation points
4 answers

En access 2021 Ultima propiedad de las "propiedades de tabla". Se llama "activar orden".

En access 2021, me encuentro con la última propiedad de las "propiedades de tabla". Se llama "activar orden". Me viene con un 0 como valor predeterminado. ¿Qué utilidad tiene? ¿Qué valores puede tomar? Gracias.

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
333 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
849 questions
asked 2023-12-16T01:46:08.92+00:00
misionero 0 Reputation points
answered 2023-12-26T20:25:50.8933333+00:00
Ken Sheridan 2,756 Reputation points
4 answers

adding a carriage return to a field in access

Good afternoon. It's been years since i've used access and now using access 2016. i have a table with a number of fields. I've added a query to select a few of the fields i want to add to a form. The field i'm focusing on is called description. …

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
849 questions
asked 2021-07-14T18:43:06.567+00:00
Robert Suttner 1 Reputation point
answered 2023-12-20T22:24:25.9266667+00:00
Ken Sheridan 2,756 Reputation points
3 answers

How to leverage SQL Server Application Roles in MsAccess?

Does anyone know if there is a way to use SQL Server Application Roles from within Ms Access? I have an Ms Access application with tables linked to SQL Server. Users of the application can access and manipulate data in the linked tables according to…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,203 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
849 questions
asked 2022-05-17T16:50:36.447+00:00
Mats 1 Reputation point
commented 2023-12-18T23:32:34.2+00:00
Greg Youdale 5 Reputation points
2 answers

Is there a comdlg64.dll?

Upgrading from a 32 to 64 bit system in Access. I notice all the examples to upgrade to 64 that I see add PtrSafe to DECLARE statements but still reference comdlg32.dll. Is there no comdlg64.dll? Same question for: kernel32.dll and shell32.dll Thank…

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,684 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
849 questions
asked 2023-12-15T16:52:16.58+00:00
SNiuh 0 Reputation points
edited the question 2023-12-18T06:01:04.4466667+00:00
Jiachen Li-MSFT 28,076 Reputation points Microsoft Vendor
3 answers

External table is not accessible because content of directory cannot be listed

I am getting this error message whenever I try to run a SQL query in Synapse, even though I have Storage Blob Data Contributor & Storage Blob Data Reader access. Any ideas on what else is causing this error?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,621 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
849 questions
asked 2023-06-02T09:22:18.7033333+00:00
JR 0 Reputation points
commented 2023-12-16T05:48:28.36+00:00
Jona 455 Reputation points
1 answer

Access Europe Meeting - Wed 6 Dec - Streamline Your Import/Export Spec Workflow with VBA Classes

The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike Wolfe (MVP) will be leading a presentation called…

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
4,217 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
333 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
849 questions
asked 2023-11-28T14:20:59.4733333+00:00
Colin Riddington 85 Reputation points
answered 2023-12-13T20:23:55.2966667+00:00
Colin Riddington 85 Reputation points
0 answers

Change application icon on Microsoft Access database not working

I'm using this code: Application.CurrentProject.Properties.Add "AppIcon", Application.CurrentProject.Path & "\myicon.ico" Application.RefreshTitleBar to change the application icon of my access database, but the Access icon is…

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
849 questions
asked 2023-02-17T07:59:25.3233333+00:00
WebCool 0 Reputation points
commented 2023-12-13T20:23:26.3766667+00:00
Daniel Chen 0 Reputation points
0 answers

Am a pro user in power bi service and i cant find the streaming datasets option in the bi service

i cant access or cant see streaming datasets options in power bi service

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
849 questions
asked 2023-12-07T06:33:00.99+00:00
Sachin D 0 Reputation points
0 answers

Can't transfer excel file to access.

I am attempting to transfer an Excel file to Access, but each time I try I receive an error message stating "Microsoft was unable to append all the data to the table." What could be causing this issue and how can I resolve it?

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,653 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
333 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
849 questions
asked 2023-11-30T16:04:47.8333333+00:00
Nick 0 Reputation points
commented 2023-12-05T22:48:19.3066667+00:00
Colin Riddington 85 Reputation points
1 answer

how to update database using freeform list

I want to update a table based off of a list box. The list box needs to be freeform, copy/paste list. I have a table for servers. 1 column is for server names and another is for decommissioned (yes/no checkbox). I want to be able to provide a list of…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
333 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
849 questions
asked 2023-11-22T16:45:14.7733333+00:00
Carl S 5 Reputation points
commented 2023-12-05T21:12:41.89+00:00
Carl S 5 Reputation points
1 answer One of the answers was accepted by the question author.

Is it possible to connect a Google Forms to a linked Microsoft Access table using VBA code?

Is it possible to connect a Google Forms Survey (URL website) directly to a linked table in a Microsoft Access database and pull the respondents' responses directly into a linked MS table using VBA code? Currently, when respondents submit their responses…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
333 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
849 questions
Microsoft 365 Publishing
Microsoft 365 Publishing
Microsoft 365: Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line. Publishing: The process of preparing, producing, and releasing content for distribution or sale.
604 questions
asked 2023-11-22T14:21:09.4966667+00:00
wire_jp 206 Reputation points
commented 2023-12-03T11:38:45.1166667+00:00
wire_jp 206 Reputation points
1 answer

access table transpose two fields

Hello, It's not easy for me to describe what I want. :-) I have a database table with two fields. In one field is an Active Directory Group, in the other field are the member of the group. In some groups there are 300 to 700 users separated by a…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
333 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
849 questions
asked 2023-11-30T13:13:03.53+00:00
Andreas Sperling 40 Reputation points
answered 2023-11-30T16:03:41.4066667+00:00
Andreas Sperling 40 Reputation points