I have excel marco, which does sql -queries to access base (in snapshot mode)
Problem is that I have to manipulte data in access: 1st I pick every item for certain product from databases into one auxialiary table (there is about 20 different products which all have their own table). 2nd, I start to move items from auxiliary to another auxiliary table, narrowing amount of items according users selections in excel userform. (selecting items in userform creates sql queries which move items) When user has gone trough multiple userforms selecting narrowing terms, items are listed into excel sheet.
Problem is that although I have locked my access database, I cannot mark it as read only (macro in excel stops working). When multiple users are using same excel macro same time, they sometimes get wrong listing, as moving itmes from auxiliary table to other is done byt multiple users.
So, is there way to allow multiple users to access same access database without them interrupting each other? Do I need to modify my excel VBA -macro, or do some tricks into access database. (which is saved in excel '97 format, since some of users are still using pretty old versions of windows)
Problem is that I have to manipulte data in access: 1st I pick every item for certain product from databases into one auxialiary table (there is about 20 different products which all have their own table). 2nd, I start to move items from auxiliary to another auxiliary table, narrowing amount of items according users selections in excel userform. (selecting items in userform creates sql queries which move items) When user has gone trough multiple userforms selecting narrowing terms, items are listed into excel sheet.
Problem is that although I have locked my access database, I cannot mark it as read only (macro in excel stops working). When multiple users are using same excel macro same time, they sometimes get wrong listing, as moving itmes from auxiliary table to other is done byt multiple users.
So, is there way to allow multiple users to access same access database without them interrupting each other? Do I need to modify my excel VBA -macro, or do some tricks into access database. (which is saved in excel '97 format, since some of users are still using pretty old versions of windows)