
Upsizing from Access 97 to SQL Server? -> forget it!
Quote:
> >Ok, but this does not answer the original question on the upsizing tool
> >that does not work in Access 97. I have the same experience myself and
do
> >not find anything about it. Could somebody tell me if there is any
> >equivalent?
> Are you saying that you've tried the current upsizing tool with Access
> 8 and it doesn't work?
Exactly, I used it earlier on in a previous access 7 and that worked
without any problem. But now I installed the Access Development Tools (ADT)
and the add-ins do not appear under "tools ... add-ins". I tried several
things:
- placing the add-ins in the correct position (ADT had put them in the
correct directory under msoffice\access but apparently the add-ins reside
now in the directory msoffice\office. Anyway that did not help. You can see
them in the add-in manager and try to install them from there, but that
does not work (not that access tells you this!).
- second move: convert the .mda add-ins that are delivered with ADT. now
there you're in for a surprise: in the phase of converting database to
currently installed version of
VBA the next warning appears: requested type
library or wizard is not a VBA project. (for which the help topic does not
exist). After this: nothing! I would say that the macro's that are used in
the upsizing tool cannot be upgraded by access 8. You cannot even open the
mda files in access 8 because it tries to convert it too then.
I will now look at the tools in Access 7, but I do not think that I can see
from there what could cause the upgrading error because I do not know where
it goes wrong.
A search on the Microsoft web site did not help me any further.
I would appreciated it from microsoft if they delivered the upgraded tool
with office 97 together in my universal subscription for which my boss pays
a lot of money!
Sebastien Deleersnyder
PS: I will cross-post this to some other news groups so I would appreciate
it if somebody with the same problem or , even better, solution could also
post it to me directly. If I find the solution I will post it in all the
relevant groups.