Recent content by Auntiejack56

  1. Auntiejack56

    this version was configured for a 32-bit version of access

    That's great confirmation about using the accdb files. In this COVID mess I've been restricted to using TeamViewer, and while it's a great thing, it's no substitute for just keeping an eye out for when users are available and checking their versions, so my 'feel' for the overall office...
  2. Auntiejack56

    this version was configured for a 32-bit version of access

    Sorry to keep replying to my own posts, but I found a note from DocMan which made me question whether sending out accde files was a good idea, so I've dropped back to sending the accdb and I'll see if that works. Jack
  3. Auntiejack56

    this version was configured for a 32-bit version of access

    Found it - I looked here a dozen times and didn't see it. File / Account / About Access, then in tiny print at the top at the end of the version/build number is says 32-bit. So looks like an upgrade for some users and not for others - ew. That just makes it worse. It would be ok if they were in...
  4. Auntiejack56

    this version was configured for a 32-bit version of access

    Sorry, but where do I look for the bitness of my Access 365 version? I've hunted high and low - I just assumed it was 64 bit but a client got the following message after opening my new app: "this version was configured for a 32-bit version of access". Any clues would be appreciated...
  5. Auntiejack56

    SQL responds quickly for first data request, then sluggish for any others

    Thanks Minty, I in fact took your advice, got myself an Azure database, bustled through all the connection stuff, did an hours ETL to fill with data and hey presto, the goldarn application runs like a dream. So armed with that information I've fronted up to the DBA and did a 'ploise exlpine'...
  6. Auntiejack56

    SQL responds quickly for first data request, then sluggish for any others

    As far as I know, it's in an Azure environment.
  7. Auntiejack56

    SQL responds quickly for first data request, then sluggish for any others

    Hi, I have an Access 365 FE with a SQL Server Express backend. It works fine in test on my machine (which has both FE and BE). FE is 4mb, backend has half a doz fact tables with 2-300 records in each. I've migrated the SQL to the client's (cloud) server, and connected the FE to it from the...
  8. Auntiejack56

    Digital signatures

    DBGuy, I'm using 365. Isla, I started down the rabbit hole of code signing because I trialled SSE Setup the other day, and it has a big chunk of information on code signing, all doubtless relevant and important. But the installs I do aren't delivered over the web (they are all custom products)...
  9. Auntiejack56

    Open Exclusive

    Thanks all, very much appreciated.
  10. Auntiejack56

    Digital signatures

    Here I am again, sorry folks, picking your brains ... I was looking into getting my code signed, and found a few CA vendors like Comodo and DigiCert and was considering signing on the dotted line when I found this...
  11. Auntiejack56

    Open Exclusive

    Hi DocMan, good points which I will follow up. I rather suspect the notebooks might be a little weedy, although if they aren't docking them and they are reliant on wifi, that can be woeful (wofi haha - ahem). Thanks.
  12. Auntiejack56

    Open Exclusive

    Thanks, if I reply in a state of euphoria, you'll know it worked. Silence will indicate grim determined persistence and black coffee.
  13. Auntiejack56

    Open Exclusive

    I'm guessing that if you specify 'open exclusive', Access will be able to bypass all its locking and 'who's using what' code when opening and closing forms. And if so, perhaps it impacts speed? Frankly, I'd be surprised if it made much of a difference, but equally frankly, I haven't encountered...
  14. Auntiejack56

    Open Exclusive

    Hi folks, I have distributed split databases for clients over a number of years, with front ends always deployed to each users C drive, and optimised in fairly standard ways that you'd all be familiar with. In the present case, I am deploying to users with weedy little notebooky things that are...
  15. Auntiejack56

    Exporting query to Excel without saving

    JHB's answer is correct. Your .Close is closing the database object, so the recordset could not be created. Jack
Top Bottom