Access VBA References caused compile error
An Access database in Microsoft Office 365, which is up to date, uses references to several other programs, selected in the Tools | References menu in the VBE. It has compiled successfully for several months as it is developed. It then suddenly failed…
SSIS - Transfer data from Multiple tables using a single DFT
Hi... I followed all the procedures in this post and created a SSIS Package. (https://social.technet.microsoft.com/wiki/contents/articles/33564.ssis-transfer-data-from-multiple-tables-using-a-single-dft.aspx When i tried to execute this package all the…
How to contact a forum moderator?
Hi. How do I contact a forum moderator here? I want to know why one of my threads has been deleted. https://learn.microsoft.com/en-us/answers/questions/1660015/access-europe-user-group-meeting-using-vba-to-crea As an MVP, I would never knowingly write…
I'm looking for accessing MS Project outside platform using RESTful APIs
I'm in the process of building a service that consumes or updates MS Project details via Restful API calls. After exploring the Graph API, I found that MS Project resources are not currently supported. While there are SDKs available for .NET, I'm…
unable to register as a developer
when trying to register i keep getting an error that says If you require further information please reach out to Microsoft support with reference number: 715-123225 and transaction ID: ac291227-fbb6-4402-b981-391c18ff79a2. Correlation ID:…
ODBC Connection DSN and Linked Table Manager Giving Different Results: The link table manager in access database only gives the master tables
I am setting up a DSN and a Linked Table Manager link all on the same Access database on the same computer with the same database Login and associated User (and of course the same database). The DSN gives me the tables I need, but the Linked Table…
Finding as how to allow one device id access and restrict other or all in Azure P1
Hi, Testing to create a policy rule in P1 license where we allow few devices id and restrict some or all. Kindly suggest. We tried but could not, devise registered using multifactor only. Thanks
Execution Context for MS Access front end to SQL Server backend
Hello, we have a business application that is based on MS Access front end and SQL Server backend. Tables are linked via DNS-less connection. The application is using SQL Server Authentication using an ODBC connection, driver is SQL Server (connection…
I cannot see any tables when Connecting the Azure via MS Access Linked Table Manager, what am I missing?
I have installed AdventureWorksLT as well as my own tables in a new Azure database that I am trying to connect to via "Linked Table Manager" in MS Access but all I see are the sys tables. If I use DoCmd.TransferDatabase acLink it works fine…
Working with Access database via OleDbReader
Hey all I have no problem when all my access mdb are string! I'm using Access database engine 2010 to connect to mdb. The problem occurs when I have Boolean / Integer / Date fields: New OleDbCommand("INSERT INTO tableblah (strfield, intfield,…
Access crashes when mouse pointer enters specific criteria field cell
I've got a database with a number of similar group by queries, each using the Format function on a date field. Just by getting the mouse pointer in the criteria row of that particular field in design view, the database crashes, consistently, without…
Client providing access to their sharepoint and I have been blocked as a risk
I am not a technical person. I am a solopreneur. Today my client provided access to their sharepoint and I was blocked in Microsoft as a risky user. I have been into the DNS to find out if there is something there I should change, now I am in Azure to…
ADD Column will not show CheckBox
Hello, Using Access database engine + oledbreader on mdb, this code will add a new boolean yes/no column: New OleDbCommand("ALTER TABLE BlahTable ADD Column BlahOption BIT NOT NULL", strConnection) :: ExecuteNonQuery This will add a yes/no…
Office Access Refactoring
Hey, In our company we've a legacy software based on Office Access. We have access to the accdb-File with all sources. This software is connected to a SQL-Server Database. We want to tidy up our database therefore we need to now which columns are used by…
Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former Access MVP, Dale Fye who will be discussing working with…
Connection string working for WinForm but not working for asp.net
Hi In a net framewok WinForm app below connection string works in x86 and Any CPU active platforms. connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Password=;User ID=Admin;Data Source=' S:\MyPath\MyDB.mdb';Mode=Share Deny None;" However in…
Database version
Hey everyone This wiki table is referiong to different Access ACE database versions: https://en.wikipedia.org/wiki/Access_Database_Engine ie ACE 14 supports database version 3.x and 4.0 ACE 15 and 16 only support database version 4.0 My question is that…
mdb/accdb to use with Access database engine
Hey I need to create an Access database in Office Access and make the tables and fields, then deliver the blank file with the vb.net app which will use Access database engine 2010 and OleDbRerader to work with the database. Just need to decide between…
Microsoft Teams chat
Hello, I have one question for you. I don't know that is work or not But i just want to know. Now we created the teams chat group and add the all office department members for IT Help Desk issues. At that time, one of member from marketing dept(eg:) send…