I am trying to edit/design a current table in the DB, however, I get the error
code that it (can't open due to open or bound table)..
1)There are no open tables. (I am aware of)However, there is a unopened excel file on the server that has a msquery that points to it. (the table i want to edit design). It does a pivot table.
2)I do not think there are any other users, but, I do not see a list
of the access db users. Is there a way? I am admin, but, they all are also.
MsgBox ("The current user is: " & CurrentUser) SHOWS ME, SO THAT DOES NOT WORK.
THANXS.....................
code that it (can't open due to open or bound table)..
1)There are no open tables. (I am aware of)However, there is a unopened excel file on the server that has a msquery that points to it. (the table i want to edit design). It does a pivot table.
2)I do not think there are any other users, but, I do not see a list
of the access db users. Is there a way? I am admin, but, they all are also.
MsgBox ("The current user is: " & CurrentUser) SHOWS ME, SO THAT DOES NOT WORK.
THANXS.....................