database - Can I edit access backend file while others are using it? -
how can edit backend file of access database while others using it? understanding has been can't, wanted confirm before commit lot of late nights. , in regards "how can edit it", mean tasks such adding fields tables, deleting them, adding new tables etc. also, how compare working sql server backend? if it's not apparent, database split, , have low number of users (1-2) on @ time. i'm using access 2007 thanks in advance. i not edit live back-end, however, can make most, or possibly all, of changes on empty copy , append live data various tables little sql , vba.