Accessing a 'View' to update tables in access 1

[daveinchicago]

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]

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]

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]

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]

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!

 

[dhookom]

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