Database isn't updating

[Mark Constant]

I created a search engine using the Database Result Wizard. Now the
website had already been built when I created the search engine. I
updated the database the search is connected to and noticed something.
When I try to do a search it doesn't see the updates. So I remembered
that when I did the wizard that I selected phonelist_connection under
what database connection I wanted to use. I thought it was connected
to the database I wanted because I could select any field I wanted to
search. Is there a way to find out which database phonelist_connection
is attached too? Also how to update the connection so I can do a
search on the updates.

 

[Guest]

Open the Web site where the failure is occurring, then
choose Tools, Site Settings, Database. Then, click the
connection name and then the Modify button.

You might also want to download your database and browse
it directly in Access, just to verify that the update
process is working.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

 

[Mark Constant]

Thank you for the reply. I checked and it is connected to the right
database. I browsed the database and the changes were updated in it.
So is there another reason why the updates wouldn't show up in the
search?

 

[Jim Buyens]

Please rerun the DRW and on page 2, click Custom query and Edit. Then,
copy the contents of the SQL Statement box and post them to this
thread.

It would also help if you would post:

o The contents of a database record that you expect to be found
and *is* found.

o The contents of a record that you expect to be found and isn't.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

 

[Mark Constant]

When I do the custom query all I get for a SQL statement is this
SELECT * FROM "All Numbers"

An example of a record I found that I was searching for was this. I
changed the names of course because I don't want them posted on here.
All I need to do is type Example% or even %Tim% and I will get this
record like I want.

Name Ext Location Title Type
Example, Tim 1000 x250 Corporate Account Manager

Now if I add or change an entry it won't find the added user. Like it
does in the example before. I type in Doe% or %John% like I did with
the other user and it doesn't show up and the format is the same. I am
copying and pasting and the only thing that I am changing in this
example is the name not the format .

Name Ext Location Title Type
Doe, John 1000 x251 Admin Casco Days Coor

Maybe it would help if I explain this in a little bit more detail. I
have an Excel spreadsheet that had a list of names. It is linked to a
Access Database. Whenever a new employee is added I add him to the
Excel spreadsheet. Then I go into Access and update the linked table.
If you want to view by deparment it is okay because it is actually
linked to the Excel Spreadsheet so I do see the changes. Now the
search engine is connected to the Access Database instead. So I run a
search on a new user or any changes I have made in the database and
they don't show the updated changes. But if I go into the Access
Database the changes really are there. It is hard to explain sorry and
thanks for any tips you can give.`

 

[Jim Buyens]

Responses interspersed...

When I do the custom query all I get for a SQL statement is this
SELECT * FROM "All Numbers"

Are you sure it isn't:

SELECT * FROM [All Numbers]

And if you're selecting by some criteria, there should
be a WHERE clause, such as

SELECT * FROM [All Numbers] WHERE name = '::Name::'

So are you sure about this SQL statement?

An example of a record I found that I was searching for was this. I
changed the names of course because I don't want them posted on here.
All I need to do is type Example% or even %Tim% and I will get this
record like I want.

Name Ext Location Title Type
Example, Tim 1000 x250 Corporate Account Manager

Now if I add or change an entry it won't find the added user. Like it
does in the example before. I type in Doe% or %John% like I did with
the other user and it doesn't show up and the format is the same. I am
copying and pasting and the only thing that I am changing in this
example is the name not the format .

Name Ext Location Title Type
Doe, John 1000 x251 Admin Casco Days Coor

Maybe it would help if I explain this in a little bit more detail. I
have an Excel spreadsheet that had a list of names. It is linked to a
Access Database. Whenever a new employee is added I add him to the
Excel spreadsheet. Then I go into Access and update the linked table.

If the Access and Excel tables are linked, why do you have to update
both by hand?

If you want to view by deparment it is okay because it is actually
linked to the Excel Spreadsheet so I do see the changes.

Are you viewing this in Excel or on a Web page?

Now the search engine is connected to the Access Database instead.
So I run a search on a new user or any changes I have made in the
database and they don't show the updated changes.

Is it possible that Excel still has the database locked, and that the
all queries therefore come up Not Found?

But if I go into the Access Database the changes really are there.
It is hard to explain sorry and thanks for any tips you can give.`

Perhaps by this time, the database is no longer locked.

If you're double-clicking the database in FrontPage, you should know
that FrontPage is downloading a copy (which requries only Read access)
and that Access then opens the copy. The Web server, however, opens the
database for update, and that will fail if Excel still has control.

In general, it's not a good idea to use the same physical database in
desktop applications and on the Web. Either do the whole application
in one or the other (desktop or Web) or use a database like SQL Server
that's designed for this sort of thing.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------