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…
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…
How to use JSON format, Edit column and conditional column options to show or hide columns based on different users.
Hey there, I am facing issue on Sharepoint List, I want different users should see different columns based on our requirements. I have 15 columns so now i want user1 can see only 5 columns, user2 can see 8 columns and user3 can see all 15 columns. I also…
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…
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,…
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…
How do I change validation rules in Access when I can't find the original table?
Please excuse my ignorance...I have not had the need for Access for five years. I have a data input table that was designed to make it easy for data entry, with form view, design view, and datasheet view. When entered, the data can be seen in the Data…
how to format ms access dates with odbc data source
M365 Access App FE on PC win 11 - SQL Server Express back end on server. Can't format dates in form txt controls bound to appropriate date field from BE.
Why am I receiving this Error - Records in table <name> would have no record on the 'one' side.
All of a sudden my Access Query is giving me the error - Records in table <name> would have no record on the 'one' side. Works on my Laptop doesn't work on Clients Laptop!
How can we automate snipping tools through VBA?
Hi everyone! Im trying to automate the Sniping Tool Windows 11 and to use his OCR feature. Somebody knows how can I get it?
Outlook saveas did not save the embedded image added from vba or build manually
Hi folks, We run a vba code that create email using data from an Acess database. We add some picture using html format for the email and save it in Outlook format(msg) to read them later. When I display it, we see the image inside the email. After using…
summary report for blank values per field in access
We have a large table of data (several thousand records), and a significant amount of fields is recorded for each record. The design of the table means at present some fields are mandatory (required), and others are not required – which I think was…
IIF function and dates
Hello I was asked to make a change in the code I am currently calculating how much a student should pay The students have an arrival date, from here it automatically calculates for them the amount according to what was agreed monthly and the days of…
verify jwt (access_token) by python
hello, I have a front in angular and a backend in Django Python. I take my access_token from my front by: this.msalService.instance.acquireTokenSilent and send it to my backend api, i need to verify and validate this access_token before anything will…