Recent content by puressence73

Hi Bob, Thanks very much, that done the trick. Now I have something that works... :-)

I am trying to re-open using the following code driven from a command button on a form in Excel. Private Sub BckAcc_Click() Dim oApp As Object Dim LPath As String Dim LCategoryID As Long 'Path to Access database LPath = "C:\database project.accdb" 'Open Access and make visible...

Hi Bob, Maybe this will explain what I am trying to overcome. If I try to open the Excel spreadsheet whilst the DB is open I recieve the following error from Excel. "You attempted to open a database that is already opened by user " x " on machine " y ". Try again when the database is...

Hi Gemma, Yes it's frustrating. I am starting to question whether it is possible or not. Thanks M:-}

Hello, I have an Excel spreadsheet which is linked to 2 tables in an Access database. The reason for this is to generate and calculate tax details, which is easier in Excel than Access. I have a macro in my Access database which closes the only instance of Access and opens Excel. As soon...