How to update the table? (1 Viewer)

[polina]

Hi

I am not experienced in database technologies, so please help me.

I have an access table that is just a copy of the sql table resided on the SQL Server.

Once in a while, I would have to update that Access with changes made to SQL table.

What should I do?

Is it better to copy the whole SQL talbe again, or...

How would I spot the changes in the SQL table?

Please advise me on this.

Thanks

 

[Cosmos75]

Couls you have the SQL that does the equivalent of a Make-Table query in Access?

Does the Access Table have to be a exact copy of the SQL table?

 

[polina]

No, the Access Table only needs to have a few tables from SQL table

What is make-table query?

 

[Cosmos75]

NO!, not SQL!

In Access 2000, you can have a query make a table based on the results of the query. Hence the name Make-table query.


I am not good with SQL (even worse if it's not in Access).

Try doing a search in Access help files on Action Query and choose What is an action query and when would you use one?

It'll provide explanations of Delete query, Update query, Append query and Make-table query. Maybe that'll help you out somewhat.

Insofar as how to write a SQL statement from your SQL table on the SQL server and an easy way to add to your existing Access table, that's out of my league!


SORRY!