Hi everyone,
Sorry if this is in the wrong place and sorry if I'm asking a ridiculous question but I've scoured everywhere and whilst I can find some hints to the problem I have, there's not much in the way of solutions.
A few months ago, I was tasked with creating a database on the cheap for work with a view to storing inspections, vehicles and that kind of thing. Unfortunately, we've grown quite dependant on it (someone I warned everyone not to do) and it gets hammered and added to every day so there are now all sorts of queries, reports and thousands of records.
Now that you've got the background, I'll explain the problem! I added a button to a form I'm using as a switchboard, closed it, was prompted to save the changes, clicked yes and it doesn't close. In fact, the only way I can close it is to not save any changes I make. If I try to copy the form I get presented with a message claiming that it conflicts with another object (even if I call it something else). My panicked research last night and this morning has revealed it might be something to do with permissions but nothing has changed in the last few days for that to happen. The file is stored on a server and 4 machines in the office routinely use it along with two people who VPN into us. The only suspicious thing that occured was yesterday morning I got in and the lock file was there even though I couldn't see anyone who might have had it open.
Please help. It doesn't look like I can copy objects out (reliably) and I'm now left with a database that has a form I am completely unable to change. Not to go for the sob story but I also have a boss who demands everything YESTERDAY and goes crazy when the slightest thing goes wrong!
No pressure!
Many thanks,
Adam
Sorry if this is in the wrong place and sorry if I'm asking a ridiculous question but I've scoured everywhere and whilst I can find some hints to the problem I have, there's not much in the way of solutions.
A few months ago, I was tasked with creating a database on the cheap for work with a view to storing inspections, vehicles and that kind of thing. Unfortunately, we've grown quite dependant on it (someone I warned everyone not to do) and it gets hammered and added to every day so there are now all sorts of queries, reports and thousands of records.
Now that you've got the background, I'll explain the problem! I added a button to a form I'm using as a switchboard, closed it, was prompted to save the changes, clicked yes and it doesn't close. In fact, the only way I can close it is to not save any changes I make. If I try to copy the form I get presented with a message claiming that it conflicts with another object (even if I call it something else). My panicked research last night and this morning has revealed it might be something to do with permissions but nothing has changed in the last few days for that to happen. The file is stored on a server and 4 machines in the office routinely use it along with two people who VPN into us. The only suspicious thing that occured was yesterday morning I got in and the lock file was there even though I couldn't see anyone who might have had it open.
Please help. It doesn't look like I can copy objects out (reliably) and I'm now left with a database that has a form I am completely unable to change. Not to go for the sob story but I also have a boss who demands everything YESTERDAY and goes crazy when the slightest thing goes wrong!
No pressure!
Many thanks,
Adam
