My Assistant
![]() ![]() |
|
|
Jun 5 2008, 11:00 PM
Post
#1
|
|
|
New Member Posts: 1 |
When I try to convert my Access 2002 database to Access 2007 I have problems compiling.
When I Debug the data base the VBA statement rst.nomatch is highlighted. I go to References. There is no Missing link mentioned. I am at a loss. Where go I go from here ? VJH |
|
|
|
Jun 5 2008, 11:25 PM
Post
#2
|
|
|
UtterAccess VIP Posts: 18,396 From: Oklahoma City, Oklahoma |
Welcome to Utter Access!
How did you convert your database to 2007? Do you have the DAO library reference checked? You may want to post all the code for the function/sub if this does not help. Edited by: HiTechCoach on Fri Jun 6 0:27:22 EDT 2008. |
|
|
|
Jun 5 2008, 11:33 PM
Post
#3
|
|
|
UtterAccess VIP Posts: 18,396 From: Oklahoma City, Oklahoma |
|
|
|
|
Jun 6 2008, 12:20 AM
Post
#4
|
|
|
UtterAccess Guru Posts: 652 From: Auckland, New Zealand |
VJH,
A quick way to fix your problem is to do a Replace on: Find What 'as Recordset' Replace with 'as DAO.Recordset' Do the same for Database,field, Index, TableDef That should do the trick. KG |
|
|
|
![]() ![]() |
|
Go to Top · Lo-Fi Version | Time is now: 23rd May 2013 - 03:43 AM |