There are two things bothering me when I open a table in the front end Access 2000 with the back end SQL2000. I am not using Access Project front end. I have administrator privileges on the account.
First the plus sign (+) along side the top relationship work great for the old relationship I created a year ago. This year I have added a new relationship to the top table but it does not show in table view of the DB. Is there some properties that I can change how the 'Expand' plus sign works?
Second also in table view I should be able to change data but I get the "There is another person editing the Db" and I have to abort the changes. I am the only one in the database. I end up changing the data on the server but how can I "unlock" the changes mode?
One semi related item I'd like to include; I have given a user change rights to the DB but the system also reject her changes. She then must open a Access Project front end to make these (Spelling) changes. Even then sometimes she cant make the changes and I must go onto the server to do the corrections.