/decompile and updatable recordset

[Henry Bloom]

Hello,

I have two questions:

1. The file-size of my mdb-Database grew extremely large after having
written a lot of VBA-code. I know about the /decompile-option tried it
.... it did not work. Why? what to do now?

2. I have a query producing an updatable dynaset of data. When I tried
opening it in a VBA-routine like

DIM qry AS DAO.QuerySet
DIM rst AS DAO.Recordset

set qry ...
set rst = qry.OpenRecordSet

my rst is NOT updatable. I tried to modify the opening-process ... no
success.
What could be the problem?
(May be I better send the whole code ... later, as I dont have it here,
now.)

Thanks.

Holger.

[hal boyles]

remember to reassign any references you may have in your old MDB if you
choose to copy to a new MDB

[Deano]

hal boyles wrote:

remember to reassign any references you may have in your old MDB if
you choose to copy to a new MDB

And check Relationships. All mine disappeared after a decompile!

[Bruce M. Thompson]

> And check Relationships. All mine disappeared after a decompile!

Inasmuch as "decompile" only affects the VBA code, I suspect that your problem
has a different source.

--
Bruce M. Thompson, Microsoft Access MVP
bt******@mvps.org (See the Access FAQ at http://www.mvps.org/access)

NO Email Please. Keep all communications

within the newsgroups so that all might benefit.<<

[Deano]

Bruce M. Thompson wrote:

And check Relationships. All mine disappeared after a decompile!

Inasmuch as "decompile" only affects the VBA code, I suspect that
your problem has a different source.

NO Email Please. Keep all communications

within the newsgroups so that all might benefit.<<

Hmmm, that's interesting, I just assumed it was the decompile. Time for
some testing...

[Michael \(michka\) Kaplan [MS]]

Actually, Bruce is right -- /DECOMPILE would not do this.
--
MichKa [MS]

This posting is provided "AS IS" with
no warranties, and confers no rights.
"Deano" <ma************@hotmail.com> wrote in message
news:WW********************@wards.force9.net...

Bruce M. Thompson wrote:

And check Relationships. All mine disappeared after a decompile!

Inasmuch as "decompile" only affects the VBA code, I suspect that
your problem has a different source.

NO Email Please. Keep all communications

within the newsgroups so that all might benefit.<<

Hmmm, that's interesting, I just assumed it was the decompile. Time for
some testing...

[Deano]

Michael (michka) Kaplan [MS] wrote:

Actually, Bruce is right -- /DECOMPILE would not do this.

It was probably me...