Results 1 to 2 of 2
  1. #1
    ianhaney28 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2012
    Posts
    2

    newbie needs help

    Hi



    I am designing a property website and am have designed a database in access 2010 and saved it as a mdb format and am trying to connect to it and display the data

    I am using asp to connect to it but is not working

    The coding is below

    Code:
    <html>	<head>
    	<title>Retrieve data from database </title>
    	</head>
    	<body>
    	
    	<%
    	' Database connection - remember to specify the path to your database'
    
    
    	Set Conn = Server.CreateObject("ADODB.Connection")
    	DSN = "DRIVER = {Microsoft Access Driver (*. mdb)}; "
    	DSN = DSN & "DBQ=" & Server.MapPath ("/cgi-bin/listofproperties.mdb")
    
    
    	Conn.Open DSN
    	
    	' Close the database connection
    	Conn.Close
    	Set Conn = Nothing
    	%>
    	</body>
    	</html>
    could really need the help

    Thank you in advance

    Ian

  2. #2
    SoftwareMatters is offline Access VBA Developers
    Windows XP Access 2003
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    274
    When you say it's not working what do you mean i.e. what should it be doing?
    Is there an error?

    Looking at the code you provided you open a recordset but don't do anything with it - is there more code?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Newbie needs help
    By Daryl2106 in forum Access
    Replies: 8
    Last Post: 01-24-2012, 09:12 PM
  2. Help - newbie
    By Sorbz62 in forum Database Design
    Replies: 13
    Last Post: 09-29-2011, 01:30 AM
  3. newbie needs help
    By hollyh in forum Queries
    Replies: 1
    Last Post: 08-23-2011, 03:39 PM
  4. can you help a newbie out
    By jayjayuk in forum Access
    Replies: 1
    Last Post: 10-10-2010, 07:42 PM
  5. Help a newbie
    By g8rnc in forum Access
    Replies: 1
    Last Post: 06-09-2010, 12:58 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums