Help - Access to access

Results 1 to 3 of 3

Thread: Help - Access to access

  1. #1
    Preston Guest

    Default Help - Access to access

    I&#039ve created a test data file which I have been using to test my new found ASP skills. The data file was created using access. Whenever I open the file using VBScript on an ASP, my manipulations are applied and then the file becomes un-accessable for approximately one minute. I&#039m wondering if there is a &#039con.close&#039 function that I&#039m not yet aware of? (It&#039s not mentioned in any of my books)<BR> Thanks for any help you have.

  2. #2
    Join Date
    Dec 1969

    Default RE: Help - Access to access

    Yes, there is a con.close and you should use it. You should also use set con = nothing when you don&#039t need to maintain the connection. I&#039m not sure this will solve your problem - I think that (at least sometimes) ado keeps a connection live for a while in case it&#039s needed again. In any case, you should close and kill the connection as soon as it&#039s no longer needed.

  3. #3
    Preston Guest

    Default RE: Help - Access to access

    Thanks. Now at least I have direction. It&#039s frustrating when reference material is incomplete. You try the examples but they don&#039t work and you&#039re left pulling your hair out. Maybe that&#039s part of the learning. :)<BR>(the &#039con.close&#039 was just a guess since I saw the & command earlier in some examples)

Posting Permissions

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