Refreshing SQL Server LINKS from Access 2003

M

Michael Miller

I have a situation where I added indexes to a table in my sql svr db back end
and went into the table design from Access (where they do not allow you to
edit the back end tables), and noticed that the indexes did not show in the
Access table design window.

Do I have to delete my link and re-link back to that table?

I also went into the odbc connection, went through the wizard, Finish-ed,
and tested the connection, but the indexes still do not show thru Access.
The wizard 'had no changes', so nothing happened.

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Table Security in Access 2013 1
Linked Tables - indexes 4
Access 2003 and SQL 4
Why won't Access assign a Primary Key ID to my linked SQL Table? 2
Linked servers 5
Migration to SQL Server 3
replacing a link to a SQL Server table with VBA 0
Linking Tables from SQL Server 1

Top