Search results

Hi Arnel, I copied the code from the .mdb on to the new button and nothing happens when it is clicked. The mdb was likely created in Access 2003 or earlier. At some point I think the .mdb may have been imported in to an access 2010 .accdb blank database and then saved as a 2003 compatible...

Hello All. I work in a hospital and have been working on a .mdb/.mde using Microsoft Office 2010. We are eventually upgrading to Office 365, which means I have to upgrade the database to a .accdb/.accde. To do so, I created a blank database and imported over all objects in to a new .accdb...

Hi Pat. Thanks for your advice. As I have taken over the DB I will have to try and correct all of these relationship issues as I have come across a few more. I have just had the same issue whereby a query that worked OK in the previous version, but since exporting the database in to a new 2010...

Hi arenlgp, The archived DB which works fine has the following join between the ContractSubform table and ImportEquipment table. I will change the join on the new database as it works OK. Thanks

Hi Both, Thanks very much for your help. CJ, I opened up an archived version of the DB and it was working OK. I therefore changed the recordset to dynaset - inconsistent updates as you recommended and it the subform now allowed me to add a new record. arnelgp - I then changed the subform back...

Hi Both, I have opened the query and it does not allow updates, see below: I have no option to add a record. When I try to edit a record 'This recordset is not updateable' pops up in the bottom left corner. Below are the relationships in my query: The Contracts part of our system is...

Hi All. I was working on a database in the old .mdb/.mde formats. I have created a new database and imported all objects in to the new database and saved as .accdb and created .accde front end. I have a form that contains 3 subforms within it, 2 of which are working as they should. The other...

Hi All. To link my tables to the backend, I was using the linked table manager to select the new location, which was opening a file browser for me to link to the backend. This meant that my filepath to the backend was G:\Engineering\Database\Backend.accdb The issue was solved by manually...

Hi The_Doc_Man, The frontend has always been distributed with the shared mode option selected, however, the shortcut that we have always used for our frontend .mde file uses the following path: "C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE"...

Hi All. Our IT department are impossible to work alongside with and are regularly introducing new hurdles for me to get around. The latest is that I am getting network interruption messages when accessing our shared network drive, multiple times per user per day. I have been reading up a bit...

Haha OK. Maybe I'll take less notice of this then. I was just curious at to what this could mean.

Regarding the addendum, thanks for that I'll look in to this.

I have just checked and we are at different OS Build Levels. All of the FE files are distributed from the same place, and all have the shared option selected in the client settings tab. Would different OS Build Levels cause issues? I'm not too sure why we're on different build levels because...

I've just checked and we're all using Version 14.0.7628.5000

Hi All. I am having network disruptions ever since upgrading from .mdb and .mde to .accdb and .accde. I may be clutching at straws as I'm struggling to get to the root cause of it. But I have noticed that when I copy my front end to my computer, my .accde and lock file have a gold padlock on...

Another Finding. My .accde file has a gold padlock on it, that looks like this.. My colleague has a blue padlock on it, that looks like this... ignore the locking file beneath it, this is from the old .mde file. From my experience when I opened the .mde, the .mde did not have a padlock...

I did not intend to open it exclusively. I am 99% certain that a lock file was not created when I was inside the database. I just opened it as normal. How easy is it to open it exclusively? We are all accessing the database through a shortcut that I created which contains the following path...

OK so I've just had the IT department access the Event Viewer and they were unable to find anything. I have just been looking at the folder where my front end is stored, and I still have a copy of the old .mde as well as the new .accde frontend. While I had the .accde frontend open, I'm almost...

Thanks the doc man. I've put a request in with the IT department to be given access to the event viewer. So far today, in 8 hours, there have been at least 15 network interruptions. I can't seem to piece together any regular interval between them so far. I created a test database, with a...

Hi The Doc Man, So after 2.5 days on working a 2003 .mdb backend, with people being idle for long periods and even staying logged in through the night, I decided to update the .mdb to .accdb. Within 2 hours of updating, 3 members of staff have had network interruption messages. As I work in a...