Saving design changes to upgraded databases

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database that I upgraded from Access 97 to 2000, then to 2003. It
has a startup form (if that is instrumental to the solution of the problem
about to be discussed). It also has modules and tables. Whenever I hit the
design button for a form (perhaps any) object, I get the message :- - - -"You
do not have exclusive access to the dtabase at this time. If you proceed to
make changes, you may notbe able to save them later". - - - - After clicking
'OK' to continue to design view, if I hit the save button, I get the
following corresponding message: - - - - "DbName cant save design changes or
save to a new database object because another user has the file open. To save
your design changes or to save to a new object, you must have exclusive
access to the file". - - - - I have tried multiple times, each time ensuring
that it is open exclusively. Would anyone here know how to correct this
problem? Where am I going wrong. Thanks for you usual kind responses.
 
Try creating a new empty database and then export everything in your problem
database to the new database. Then run the new database and see if it
works.
 
I now think I have better information regarding when this problem occurs. By
the way, I tried your method (of creating a blank database and either
importing from within that database, or exporting from the other database)
and I still end up with the same result; cant save editting. I might have
declined to mention in the opening thread that there was a library (.mda)
attached to this database. As long as I do not have the library attached, I
can make any number of updates. However, as soon as I attach the library
(which is where the bulk of the functionalities are programmed, and which is
the functionality source for many othersimilar databases that are soon to be
upgraded accordingly), close and reopen, that is when I lose the ability to
save changes - with the messages mentioned in the opening thread. And, of
course, once that happens, I cant break the attachment again so that it would
allow me to change the host database. Both the library and host databases are
in Access 2003 database format. Has anyone here experienced these problems?
What is the work-around? Thanks
 
I eventually fixed the problem by putting a few Stop commands in the library,
perusing the various functions called and making a few changes. Frankly, I
dont even know what exactly I changed that fixed it - but it works. My next
question, however, is ; is it by design that code update in a library module
cannot be saved? IOW, say my host database makes a function call to a library
function named 'CreateNewContact'. If I were to right-click and go to the
definition of that function, does Microsoft prevent saving updates to the
code? That is my experience with Access 2003. Not so with Access 97. Thanks
 
Back
Top