Search results

Hi all, Have a suspicion what I'm trying to do is simply not possible in Access (as opposed to SQL Server) but figured I'd ask before completely scrapping it. I have a table - consisting of two fields of ID's (basically a junction table) - but no formal relationships, so no foreign keys etc...

Very good point! I don't think Click-To-Run is used much here but I shall file this in the "Maybe" column for the next time it falls over! 😵🤪

Thanks @arnelgp - this seems to work pretty well! I made one modification as I don't particularly want to launch Access (in order to determine the path to the MSACCESS.EXE), then exit and relaunch Access again - so I subbed that part out and replaced it with a registry read : Set objShell =...

Thanks @Ranman256 but this is VBA, not VBScript - VBA not an option as I need to determine the bitness before I launch the ACCDE

Hi there, I've run into some difficulties with a distributed Access DB (that is, a central ACCDB backend with distributed ACCDE frontends) The front end utilises some API's which obviously have to be declared differently in the two configurations (made pointer-safe in 64-bit) and I've...

Yeah I followed the rabbit hole to that CopyMemory API, it was already PTRSAFE'd but there must be something twitchy between it and O365 which I really can't be bothered researching (it's a nice-to-have rather than an essential) Like I say, if there's a way of pulling the system fonts into a...

Figured it out... As usual, 4 hours of debugging, then as soon as I post a question on here, I figure it out myself... Sorry!... So it looks like it's an API that was added when this was first developed in Access 2013 which is now being troublesome in A365 (or whatever it's supposed to be...

Hi there, I've been making some modifications recently to an Access DB that's been in production for several years. Standard FE/BE split design, single BE ACCDB sitting on a network drive and distributed FE ACCDE's. I have a master copy of the FE locally and I make whatever updates are...

That's worked a treat, thank you so much! I'd been fiddling with the pointers but needed a steer on which ones were causing the issue! I would be 99.9% sure everybody is on at least 2010, if not in fact 2013, but I'll keep the old syntax in there just in case as it's easier to keep it and have...

Hi there, I have a module which I use to pull the local system font information into a local table (literally just the available font names) which I've done via EnumFonts as follows : Declare Function EnumFonts Lib "gdi32" Alias "EnumFontsA" (ByVal hDC As Long, ByVal lpsz As String, ByVal...

Thanks guys, Looks like it was tab ordering I have a command button as the leftmost control of each record (to allow a quick delete) but had it at the bottom of the tab order as I didn't want it to take the focus on loading (lest anybody accidentally hit the Enter key - even though it prompts...

Hi there, I have a continuous subform residing inside a parent form. I recently added two columns to the subform and now for some reason every time I load the parent form, the subform is always partly scrolled, horizontally, to the right, by a couple of centimetres. I thought it may have been...

Oh, yes, 100% - assuming a) the user knows how to navigate their way around the skeleton of Access and b) they're motivated to even bother trying I have the Navigation Pane hidden and locked so F11 won't let prying eyes into the engine room, intentionally or otherwise. Yes, one could hold the...

Indeed - I would have thought opening exclusively was a very specific process rather than anything that could happen accidentally? A front end .accde couldn't open the backend exclusively "by accident" could it? Unless it was designed / coded to do so (it's not) I also hide the backend (as...

Just to confirm - backend was indeed the source of the problem Restoring the last backup has rectified it Can only guess that one of the local front ends forced a permanent record lock on one or more tables that was immutable - to be honest, I've never experienced that before, nor can I see...

Hi CJ, Correct, it's a standard split DB, everybody has their own local copy of the front end and a single production backend on the server It seems to be the backend that's corrupt Thanks AOB

Thanks again Colin The SQL is correct (as it has always worked) The issue seems to be the production backend - I switched in a backup and the recordsets are all updatable so there must be some corruption issue in the live version. If there is, it's not immediately obvious as there are no...

Thanks Colin, It's not a saved query, it's generated at run-time - but very vanilla and has ever been an issue before : Dim dbs As Database Dim rst As Recordset Dim strSQL As String Set dbs = CurrentDb With dbs strSQL = "SELECT [tblTable].* " & _ "FROM [tblTable] " & _...

Hi there, I have an Access DB which has been in production for several years. This morning, users reported issues loading it up and running any of the functionality. It appears that recordsets which were previously used for data manipulation, are no longer updatable (??) These recordsets abide...

That escalated quickly... :D So I got around the problem by replacing my single plain textbox with a handful of other controls. First I added three local tables; one which stores all the "valid" codes, one which holds any duplicates of the valid codes (and the count of the dupes) and a third...