Re: Different version Access

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Yes, you can use Start | Run to fire off the decompile line.
I prefer to open a Command prompt, and paste it in there.
I also keep a little text document on my desktop containing most of that
command so I don't have to type the whole thing every time.

Libraries are code-add-ins that provide additional functionality. You can
create your own COM object programmed in C or some other language if you
wish, and add it in. Nice idea, but since any one missing library prevents
any code from running, they are actually a royal pain to manage, and a good
way to break your database.

If your Access database has an extra library (beyond the 3 basic ones) and
you don't know what it's for:
1. Open a code window, and verify that it compiles (Debug | Compile.)
2. Go to Tools | References, write down the name of the spurious library,
and uncheck it.
3. Compile again (Step 1.)
If it compiles after the library is unchecked, you probably don't need it.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"accessuser via AccessMonster.com" <u28669@uwe> wrote in message
news:6ab874b0a3de2@xxxxxx
Your link helped me to get rid of that "Can't find project or library"
message yesterday; it was very helpful. Thank you so much!!!!

Let me recap your message to make sure I got it right. As for the
"decompile" process, is the command prompt the same as the "Start, Run"
and
copy the code you gave me? And when I change to work on a different
computer
at work, i notice there is always on reference missing, control 1.0
something
like that, so i have to Shift Open the file run the Module, and uncheck
the
missing reference. Do I have to go to all users desktop to make sure I
uncheck them so it wiill run correctly? Is there a way I can put a error
msg
box instead having the access showing my users with VBA code page.

By the way, what are those projects or libraries for?

Thank you so much! I couldn't have gone this far without all the helps I
received from this site.

Allen Browne wrote:
There is no software that can automatically handle the differences between
references on different computers.

There are many thousands of libraries. If one is not present, the software
cannot know how to simulate that library. It cannot even handle different
versions of the same library.

The solution, therefore is to limit the libraries you use. The Access and
VBA libraries are required. Access will automatically select the correct
Access library when you switch versions, so you don't need to worry about
that. You probably want the DAO 3.6 Library also, but it is also standard
across Access 2000, 2002, and 2003, so there is no problem with that
either.

If you want any others beyond those 3, it is your responsibility to ensure
that the correct version of the correct library is correctly registered on
each computer where you will use your software.

More info on libraries for each version of Access:
http://allenbrowne.com/ser-38.html

Aside from the library references, there are some other issues that arise
as
you change versions. An MDB contains 2 versions of your code:
- the compiled version (what executes);
- the text version (what you view and edit.)
The compiled binary is different with every version of Access. So, when
you
edit an MDB using different versions, Access is supposed to re-generate
the
binary for the current version from the text. That process is flawed, and
you tend to get weird errors that make no sense and can be inconsistent.
The
solution is to explicitly decompile the database whenever you switch to
developing on a different version.

To decompile, make a copy of the database, and enter something like this
at
the command prompt while Access is not running. It is all one line, and
include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

I have a database and experiencing some version reference problem. I
created
[quoted text clipped - 10 lines]
before,
so please help me to explain it in a simple language if possible.


.

Relevant Pages

  • Re: Different version Access
    ... I will have my first MDB in 2000 and then follow your steps ... Libraries are code-add-ins that provide additional functionality. ... way to break your database. ... If it compiles after the library is unchecked, ...
    (microsoft.public.access.modulesdaovba)
  • g95: undefined symbol
    ... I am building shared libraries to be loaded from within Python. ... All compiles well and runs well with the Intel compiler. ... I can't reasonably keep them merged though, for licensing reasons. ...
    (comp.lang.fortran)
  • Re: Problems compiling with ISE Webpack 8.2.01i
    ... end MAJ3; ... port map,X,A1); ... This code compiles properly and I do see the waveform that I am ... I would like to know more about the libraries and the ...
    (comp.arch.fpga)
  • Re: Ridiculous size of executable?
    ... >I have been out of the programming arena for 10 years or so, ... The code compiles and runs, but I noticed that the size of ... C++ executables consist of a number of things stitched together by the ... Statically linked libraries, including the C and C++ runtime ...
    (alt.comp.lang.learn.c-cpp)
  • Re: MEX error message
    ... compiles the stuff with 3.4 which causes some incompatibilities. ... and move the old libraries out of the way, so matlab uses the new, ... Are those runtime libraries just relevant to MEX, ... another solution which comes to my mind: the matlab start script sets up the LD_LIBRARY_PATH. ...
    (comp.soft-sys.matlab)