By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,635 Members | 913 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,635 IT Pros & Developers. It's quick & easy.

/decompile and updatable recordset

P: n/a
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.

Nov 12 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
remember to reassign any references you may have in your old MDB if you
choose to copy to a new MDB
Nov 12 '05 #2

P: n/a
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!
Nov 12 '05 #3

P: n/a
> 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.<<
Nov 12 '05 #4

P: n/a
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...
Nov 12 '05 #5

P: n/a
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...

Nov 12 '05 #6

P: n/a
Michael (michka) Kaplan [MS] wrote:
Actually, Bruce is right -- /DECOMPILE would not do this.


It was probably me...

Nov 12 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.