UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> converting from Access 2003 to 2007    
 
   
VJH
post 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
Go to the top of the page
 
+
HiTechCoach
post 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.
Go to the top of the page
 
+
HiTechCoach
post Jun 5 2008, 11:33 PM
Post #3

UtterAccess VIP
Posts: 18,396
From: Oklahoma City, Oklahoma



These may also be helpful:

Converting to Access 2007

and

http://www.access-freak.com/
Go to the top of the page
 
+
KimbleG
post 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 the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Go to Top  ·  Lo-Fi Version Time is now: 23rd May 2013 - 03:43 AM