How to write a file into Access Database

Ask a Question related to ASP Database, Design and Development.

  1. #1

    Default How to write a file into Access Database

    I want to use ASP to write file into Access Database,the file is limits
    300K,how to realize it?
    Any idea will be appreciated!


    Edward King Guest

  2. Similar Questions and Discussions

    1. upload a jpg file to an access database...???
      I think I heard that you can't have a jpg in an access database, however you could point to where the jpg was from within the database. What I need...
    2. File Write Access Denied with ASP .NET on Domain Controler
      Hi All, I have a web page that tries to write in a xml file but I have an Access Denied error on the xml file. The page is working properly on...
    3. Help needed with ASP form browse for file, create link to file and insert in access database
      I have a form where a user enters their name, date etc. i also want them to be able to click on a browse button and select a file which will then...
    4. write to database without giving write permission to IIS
      Hi there, I have some ASP code that writes to access database. For security reason I do not want IUSER to give write permission to database...
    5. Write Access to Access DataBase
      I'm trying to update a Access Database from information gained from a ASPX page. The database will not update. I'm sure it is in some security...
  3. #2

    Default Re: How to write a file into Access Database

    > I want to use ASP to write file into Access Database,the file is limits
    > 300K,how to realize it?
    Access database files are limited to 2GB *total*. Not sure how many 300kb
    files you intend to keep there, but you'll hit the upper bound pretty quick
    (6000 files, not counting OLE overhead, and that's if you don't put
    *anything* else in the database at all).

    Any reason why you want to store a file inside a file? Wouldn't it make
    more sense to store a file in the file system, where it goes, and *data*
    about the file (such as its name, location, etc.) in a *data*base?

    --
    Aaron Bertrand
    SQL Server MVP
    [url]http://www.aspfaq.com/[/url]


    Aaron Bertrand [MVP] Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139