Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.


Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Accessing a 'View' to update tables in access

Accessing a 'View' to update tables in access

I want to be able to create a 'button' that, when clicked, will pull data from a view created from SQL Tables and update fields in Access.  is this possible?  It will always be the same fields from the View updating the same fields in the tables.


RE: Accessing a 'View' to update tables in access

This all depends on the relationships/joins and if they are based on primary/unique indexes.

Hook'D on Access
MS Access MVP

RE: Accessing a 'View' to update tables in access

I want to run a stored procedure (already created) from another database server.  This SP creates a view that will then kick off another SP (already created) that refreshes data in my access DB.

RE: Accessing a 'View' to update tables in access

You seemed to have ignored my reply regarding "primary/unique indexes"? Your reply adds very little value to your original question.

Hook'D on Access
MS Access MVP

RE: Accessing a 'View' to update tables in access

I"m not sure I understand the question then.  

I have a database that has no relationships or joins to the access database I am in.  There is a stored procedure that I want to trigger to create a view from that database.  The view is created put on the server where the access database has active connections to it's tables.  Then I will trigger another SP to populate/refresh the tables that I am using in access from the view that was created.  There are no links or relationships between the two databases.  That's why we are creating a view from a database on demand, so to speak.

So my question is:  Can I trigger a SP from access to a database that has no connections. And then trigger another SP to use the view created from the first db to populate my access tables.


RE: Accessing a 'View' to update tables in access

Can we assume you are referring to views and stored procedures on MS SQL Server?

You can create a pass-through query in Access that will execute a stored procedure in a database server.

You can link to the created view and use it in an update query in Access. This query won't work if you haven't defined some primary/unique indexes.

Hook'D on Access
MS Access MVP

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close