Strange Access/SQL Error

[sticks]

I hope someone can help with this strange problem I've encountered:

I have an Access interface that is used to access a SQL database. The
interface uses some stored procedures to display information from the
DB. If I edit the underlying tables of the SQL DB using the ALTER
TABLE statement, I encounter a problem where the Access interface no
longer displays information.

For example, the Access interface has a search function that uses a
stored procedure to query the database and display summaries of
selected records. Users can click on the name of a summary to view a
complete record. After altering the DB's underlying table, the Access
interface no longer displays the record summaries. The spots for the
summaries are still there and you can click on them and view the
record's detail, but the record summary is not visible.

Has anyone else encountered this problem? Is there anyway to fix this?
Thanks

[david epsom dot com dot au]

Relink and Compact your Front End. The FE stores
meta data - data about the table structure - which
needs to be refreshed.

If you are doing this 'live', close Access and
restart. The ODBC connections store meta-data,
and Access caches connections.
(david)

"sticks" <ns****@aol.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...

I hope someone can help with this strange problem I've encountered:

I have an Access interface that is used to access a SQL database. The
interface uses some stored procedures to display information from the
DB. If I edit the underlying tables of the SQL DB using the ALTER
TABLE statement, I encounter a problem where the Access interface no
longer displays information.

For example, the Access interface has a search function that uses a
stored procedure to query the database and display summaries of
selected records. Users can click on the name of a summary to view a
complete record. After altering the DB's underlying table, the Access
interface no longer displays the record summaries. The spots for the
summaries are still there and you can click on them and view the
record's detail, but the record summary is not visible.

Has anyone else encountered this problem? Is there anyway to fix this?
Thanks