[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 338
  • Last Modified:

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?
0
bizzie247
Asked:
bizzie247
  • 2
  • 2
  • 2
  • +3
2 Solutions
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Delete and re-link the table or refresh the existing link by using the linked table manager.  Just check the box for "Always prompt for location" so it goes back out and gets it.

Jim.
0
 
hnasrCommented:
Try this:
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.
0
 
bizzie247Author Commented:
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.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
Christopher KileCommented:
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?
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
You didn't mention version, but look for tools/database utilities, then linked table manager.

Jim.
0
 
hnasrCommented:
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?
0
 
burrcmCommented:
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
0
 
clarkscottCommented:
Or simply drop the link (delete it from Access) and relink to SQL.   Same thing.
Scott C
0
 
bizzie247Author Commented:
Linked Manager worked like a charm after closing and reopening Access. Thanks!
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

  • 2
  • 2
  • 2
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now