Search results

Is anyone else having issues with LTSC version below? Microsoft® Access® LTSC MSO (Version 2408 Build 16.0.17932.20602) 64-bit I have a client with a mixture of licences and the one above is crashing after initial opening, the will only open in safe mode. The same database file opens fine on...

I've an found an interesting bug with the SQL Server Migration Assistant for Access (SSMA) recently. I was trying to import / migrate data to a Azure SQL database, from an Access database that had most of it's date fields set to Date/Time Extended . SSMA refused to identify them as any type of...

I'm sure this has been mentioned before but I thought it had been addressed, or we had a workaround. When importing data using SSMA that includes Boolean (Yes/No) fields, if you accepted the default mapping of Byte datatype then SSMA swapped all your lovely -1 data to +1's. Which meant that if...

I'll try and describe this as simply as possible. Take a multi-column combo box where one of the columns is a Decimal/Number field sourced directly from a table. The data type is a number type - Currency / Integer makes no odds, but it does allow nulls. In VBA you assign that value to a...

Hi All, After updating to version 2312 (Microsoft® Access® for Microsoft 365 MSO (Version 2312 Build 16.0.17126.20126) 64-bit) We have a new and nasty bug - if you check and reset a connection string using ? currentdb.TableDefs("AnyLinkedTableNameGoesHere").Connect The returned result is...

I have an interesting query involving moving vehicles around and optimising the drivers over those routes. I'm not sure this is even a sensible process to try and manipulate in Access but I thought I would ask as there are some very clever people in here :D Given the following data what would...

I have worked around this but thought I should highlight this as it's very frustrating. A SQL table (Azure SQL) has a Datetime2(7) column which when referenced from a form control in VBA come back with a TypeMismatch error (13) Even trying to debug.print the offending value fails. This is...

This is happening to a number of users but not all, which makes fixing it rather troublesome. I use the code below to return an IPv4 External IP address, so that we can automatically update an Azure SQL firewall, via some clever HTTP encryption. It's loosely based on a number of similar codes...

Recently I have had a lot of issues with opening databases not working (Various ones, almost all are Azure SQL BE). I either double click in file explorer, or right click the Access Icon that's a sticky in my Windows tool bar. The database opens, but not in a visible fashion, there is a...

I came across an interesting gotcha the other day. From a linked SQL server backend we were generating a sequence number using the Rank() Over function. This returns a BigInt data type, it appears that Access Runtime 2016 version doesn't recognise this datatype, but I can't find any official...

The Queen has died this afternoon. A sad day for the UK, even if you aren't a Royalist. https://www.bbc.co.uk/news/uk-61585886

As per this thread here https://answers.microsoft.com/en-us/msoffice/forum/all/ms-access-displays-deleted-in-every-field-for/593e5f12-3cbd-414e-841c-9df612504d3c?page=3 Originally about Oracle, we have now seen this in two Azure BE client databases in the last 2 days, making me think another...

Hi All, I suspect only @Isaac may know about this, but looking for clues. I can't get a cloud Flow process to move an email in a shared general email box. The process is triggered on new email receipt. (O365 account the It then checks it not internal. If not it calls a stored procedure to look...

Hi All, I have a file dialog I use to get the location of various files for importing (shown below). I have an issue with a client who uses file redirection at a corporate level and keeps getting an error - Error 70 Permission Denied. In my testing, if I set strInitialDir to anything that...

Hello Campers. This seems to be a repeatable bug - O365 here are the steps 1. Goto any old form and select a load of text box controls (ONLY textbox controls) 2. Copy them, right click or ctrl+c 3. Paste them. Anything happen? Not in any of my databases. Now repeat the exercise with subtle...

I've been asked to look at providing a method of monitoring a shared generic Inbox in O365. (Think of it like a service call mailbox service@yourco.com) This would be pretty straightforward in an Exchange/SQL on-site environment, but with cloud storage involved, it becomes a little more...

I think I am going mad. I am trying to extract a word in a variable-length string after a specific string. The field is imaginatively called Description. This really needs to work in a query and I'm a bit anti writing a function as it seems overkill. There is a string I can identify and find...

Hi All, I'm undecided about this so thought I'd ask the great and the good, bad and the ugly... I need to have a reference table for countries (and various other fields) and am wondering do I add a primary key ID and use that or store the ISO country number? Previously I have only ever need a...

MS are switching off UserVoice https://www.devhut.net/2021/03/10/bye-bye-uservoice/ If you read Daniel's excellent review of the stats I can see why - it's been completely ignored.

I seem to be stuck on Shades of Blue - or possibly "Shades of Blue with Green bits"? Wot's happened?