Access database problem

Results 1 to 2 of 2

Thread: Access database problem

  1. #1
    Nanette Guest

    Default Access database problem

    I am pulling records from an access database, and for some odd reason the hyperlink field is not displaying! I&#039m not quite sure why. Is there a great secret to displaying a hyperlink?<BR> <BR>Also, for the 6 records involved it seems to be taking an enormous amount if time to display the ASP page. Could it be PWS that&#039s slow, or can you share some access secrets, too?

  2. #2
    Join Date
    Dec 1969

    Default RE: Access database problem

    what kind of PC do you have? you need to have at least 300 MGHZ with 64 RAM of memory to have a good performance.. and hyperlink is displayed as <BR><BR>&#060;%<BR>Set Conn = Server.CreateObject("ADODB.Connection")<BR>cStr = "DRIVER={Microsoft Access Driver (*.mdb)};"<BR>cStr = cStr & "DBQ=" & Server.MapPath"tablename") & ";"<BR>Conn.Open(cStr)<BR><BR>sql = "select * from tablename"<BR>Set RS = Conn.Execute(sql)<BR>variable = RS("fieldname")<BR>%&#062;<BR>&#060;A href="&#060;%=variable%&#062;"&#062;Hyperlink&#060 ;/A&#062;

Posting Permissions

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