2. ASPRunnerPro General questions
  3. unable to add new records
This topic is locked

unable to add new records

 		1/23/2005 12:30:06 AM
ASPRunnerPro General questions
T
 Toad author

I have used ASPRunnner successfully for some time with sql2000. I have tried to set up a small site using access and am unable to "add" items to the database.
Oddly, there are no error messages and tables within the browser appear to have been updated, however when I go back to the database in access there are no new records.
Any ideas?

Thanks.
Sergey Kornilov admin 1/24/2005

Hi,
if you use Server.MapPath option ASPRunnerPro creates a copy of your original database in the output folder. ASP pages always work with the copy of your database which means you won't see new records looking into the original file.
You can avoid creating a copy of your database by unchecking Use Server.MapPath option.
T
 		Toad author 1/25/2005

The problem with using a copy of the database is that everytime I rebuild ASP pages the copy is overwritten with the original, which of course is empty.
I unselected "use server.MapPath" and unfortunately the page cannot be displayed.
Error Type:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xda4 Thread 0x9b8 DBC 0x1111fdc Jet'.

/ASPRunner/Employees_list.asp, line 372
Sergey Kornilov admin 1/26/2005

Please post your connection string here. Connection string can be found in include/Employees_dbconnection.asp file.