"No valid source could be found for product DAO"

  • Thread starter Thread starter Joseph Ellis
  • Start date Start date
J

Joseph Ellis

Hello all,

I've run into a strange problem. I've recently installed a new hard
drive in my computer. In doing so, I copied an image of my old drive
to the new drive. Then, due to driver problems, I had to reinstall
Windows XP on the new drive, over the newly copied image of the old
drive. This has not caused any problems until now.

A few months ago I made a form for my church database which includes a
search function. When a search is called for, a little "search
results" form pops up listing all matches. The user then clicks the
desired record, the popup form closes, and the main form synchronizes
to the desired record.

Here is the pertinent code:

If
Application.CurrentProject.AllForms("frmSearchResults").IsLoaded Then
'The user clicked on a desired record.
'Go to the selected record
Dim rst As DAO.Recordset
With Forms!frmHouseholds
Set rst = .RecordsetClone
rst.FindFirst "[hhID] = " & Forms!frmsearchresults.hhID

'synchronize frmHouseholds's bookmark with rst's
'in order to "jump" to the matched record.
If Not rst.NoMatch Then
.Bookmark = rst.Bookmark
End If

'Clear the recordset
Set rst = Nothing
End With


'Close the Search Results form
DoCmd.Close acForm, "frmSearchResults", acSaveNo
Else
'The user clicked "Cancel" and the form has been closed.
Me.tboSearchText.SetFocus
Exit Sub
End If

Ever since I did the hard drive swap, I get the following error
dialogs when I click the desired record on the popup form:

Preparing to install...
then
Please wait while Windows configures DAO
then
Error 1706.No valid source could be found for product DAO. The
Windows Installer cannot continue.

I click "OK", then the whole thing repeats 2 or 3 more times. After
that, I click "OK" the last time, and the search procedure completes
as usual, and will continue to work properly until I quit and restart
Access. So the search function still works, but I have to go through
this rigamarole every time I start up Access.

I've tried putting my Windows and Access cd's in in the hopes that the
program would find whatever it is it's looking for with no success.

Is there a way to fix this annoyance?

I'm using Access XP on Windows XP, and amongst my selected references
is Microsoft DAO 3.6 Object Library.

Thanks for any help.

Joseph
 
I have had analogous problems with WinWord on one persona on a laptop.
The cure was to reinstall Office in that persona. I would reinstall
Access. The problem seems to be that the appropriate dlls are present
and in the right place, but some of the Registry entries that tell the
application that they are present are either confused or absent. The
application thus tries to install them and fails, but (because they
are actually installed) the References work anyway.

Hello all,

I've run into a strange problem. I've recently installed a new hard
drive in my computer. In doing so, I copied an image of my old drive
to the new drive. Then, due to driver problems, I had to reinstall
Windows XP on the new drive, over the newly copied image of the old
drive. This has not caused any problems until now.

A few months ago I made a form for my church database which includes a
search function. When a search is called for, a little "search
results" form pops up listing all matches. The user then clicks the
desired record, the popup form closes, and the main form synchronizes
to the desired record.

Here is the pertinent code:

If
Application.CurrentProject.AllForms("frmSearchResults").IsLoaded Then
'The user clicked on a desired record.
'Go to the selected record
Dim rst As DAO.Recordset
With Forms!frmHouseholds
Set rst = .RecordsetClone
rst.FindFirst "[hhID] = " & Forms!frmsearchresults.hhID

'synchronize frmHouseholds's bookmark with rst's
'in order to "jump" to the matched record.
If Not rst.NoMatch Then
.Bookmark = rst.Bookmark
End If

'Clear the recordset
Set rst = Nothing
End With


'Close the Search Results form
DoCmd.Close acForm, "frmSearchResults", acSaveNo
Else
'The user clicked "Cancel" and the form has been closed.
Me.tboSearchText.SetFocus
Exit Sub
End If

Ever since I did the hard drive swap, I get the following error
dialogs when I click the desired record on the popup form:

Preparing to install...
then
Please wait while Windows configures DAO
then
Error 1706.No valid source could be found for product DAO. The
Windows Installer cannot continue.

I click "OK", then the whole thing repeats 2 or 3 more times. After
that, I click "OK" the last time, and the search procedure completes
as usual, and will continue to work properly until I quit and restart
Access. So the search function still works, but I have to go through
this rigamarole every time I start up Access.

I've tried putting my Windows and Access cd's in in the hopes that the
program would find whatever it is it's looking for with no success.

Is there a way to fix this annoyance?

I'm using Access XP on Windows XP, and amongst my selected references
is Microsoft DAO 3.6 Object Library.

Thanks for any help.

Joseph
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
Back
Top