Acess 97 to 2000

[Bill M]

When i converted an old data base to 2000 it opens up the
debugger and says "compile error, can't find project or
library". I am new to this so any help would have to be
in basic easy terms. Thank you in advance.
Bill

 

[Julius D.]

From your VB editor's menu, click Tools->References. If
your old database is version 97, it probably uses DAO
which may not be enabled by default with 2000, so just
click the checkbox of the aproprite version (latest for
2000 i think is 3.6), click Ok to exit. Then try to run
your access database again.

 

[Guest]

When I clicked ok after I selected the DAO 3.6 I got a
message that said "name conflicts with module, project, or
object library"
Bill

 

[Guest]

I got it! One of the references that were checked said
missing module version 2.5/3.6. i unchecked it and now my
database works. Thank you very much for your help, I do
appreciate it as I never would have figured it out on my
own.
Bill

 

[david epsom dot com dot au]

missing module version 2.5/3.5. i unchecked it and

next: you may have to change code references like
table.field (example: rs.idxRecord)
to
table!field

('dot' replaced with 'bang')

And if you have used OpenQueryDef, that will have
to be changed to use QueryDefs instead.

(david)

 

[Helen]

Hi, I'm coming into this late, looking for a solution &
this might be it (if I understood it!) - my 97 database
won't save any records when converted to 2000 - but I
don't know how to get to VB editor to try the solution
suggested.

Note, I have written nothing in VB (don't understand it) -
is all done classically through queries.

Your help would be GREAT.

Thanks

 

[david epsom dot com dot au]

Open the database.
Type [ctrl][g]
Go to the Tools | References menu

If NONE of your forms have ANY VB, just untick
any references you can (starting at the bottom
of the list).

(david)

 

[zahra]

l.;p[']=,ol,jmp;

 

[zahra]

bghjjk