Editing Access table fields in asp

Results 1 to 2 of 2

Thread: Editing Access table fields in asp

  1. #1
    Join Date
    Dec 1969
    Posts
    1,388

    Default Editing Access table fields in asp

    I am creating a site that needs the ability to upload and display Access database tables. The first part is easy, I upload the database, allow the user to choose which table, and then which fields to display. The problem is: the main test group's database has 5000 records. I will have queries thrown against it, but first I need to display the first page (say...25 records of the 5000). I can't even fetch the recordset because it is too massive. I have the .Cachesize set to 100, but it still can't create the recordset, even after 5 minutes. (this is without displaying anything, just fetching the recordset and closing). I thought about opening up the table and adding my own field, say "MySpecialID(auto-number)" and then selecting records "WHERE MySpecialID < 26" but I can't figure out how to edit the table. Anyone have any ideas on how to speed this up? Please bare in mind that the user is allowed to sumbit any access database, and is not required to change anything before uploading.

  2. #2
    helper Guest

    Default What the hell are you trying to do!!!

    Why would you users be uploading access db&#039;s?<BR><BR>Apart from that. I have used a table with &#062;30,000 records, and not had problems. However, one way to reduce your recordset is to use the TOP keyword in your select statement:<BR><BR>Select top 25 * from [yourtable]<BR><BR>Hope this helps!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •