Altered SQL table locked for edits in Access 2002 front-end

I have altered SQL tables and then relinked them to a
Access 2002 front-end and receive the following
message "The Microsoft Jet Database engine stopped the
process because you and another user are attempting to
change the same data at the same time"
When the SQL table is altered there are no users currently
connected to any of the SQL or Access Databases.
The SQL table being altered is related to many other SQL
tables.
The alter statements are adding new fields to the table.
Please help!How are you altering the SQLS tables? From Access or some other tool?
Access caches linked table schema locally, so if you are going to make
modifications to the table schema, you need to delete the existing
links in the FE, make your changes on the BE, and then re-link the
tables from scratch.
-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446
On Sat, 20 Dec 2003 13:53:56 -0800, "Bek"
<anonymous@.discussions.microsoft.com> wrote:

quote:

---

>I have altered SQL tables and then relinked them to a
>Access 2002 front-end and receive the following
>message "The Microsoft Jet Database engine stopped the
>process because you and another user are attempting to
>change the same data at the same time"
>When the SQL table is altered there are no users currently
>connected to any of the SQL or Access Databases.
>The SQL table being altered is related to many other SQL
>tables.
>The alter statements are adding new fields to the table.
>Please help!

---