Search results

Hi The Doc Man My mistake, initially the network interruption seemed almost regular, but eventually I had it at much more frequent times, including just a 5 minutes or so after signing in. Hi shadow I will implement the persistent connection on my .mdb for now. Unfortunately my admin rights...

Hello All. I have a primary key that automatically updates when a new record is added or an existing record is duplicated. Today shortly after adding a new record, I received an unrecognised database format error message. After compacting and repairing the database, I went back in and attempted...

Hi The Doc Man, Our IT team do implement group policies, but I'm not too familiar with them or how they affect our group of workers. The database doesn't contain any patient data, so we tend to get left alone due to the fact there's no sensitive information in our database. The old .mdb and...

Hi Pat, we're using Office 2010. I have reverted back to the .mdb and .mde as I had another network interruption message this morning. If everything is stable by the end of tomorrow, I will add in the new design changes that I made to the .accdb, but keep the file type as .mdb, and see if this...

Hi Pat. Thanks for the advice. All PCs have wired connections to the hospital's network, which then connects to the back end on the shared drive. The system has been stable for 20+ years despite a few hiccups. I have solely been in charge of the system for 18 months or so, and it has only been...

Thanks The Doc Man, great advice. I will implement this and see how it goes. Users are always asked to log out of their DB when leaving for the day, but this isn't always followed. I may look to implement an auto sign out feature in the future, but for now I will try what you said. Hopefully...

That's good to know. Unfortunately the non-visible form has not fixed the network issue. This is the first time I've consistently had this issue in the 15 months or so of managing the database, and has only occurred since I implemented the new design features. Unless there's a big coincidence...

Hi Isla, Below is a picture of the table. When hovering it does show a link to the back end table on the shared drive. Would the spaces cause a network disruption? The only thing that is completely different between the new changes and the old is that we used to login using a system .mdw...

Thanks Isladogs. I have created a table called persistent connection with 1 record and 1 field. I have added the following code to the Login button which opens thes databases main page: DoCmd.OpenForm "Persistent Connection" Forms![Persistent Connection].Visible = False I'll give this a...

Hello All. So I've updated my .mdb files and .mde files up to accdb and accde files. Since upgrading them, renaming them and making a few design changes, several users are getting a 'Your network access was interrupted' message on their split front end. I have read that this can be due to...

Thanks Gasman. On second viewing, I have just noticed that there is a BeforeUpdate event which updates the currentuser and edited date when a change is made. I've taken over the database recently so wasn't aware of this.

The database has an inventory of equipment, which stores a record of who and at what time it was last edited. This record updates whenever somebody enters in to the edit screen of the equipment and makes a change to it. Currently if you enter the edit screen but do no make a change, then the...

Fantastic, thanks for all your help.

Hi Bastanu Thanks for your help, that makes sense. However I'm not familiar with appened queries. I understand how an update query could do this job, by finding a record where [username]=TempVars!tvarUser and Exit Date is null, and updating the Exit date to Now() Would this work the same as an...

Thanks theDBguy, that works perfectly! Now what I need to do is add an Exit button that will store the logout date and time, this will follow the same code as above, but I need to try and add it to the same record that the login data is stored in. Any ideas? Thanks

Hi All. I have introduced a login screen to my database which requires a username and password to be entered. After logging in successfully, an Intro Page opens which displays the current user that is logged in. I done this by putting the following code behind the login button...

Thanks Pat, makes perfect sense. I have imported the .mdb in to a new blank database and I've compiled it, and there are no errors. I will definitely add option explicit to the modules and ensure all works perfectly before any users make the switch over.

Thanks Arnel, I've followed the advice from the following link: https://www.datanumen.com/blogs/how-to-protect-your-sensitive-data-with-a-login-form-in-access/ It allows me to add a login screen upon starting the database, which is perfect for what I need. I currently have many textboxes...

Hi Both. So first, the option to add a Trusted Location was greyed out and not available. Secondly, I opened the .ACCDB inside of Office365 and everything opened fine, with all of the references working OK. I've compiled the .ACCDB and no errors were picked up. Thanks both for your help...

Hi Arnel, Unfortunately I don't see a macro warning. Thanks