Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 11-11-2009
Member
 
Join Date: May 2009
Posts: 759
Unable to pass inputs to Ms Access

Hi. I have created a demo website as my project. Well I made the dynamic pages in ASP and the back-end I am using is MS Access. The problem is when I feed the inputs to my form on clicking the button the data is not able to store in my Database. Also after it is been clicked it redirects to a blank page. I am totally confused and have no idea what has to be done. Please provide me with the solution. Thank you.
Reply With Quote
  #2  
Old 11-11-2009
Member
 
Join Date: Apr 2008
Posts: 1,948
Re: Unable to pass inputs to Ms Access

Hello. As you have created a website and that to a dynamic page in ASP i will suggest you to check the coding for your asp page. There can be an issue of misspelling the parameters for your page. The local connectivity for the asp to MS access is "Microsoft.Jet.OLEDB.4.0" followed by the path of your with its extension as .mdb. Check out the connection string as well. Small parameters often lead to errors.
Reply With Quote
  #3  
Old 11-11-2009
Member
 
Join Date: May 2008
Posts: 2,008
Re: Unable to pass inputs to Ms Access

The problem could be with the coding of your program. Such errors mostly occurs due to misspelling of the parameters or missing some the parameters. Check out your static page of your form. You might not have mentioned the parameters for "ON click" command for your button. Target the press event to the desired page you want to redirect if you have not done that. It would not then redirect you to a blank page.
Reply With Quote
  #4  
Old 11-11-2009
Member
 
Join Date: Apr 2008
Posts: 2,001
Re: Unable to pass inputs to Ms Access

You can have the solution for the very problem. You might not be able to transfer the data due to improper coding. First you need to create an object. for this the code is "Set conn = server.createobject("adodb.connection") ". After this you have to connect your Db with the pageas " Conn.connectionstring = "Microsoft.Jet.OLEDB.4.0; c:\dir\database.mdb". then you need to open by "Conn.open" then set the values in the form of your Db coloum by "Set rs=Server.CreateObject("ADODB.recordset")". After this to open your recordset you need to mention it as "rs.open "Select col1,col2 from table_name", conn" . This might help you out.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Unable to pass inputs to Ms Access"
Thread Thread Starter Forum Replies Last Post
HDMI Pass Through unable to work. Nityaa Monitor & Video Cards 8 28-12-2011 02:01 AM
Dragon Age II PC unable to get pass loading screen Techie Boy Video Games 5 10-03-2011 10:23 AM
Network Diagram - Configure to show Forward Pass/Backward Pass m3lyssa Microsoft Project 9 30-08-2010 04:57 PM
Pass query in design mode in Access 2007 Chandranath Windows Software 5 08-01-2010 06:45 AM
cannot verify access to pass ...wwwroot\wss... error chupparustam Microsoft Project 2 26-07-2008 02:28 AM


All times are GMT +5.5. The time now is 11:54 PM.