S
Stuart Bratesman
I've found a peculiar bug in Access 2007 SP1. If you create a link to a
table that resides in an Access database protected by user-level security,
you cannot delete the link. When you try to delete or cut the link you
receive the following error message:
_________________
" is not a valid name. Make sure that it does not include invalid
characters or punctuation and that it is not too long.
——————————
The linked table is named Contacts and it has no invalid characters.
If I try to delete the link programmatically in Visual BASIC using the
command,
DoCmd.DeleteObject acTable, "Contacts"
the Visual BASIC code stops running at that line and returns control to the
form that called it - without displaying any error message.
I can rename the link in Access 2007, but I can't delete it.
I can open the same database in Access 2002 and delete the same link
without any problem.
The problem does not occur in Access 2007 if I create a link to a table
that resides in an unsecured database. I can delete that link without any
problem. It does not matter whether the database in which I'm creating a
link has user-level security or no security. It only matters if the database
that holds the original table employs user-level security.
I should note that the secured database is saved in the Access 2000 file
format to allow backwards compatiblity with other users. The databases in
which I have been creating the links were created in the Access 2000 .mdb
file format and in the Access 2007 .dbacc file format.
I am using Access 2007 SP1 and Windows XP Professional SP2 on a Dell
Optiplex 745 desktop computer using an Intel Core 2 Duo processor and 2 GB of
RAM.
I would appreciate your advice if you know how to solve or work around
the problem.
table that resides in an Access database protected by user-level security,
you cannot delete the link. When you try to delete or cut the link you
receive the following error message:
_________________
" is not a valid name. Make sure that it does not include invalid
characters or punctuation and that it is not too long.
——————————
The linked table is named Contacts and it has no invalid characters.
If I try to delete the link programmatically in Visual BASIC using the
command,
DoCmd.DeleteObject acTable, "Contacts"
the Visual BASIC code stops running at that line and returns control to the
form that called it - without displaying any error message.
I can rename the link in Access 2007, but I can't delete it.
I can open the same database in Access 2002 and delete the same link
without any problem.
The problem does not occur in Access 2007 if I create a link to a table
that resides in an unsecured database. I can delete that link without any
problem. It does not matter whether the database in which I'm creating a
link has user-level security or no security. It only matters if the database
that holds the original table employs user-level security.
I should note that the secured database is saved in the Access 2000 file
format to allow backwards compatiblity with other users. The databases in
which I have been creating the links were created in the Access 2000 .mdb
file format and in the Access 2007 .dbacc file format.
I am using Access 2007 SP1 and Windows XP Professional SP2 on a Dell
Optiplex 745 desktop computer using an Intel Core 2 Duo processor and 2 GB of
RAM.
I would appreciate your advice if you know how to solve or work around
the problem.