Pete
|
| Posted: 10/03/2005, 12:27 PM |
|
Hi,
Maybe someone can give me some ideas on this one. I have a very large Jet 4.0 mdb residing on an ISP hoster web server. One of the tables is a registration table. My client want to get the new registration record ever few days. I sure can download the entire mdb, but this takes several minutes on hi-speed internet connections.
Does anyone know how I can simple download the registration table by itself rather than the entire mdb.... ps I know I can put the resistry table in it's own mdb, but it is used for lookup purposes in the main mdb.
Comments would be appreciated.
|
|
|
 |
DonB
|
| Posted: 10/03/2005, 6:06 PM |
|
Create a page with a grid control. Do not put a Navigator on the Grid so
the data comes out as one giant page. Perhaps set the records per page to a
very large number. I can't recall if -1 or 0 would imply "no limit" on the
number of records.
Strip the HTML table from the html page, and insert commas where the table
cells used to be.
Bingo, you will have a CCS page that outputs a comma-separated list that
your local MDB can import.
You can further enhance this - alter the page content-type to be
application/Excel and your IE browser will open the page in excel inside
Internet Explorer.
--
DonB
http://www.gotodon.com/ccbth
"Pete" <Pete@forum.codecharge> wrote in message
news:2434186386b2af@news.codecharge.com...
> Hi,
> Maybe someone can give me some ideas on this one. I have a very large Jet
4.0
> mdb residing on an ISP hoster web server. One of the tables is a
registration
> table. My client want to get the new registration record ever few days.
I
> sure can download the entire mdb, but this takes several minutes on
hi-speed
> internet connections.
>
> Does anyone know how I can simple download the registration table by
itself
> rather than the entire mdb.... ps I know I can put the resistry table in
it's
> own mdb, but it is used for lookup purposes in the main mdb.
>
> Comments would be appreciated.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Victor
|
| Posted: 10/20/2005, 7:45 AM |
|
Hi, DonB
I found your recommendation to be very helpful to what I'm doing: exporting to excel. Thanks for that. It works great.
But I have one problem: the number of items displayed. When I set my page greater than about 7000 records, it will come out blank.
Do you know how to set that limit higher, say at 50000 records?
Victor
|
|
|
|
|
