Hi
I've finally made a database that I'm pretty happy with as it's my first go, I'm sure I've done a lot wrong to annoy the experts, but I'm really enjoying learning how it works.
I'm having an issue, my database has a linked table in it, this table sometimes needs to be opened by users to make some edits, if the database is open when they do this, the database crashes. I think this is happening because the linked table is also looking at the database in the form of a query. So I think some circularity is causing some problems.
So to summarise:
Database1 looks at spreadsheet1 (as a linked table)
Spreadsheet1 also looks database1 (as a access query)
If the spreadsheet is opened while the database is already open, it opens read-only
if the database is opened while the spreadsheet is already open, the database crashes.
Is there anyway to have them both open and still be able to make changes to spreadsheet1.
I realise that it would be better to not have a linked table and just have spreadsheet1 as part of database1 as an import, and then make all the changes in the database, but at this point in time, this isn't feasible.
Many thanks,