Re: Lock / Unlock VBA project

Thank you Alex, much appreciated !

"Alex Dybenko" wrote:

Hi,
glad that you solved it, so it was undeclared variables, which prevented to
make MDE?

library MDB (MDE) - create ne mdb, import forms/modules from your app, which
you think can be used in other apps (or just which you like to have
separated), delete these modules/forms from original mdb, open any module,
tools-references and add reference to just created mdb file. Actually you
have to make MDE of it and add reference to library MDE in order to make MDE
from main MDB


--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

"FreeWheel" <FreeWheel@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1931634E-301B-44C3-9D6D-A4E880E31C07@xxxxxxxxxxxxxxxx
Hi Alex,

Finally SOLVED !
Code that won't compile will prevent MDEing and give this unrelated Table
ID
error.
So I fixed a couple of undeclared variables.

However, If I may, would you give me a hint on how setting a reference
to
an MDB as a library database ?

Tks


"Alex Dybenko" wrote:

Hi,
so do you mean that if you remove tables/queries - then you can compile
to
MDE?
If this is really a reason - then I would try to make less objects
(merging
modules into one/reviewing application) or moving some modules/forms into
separate library database, then you can add reference to it and use
code/forms same way like in the same MDB

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com



"FreeWheel" <FreeWheel@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4DE879DB-DCFD-43D3-8571-AA7D623C4126@xxxxxxxxxxxxxxxx
Hi,

Yes I did. I have also tried MDEing the modules, the forms and the
reports
separately which works but then Access will not allow importing into
one.....
I've got to find something.

Anymore ideas ?

Regards,

"Alex Dybenko" wrote:

Hi,
never heard of such error creating mde. have you tried to split
application
and have separate mdb with tables?

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com


"FreeWheel" <FreeWheel@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:463FC983-C2F5-4E2C-B0E4-2C4FA2B4D654@xxxxxxxxxxxxxxxx
Hi,

The application has many tables , very many reports and and forms so
Access
won't complete the MDE conversion telling me there is too many table
reference IDs for it too handle.

Do you know of any patch for this limitation ?

Tks

"Alex Dybenko" wrote:

Hi,
suggest that you make mde and put a time check routine there, it is
much
better solution that deleting reports

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com




"FreeWheel" <FreeWheel@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:131BA243-33F1-47E9-9CFF-222CEC01663A@xxxxxxxxxxxxxxxx
HHHHHEEEELLLLLLPPPPPP anyone !

How do I Lock / Unlock my VBA project for viewing from a module
within
?

I got this code in a Module which behaves properly only when the
VBA
project
lock for viewing is OFF.

If dbs.AllReports.Count > 0 Then
For num = dbs.AllReports.Count To 1 Step -1
itemnum = num - 1
Set obj = dbs.AllReports(itemnum)
If obj.IsLoaded = False Then
DoCmd.DeleteObject acReport, obj.Name
Else
End If 'obj.IsLoaded
Next num
Else
End If 'AllReportsCount

I need to set the lock OFF ahead of this piece of code and back
ON
right
after it.
After spending too many evenings on the WEB searching....., I can
only
find
PASSWORD RECOVERY utilities which work but I do not need.... I
need
what's
inside !

What do I need to set / reset ?



.

Relevant Pages

  • Re: Correct Sequence?
    ... a reference to DAO by default. ... When you create a new mdb, ... Microsoft Access MVP ... Now try to create the MDE. ...
    (microsoft.public.access.security)
  • Re: creating external references
    ... The easiest way to implement this is with a referenced MDE. ... Then 'compile' it into an MDE and set a reference in your other ... deploy the frontends as MDBs (because an MDB will recompile against the new ... DLL, which means that all class GUIDs remain the same after a rebuild. ...
    (microsoft.public.access.modulesdaovba)
  • Re: expose class modules of a referenced mde
    ... Since I can't reference an .mdb from an .mde (which is what the final ... reference file and import the class objects as needed into the app. ...
    (comp.databases.ms-access)
  • Re: Function name not found
    ... certain Reference changes from version to version in MDBs, ... format (MDB is still fine) on the affected PC. ... Is there a way to check the pre-compiled MDE ... Looking at you Startup function, the first thing I see is a DFirst ...
    (microsoft.public.access.modulesdaovba)
  • Re: Class Library
    ... I start a new .mdb that is to use a class in Class.mdb. ... references in Access - will the Class.mdb come up on the reference window? ... "Alex Dybenko" wrote: ... >> many different database projects? ...
    (microsoft.public.access.modulesdaovba)
Loading