Getting an .mdb (access) File

Results 1 to 2 of 2

Thread: Getting an .mdb (access) File

  1. #1
    Join Date
    Dec 1969

    Default Getting an .mdb (access) File

    Can I get an MDB file from a Recordset? How?

  2. #2
    Join Date
    Dec 1969

    Default RE: Getting an .mdb (access) File

    There are a few ways to do this. Which one you use depends on whether you have Office installed on the Web server or not.<BR><BR>If you do, then you can use VBScript to create a new MDB file and write table structures to it, then write your data. There is probably an article on for that.<BR><BR>If you don&#039;t have Office on the server, create a template (empty) MDB file using Access on a client. Then upload that to a read/write directory on the server. Finally use ADO code to write data to the empty shell.<BR><BR>I did the latter on my site, but before I wrote the data to the file, I made a copy of the MDB template using File System Objects and wrote to the copy. This prevented me from screwing up my template.

Posting Permissions

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