cannot save References list in VB

[Rick Exner]

The subject line on this message makes it seem as if I
know what I'm doing in Access, but I only knew to check
for a References problem because of previous help from
this newsgroup. I think that if I could save an updated
list of references, I could fix my current problem, but I
always get a "Save action failed" message. I am trying to
remove a "MISSING" reference to the "Microsoft ActiveX
Data Objects Recordset 2.7 Library." I tried deleting and
re-linking, but I suspect the dll doesn't even exist on
that computer. I apparently "caused" the original problem
by exporting some queries, forms, and macros from an XP
machine to to an Access file on this computer, which I
think runs Win2000. I think both machines have the
updated Jet engines.

The symptom is that the database with the imported objects
doesn't recognize certain functions like Date(). Going
into the VB application and choosing Tools/References
reveals the missing 2.7 library. I can delete the file
from the list, and Access runs fine -- I just can't *save*
the references list with the deletion. So each time one
opens Access, one has to go through the deletion procedure
to get the database to run right. This is not considered
much of a solution by my associates.

Why can't I save the References list? Have I corrupted
the database by moving objects into it from another
machine (both of them running Access 2000)? How would I
check this? Oh, I did run a Compact and Repair Database
remotely on that machine, and it took forever. I guess
that could have caused the problem too. Any insight would
be much appreciated.

 

[david epsom dot com dot au]

always get a "Save action failed" message. I am trying to

1) The DB can't be read-only
2) You have to be the only person with the DB open
3) You must have opened with 'exclusive access'
(There is a drop down menu in the lower right corner
of the db file open dialog).
4) If there is still a problem, the DB is probably damaged

check this? Oh, I did run a Compact and Repair Database
remotely on that machine, and it took forever. I guess

It shouldn't. If the DB is somewhere on the network,
make a local copy first, compact and repair that, then
replace the network copy.

(david)

 

[Rick Exner]

Thank you for the ideas. They are the logical things to
check. We understand the necessity of opening with admin
privileges and as the sole user. And I can copy the
database to my computer and run it fine here, so I don't
think there is serious damage to the file. I just can't
seem to save the References list when working from the
other computer. Until I can do that, the database chokes
on certain functions.
-Rick Exner

 

[david epsom dot com dot au]

seem to save the References list when working from the

other computer. Until I can do that, the database chokes

If it runs OK without the ADO ref, can you remove
it, at your own machine, then copy the file back to the
remote location?

Also, I guess you should download the most recent
MDAC from MS, and apply it again to both machines.

(david)

 

[Rick Exner]

David, if you're still listening:
I did move the file to my computer, deleted the reference
to the ActiveX 2.7 library, and moved the database back to
the remote server.

Now they can open the forms, suggesting that the missing
dll is no longer preventing Access functions from
working. BUT, when they try to save a record or move to a
new record, they now get a message "Error accessing file.
Network connection may have been lost." This occurs on
all machines at that site using the database.

This symptom did not occur before. Of course, we couldn't
open the forms before either. So how is it related to the
problem? This is getting messy.

One other question; what is the MDAC to which you referred?

Thank you,
-Rick Exner

 

[david epsom dot com dot au]

open the forms before either. So how is it related to the

problem? This is getting messy.

It looks like Access is not correctly installed. Try these: they are
the most up to date files, and also easier than a full office upgrade
or re-install, but they only include the Data Access files.

One other question; what is the MDAC to which you referred?

http://msdn.microsoft.com/library/default.asp?url=/downloads/list/dataaccess.asp


and:
ACC2002: The Updated Version of Microsoft Jet 4.0 Is Available in the
Download Center
http://support.microsoft.com/default.aspx?scid=kb;EN-US;282010


Or, now it may just be something unrelated with the network
or user permissions ......

(david)