Smart questions
Smart answers
Smart people
Join Tek-Tips Forums
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • 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!

Join Tek-Tips
*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 accessHelpful Member! 

daveinchicago (IS/IT--Management) (OP)
14 Feb 12 17:39
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.

thanks!!!
dhookom (Programmer)
14 Feb 12 18:13
This all depends on the relationships/joins and if they are based on primary/unique indexes.

Duane
Hook'D on Access
MS Access MVP

daveinchicago (IS/IT--Management) (OP)
15 Feb 12 9:57
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.
dhookom (Programmer)
15 Feb 12 10:24
You seemed to have ignored my reply regarding "primary/unique indexes"? Your reply adds very little value to your original question.

Duane
Hook'D on Access
MS Access MVP

daveinchicago (IS/IT--Management) (OP)
15 Feb 12 10:49
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.

thanks!
Helpful Member!  dhookom (Programmer)
15 Feb 12 11:25
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.

Duane
Hook'D on Access
MS Access MVP

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!

Back To Forum

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