Database Results Error

  • Thread starter Thread starter susan
  • Start date Start date
S

susan

We have a website with ASP page connected to a MDB
database. Previously, this worked fine. Users were able to
read and modify information. Suddenly, they can't modify
information anymore. When they try to submit changes they
get "Database Results Error." The only thing that we know
has change for certain is that we applied Office SP3 to
the server. Could that be causing the problem? If not,
whatelse could it be?
 
I am having serious problems since SP3 inc loss of db updates and the
complete loss of DISTINCT within custom sql statements within DRW's

Please let me know/post here if you find a solution.

M
 
I too, am having problems with FP database access. We
have multiple servers, each with multiple webs, using
access,mssql,and sybase databases. It seems that the
queries are now case sensitive with respect to the where
clause, and the variable in the where clause has to be
explicitly declared in the select statement...i.e.
select * from table1 where id = '::id::' used to work...
Now the query must be written as follows: select id, *
from table1 where id = '::id::' and it cannot contain "Id
= '::id::'", the case makes a difference. What made this
change???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top