by K. Swa » Fri, 02 Mar 2001 13:49:29
I have converted my Access db from 97 to Access2000 version.
Now, after I started the program, the error message said 'unrecognizable
format' at:
set db = opendatabase("c:\temp\test.mdb")
What should I do when converting data base from 97 to 2000. The only thing I
did was, ticked the check box in 'Reference' for 'MS Access 9.0 object
library'. What else should I do?
Thanks
KS
by Ian William » Fri, 02 Mar 2001 18:40:14
You should also have changed the reference for DAO 3.51 to DAO 3.6
regards
Ian
** invalid email address, change dk to denmark
homepage http://www.kingsoft-denmark.com/
Tips & Tricks page http://tips.kingsoft-denmark.com/
Quote:> Hi,
> I have converted my Access db from 97 to Access2000 version.
> Now, after I started the program, the error message said 'unrecognizable
> format' at:
> set db = opendatabase("c:\temp\test.mdb")
> What should I do when converting data base from 97 to 2000. The only thing
I
> did was, ticked the check box in 'Reference' for 'MS Access 9.0 object
> library'. What else should I do?
> Thanks
> KS
by K. Swa » Fri, 02 Mar 2001 18:48:51
I just found the MS article about this problem and followed the instruction
such as installing Visual Studio sp4 and changed the reference and also in
all my code from (rs as recordset) to (rs as DAO.recordset). But I still get
the same error message. How come?
Ken
by Ian William » Fri, 02 Mar 2001 19:44:01
There's one possibility, once, and only once, I found the change didn't
stick.
What I had to do there was uncheck the reference to DAO 3.51, click OK, save
the project, then add the reference to DAO 3.6.
regards
Ian
** invalid email address, change dk to denmark
homepage http://www.kingsoft-denmark.com/
Tips & Tricks page http://tips.kingsoft-denmark.com/
Quote:> Thanks, Ian.
> I just found the MS article about this problem and followed the
instruction
> such as installing Visual Studio sp4 and changed the reference and also in
> all my code from (rs as recordset) to (rs as DAO.recordset). But I still
get
> the same error message. How come?
> Ken
by K. Swa » Fri, 02 Mar 2001 21:38:06
I finally found out that the same error was due to other mistakes. I was
opening a table that doesn't exist! Thanks for your help.
Ken
1. Problem with converting Access query to SQL server 2000
please help me convert this inot proper SQL server format.
Here is the Access 2000 query in SQL view:
SELECT Dates4.[Time Start], Units.[UTILITY CODE], Units.
[UNIT CODE], Max(([Net Depend Capacity]-nz([Net Avail
Capacity],0))*[Percent Owned]) AS MaxLostCapacity
FROM Dates4, [Performance Report] INNER JOIN ([Event
Report] INNER JOIN Units ON ([Event Report].[Unit Code] =
Units.[UNIT CODE]) AND ([Event Report].[Util Code] = Units.
[UTILITY CODE])) ON ([Performance Report].Year = [Event
Report].Year) AND ([Performance Report].[Unit Code] =
[Event Report].[Unit Code]) AND ([Performance Report].
[Util Code] = [Event Report].[Util Code])
WHERE (((Units.[Percent Owned])>0) AND (([Event Report].
[Event type]) In ('SF','U1','U2','U3')) AND (([Event
Report].[Start of Event])<=[Time Start]) AND (([Event
Report].[End of Event])>=[Time Start]) AND (([Start of
Event]+[Duration])>=[Time Start]) AND ((Month([Time
Start]))=[Report Period]))
GROUP BY Dates4.[Time Start], Units.[UTILITY CODE], Units.
[UNIT CODE];
Here are the errors:
Server: Msg 195, Level 15, State 10, Line 1
'nz' is not a recognized function name.
Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near 'Units'.
Please help me finalize the conversion of the query.
Thank you
Nir
3. Problems with the XML file convert to SQL Server 2000
4. formatting table lookup window
5. SQL Server 2000 convert binary problem
7. Problem converting sql 6.5 tp sql 2000
8. Best way to select 1st occurance of a "type of data"
9. Converting VB functions in Access 2000 to SQL Server 2000
10. Converting from SQL 7 on NT box to SQL 2000 on Windows 2000 new box
11. Converting Access 2000 DB to SQL Server 2000
12. Converting program from SQL 2000 to Access 2000