Hello,
I am in charge of maintaining a little ACCESS database used by our purchasing department. I need to add some new values to a table, but I can't open the .be database in order to access the table involved.
Not really understanding what is keeping me out, I have investigated a .ldb database, which I believe is a locks database. I can open this with textpad and, even when all users are logged out of the application, there is one machine name still in the table. I corresponds to 3 people, who I cannot believe were logged into this database at 7:50 a.m. They are all systems people, including one who is the domain administrator (the database is location on a network drive).
Does anyone have any suggestions as to whether this locks file is keeping me from accessing the backend tables, or have another idea about why I can't open the backend tables. I can click on the file name in the directory, get the message about opening even with macros, and then nothing. the fetch hourglass disappears, but the ACCESS window remains empty.
Many thanks.
Susan
University of New Orleans