Activate a change made in a SQL table
Hello, we have a server running SQL 2005 and Access on the front (back) end. We added a field to a table in SQL. How do we now make it visable and usable in Access?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Where can I find the 'Linked Table Manager'? Also, following the suggestion of design view, what was added is not showing up on the Access side. Thanks for the suggestions thus far.
How are you accessing the SQL Server data from Access? Are you using linked tables or are you using a pass-through query against SQL Server, or are you accessing SQL Server through code?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Are you running access data project db.adp?
All tables and queries come from SQL server.
After modifying table in SQL, then trying to edit table from access, do you see the changes?
All tables and queries come from SQL server.
After modifying table in SQL, then trying to edit table from access, do you see the changes?
Right click the linked table; you should see linked table manager down the list. Refresh by ticking the relevant table then OK or whatever it says. And to contradict Mr Dettman (first comment - sorry), don't tick "Always prompt for new location", as this will cause you to show it where the location is rather than using the current location which is the desired result in this case.
Chris B
Chris B
Or simply drop the link (delete it from Access) and relink to SQL. Same thing.
Scott C
Scott C
ASKER
Linked Manager worked like a charm after closing and reopening Access. Thanks!
If Front end is an access project, then:
Right Click the table in access Project and select Design View, you will see the changes. Close the table Design view and you are done.