Search results

Yes it works fine on the other server (used mainly for Exchange server), creates db1.mdb, deletes original and then renames db1 to orginal in the usual manner. BUT on our data server it created db1, deletes original and then errors that the file was read only so it can not delete it - basically...

Hi Bob, thanks for the reply! I am IT and no permissions have changed, we have LOTS of access databases and it does this on most of them. We use Office 2003 Pro SP3 on terminal services. Some of the databases are split but some it fails on are just used as transfer files so they are very small...

This problem has literally just started to happen to me too on databases we've used for years, seems to do on some but not all or intermittently anyway. Any ideas please???

Thank you sooo much Bob! That worked now using your example and adding my requery code. Great stuff and thanks for the quick reply! Most appreciated :-)

Hi all, I have a main form called Activity Log which has four tabs on it. Each tab has a different subform. When one form has a date entered it alters information (actions) on another tab via code. When the user then clicks on the Action tab I want the latest to display. I assumed I needed to...

Hi Bob, thanks! That helped a little, I can now see the problem I think - it leaves open a copy of the position workbook which I open earlier in the code and don't close. I think I need to know the syntax to close this specific worksheet. More of the code below, thanks for your help witht this...

Hi all I have some code which uses excel templates to insert query data in and email to customers. I can't seem to quite get the code right for cleaning the excel operation afterwards. If the user already had a copy of excel running, I want to close these new worksheets only but leave any other...