Recent content by Pete490h

No they’re both Access 2021and I regularly decompile and compact

Yes it does a daily backup, however it overwrites the following day….

Thanks for that, I’ll change and try asap and advise accordingly Yes I compile the database on my PC

Hi, I have a new event procedure (below) which works absolutely fine for me but fails on my two Runtime users Has anyone had similar issues with Runtime as its the first time its happenened to me Just wonder if anyone can see any issues thanks Private Sub InTest_Click() 'STATUS "Deleting...

Thanks Arnelgp, When you say when front end is closed, I have 3 users via runtime, so would the code run every time they close

Just wondering if anyone has created a routine that carries out a daily backup of the backend database to cover each weekday So on this Tuesday it backs up database_be.accdb to databaseTue_be.accdb, then overwrites next week etc

Thanks Gasman, I’ll give that a go later when back home👍

Hi, A customer of ours has asked that we look at importing data from their excel spreadsheets into our access database system They issue unique individual spreadsheets which we store in a master directory in Excel CUSTOMER XLSX 716.xlsx 719.xlsx 725.xlsx 740.xlsx etc etc In our system, we...

Hi, Earlier today I installed Access Runtime 2021 on two PC’s that previously had runtime 2010 After installation I uninstalled runtime 2010, then opened our database on a runtime 2021 pc but was met by a security notice advising that I check that it was a trusted database When I clicked okay...

Hi Pat, I’m having the same problem….. I upgraded to Access 2021 then uninstalled 2010 along with Access runtime 2010 The vbs script attached still tries to open Access 2010 ???? Any ideas😉

Just tried this and it works thanks👍 So when I need full access, I simply change the file back to the accdb extension, make any changes then back to accdr etc, right

Hi, I’ve recently upgraded to Access 2021 on my laptop and require full access to the tables, forms, queries etc as I am both the designer and administrator plus Access 2021 runtime Before I installed Access runtime, I had full access etc but since I’ve added runtime, I don’t seem to be able to...

Yes I’ve installed as 32 bit on my test system at home and like you said, upgrade was ‘a piece of cake’, but before I install on my works environment, just wanted to check….. Think it’s going to be safer to leave as is thanks

Thanks for your offer, think I may leave at 32

Just wondering if this is possible….. We currently have Access 2010 database and runtimes installed as 32 bit but are upgrading to access 2021 on all PC’s Is it possible to install as 64 bit and if so, will our database still work