Make a table populate from a database view

[mcinnes01]

Hi,

I am relaerning access again and haven't used in for a few years, I'm a currently trying to build a payroll queries database to log and manage queries.

I have a database view of our staff database, but cannot just make table links as I don't have access. I have set the datbase view up as an external database link but I am now trying to set my relationships up.

I have 5 tables

Employees
Users
Passwords
Queries
Closed Queries

and the database view called ALL_STAFF_SAR

I found I can't make changes to the data properties of the database view, so I created the employees table.

Essentially what I am trying to do is get the employees table to populate off the database view. How can I do this?

Cheers,

Andy

 

[MSAccessRookie]

Hi,

I am relaerning access again and haven't used in for a few years, I'm a currently trying to build a payroll queries database to log and manage queries.

I have a database view of our staff database, but cannot just make table links as I don't have access. I have set the datbase view up as an external database link but I am now trying to set my relationships up.

I have 5 tables

Employees
Users
Passwords
Queries
Closed Queries

and the database view called ALL_STAFF_SAR

I found I can't make changes to the data properties of the database view, so I created the employees table.

Essentially what I am trying to do is get the employees table to populate off the database view. How can I do this?

Cheers,

Andy

Maybe I am missing something obvious, but this sounds like a job for the Update Query Wizard.

Since you have read access to the Database View, then perhaps you can create an Update Query that uses the View as a source and the Table as the output target. The Update Query Wizard was designed to assist in situations like this.

 

[mcinnes01]

Ok, I think I have done this now....

I first tried an append query but I got some validation error.

So I wrote a delete query and then used a macro to run the delete query then the append query, it seems to work.

But, would it be better done with just an update query, and sorry for the daft question how do I use the update query to do what you described. I haven't made an access database for about 3 years and I am somewhat rusty.

cheers

andy