How to refresh a view using code?

H

Harry H

Hi all, I am using ADP as a front end to SQL Server2000. I am using ADO to
create view1 with a view of 4 columns. Then I drop view1. Then I create
view1 again with only 2 columns. If I exist out of the form and look at
view1 at this time, it will have header for 4 columns (just like the original
view1 before Dropped) and 2 columns with data (just like the 2nd Create).
The view1 was never refreshed to reflect the latest created view. How can I
Refresh view1 using code to reflect the latest changes?

Thanks in advance for all your help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting from ADP to MDB/ODBC linked tables 8
Add a line to repeating table if formhas several views 2
Scripting of dependent objectsq 2
Retrieving the dropdown text via code 2
how can I recover a corrupted xsn file due to invalid view? 2
Manifest.xsf Error and changing a form view's name 1
Keep focus on error fields in browser-compatible form 0
Enable autofilter in protected worksheets in Excel 2000 6

Top