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

Access Run Time in the MAC environment Err: object not set

P: n/a
Hi Everyone,

Here is another question:

I run a database in Access RT in a Virtual PC environment.

Every now and then I get an error: "Object Not set", which then freezes
everything. Not even CTRL + ALT + DELETE can really help.

Any idea what I can do to solve this problem???
---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.687 / Virus Database: 448 - Release Date: 16/05/2004
Nov 12 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
On Thu, 20 May 2004 12:26:42 +1200, "WindAndWaves" <ac****@ngaru.com>
wrote:

Buy a PC. Dell had a new one for $600.

No really, you just expect too much from an emulator. They work until
they don't. I'm assuming this is not a case where the error is
reproducible on a PC.

-Tom.

Hi Everyone,

Here is another question:

I run a database in Access RT in a Virtual PC environment.

Every now and then I get an error: "Object Not set", which then freezes
everything. Not even CTRL + ALT + DELETE can really help.

Any idea what I can do to solve this problem???
---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.687 / Virus Database: 448 - Release Date: 16/05/2004


Nov 12 '05 #2

P: n/a
Yes, I agree with all that (virtual PC may not do everything), but I do
find that everything else works, so i probably just need to change one line
in a procedure or so.

The thing is, it comes up completely randomly, almost like a timer, but i do
not use any events like that, as far as I know.

How could I analyse the bug??? or cath it somewhere???
---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.687 / Virus Database: 448 - Release Date: 16/05/2004
Nov 12 '05 #3

P: n/a
On Thu, 20 May 2004 17:59:53 +1200, "WindAndWaves" <ac****@ngaru.com>
wrote:

You could try the standard "on error goto" error handler in every
procedure. If it truly is an imperfection in the emulator, that may
not help though.

-Tom.

Yes, I agree with all that (virtual PC may not do everything), but I do
find that everything else works, so i probably just need to change one line
in a procedure or so.

The thing is, it comes up completely randomly, almost like a timer, but i do
not use any events like that, as far as I know.

How could I analyse the bug??? or cath it somewhere???
---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.687 / Virus Database: 448 - Release Date: 16/05/2004


Nov 12 '05 #4

P: n/a
as far as I know i have in each procedure (although i sometimes use on error
resume next). Is there no way to find out where it happens in another
way???

Thank you for your help.


"Tom van Stiphout" <to*****@no.spam.cox.net> wrote in message
news:3c********************************@4ax.com...
On Thu, 20 May 2004 17:59:53 +1200, "WindAndWaves" <ac****@ngaru.com>
wrote:

You could try the standard "on error goto" error handler in every
procedure. If it truly is an imperfection in the emulator, that may
not help though.

-Tom.

Yes, I agree with all that (virtual PC may not do everything), but I do
find that everything else works, so i probably just need to change one linein a procedure or so.

The thing is, it comes up completely randomly, almost like a timer, but i donot use any events like that, as far as I know.

How could I analyse the bug??? or cath it somewhere???
---
Please immediately let us know (by phone or return email) if (a) this emailcontains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.687 / Virus Database: 448 - Release Date: 16/05/2004

---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.688 / Virus Database: 449 - Release Date: 18/05/2004
Nov 13 '05 #5

P: n/a
"WindAndWaves" <ac****@ngaru.com> wrote:
Every now and then I get an error: "Object Not set", which then freezes
everything. Not even CTRL + ALT + DELETE can really help.


No idea as to why it freezes. I was getting this message when I had declared a
global database variable but for some reason somewhere it was getting lost. So I
ended up resetting that variable every time the user hit the main menu.

When I'm programming this would get lost when I was debugging code and hitting the
End code button. However if you're running on a runtime then this isn't the case.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 13 '05 #6

P: n/a
Tony Toews <tt****@telusplanet.net> wrote in
news:ph********************************@4ax.com:
"WindAndWaves" <ac****@ngaru.com> wrote:
Every now and then I get an error: "Object Not set", which then
freezes everything. Not even CTRL + ALT + DELETE can really help.


No idea as to why it freezes. I was getting this message when I
had declared a global database variable but for some reason
somewhere it was getting lost. So I ended up resetting that
variable every time the user hit the main menu.

When I'm programming this would get lost when I was debugging code
and hitting the End code button. However if you're running on a
runtime then this isn't the case.


Don't use a global database variable. Instead, use a global function
that returns an object of type DAO.Database, since you can make that
function internally self-healing by re-initializing your actual
global variable, if necessary. My code for this follows my sig.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[at module level, same one as included the function:]
Private dbCurrent As DAO.Database

Public Function dbLocal(Optional ysnInitialize As Boolean = True) _
As DAO.Database
' 2003/02/08 DWF added comments to explain it to myself!
' uses GoTos instead of If/Then because:
' error of dbCurrent not being Nothing but dbCurrent being
' closed would (3420) would then be jumping back into
' the middle of an If/Then statement
On Error GoTo errHandler
Dim strTest As String

If Not ysnInitialize Then GoTo closeDB

retryDB:
If dbCurrent Is Nothing Then
Set dbCurrent = CurrentDb()
End If
' now that we know the db variable is not Nothing,
' test if it's Open
strTest = dbCurrent.Name

exitRoutine:
Set dbLocal = dbCurrent
Exit Function

closeDB:
If Not (dbCurrent Is Nothing) Then
'dbCurrent.close
Set dbCurrent = Nothing
End If
GoTo exitRoutine

errHandler:
Select Case Err.Number
Case 3420 ' Object invalid or no longer set.
Set dbCurrent = Nothing
If ysnInitialize Then
Resume retryDB
Else
Resume closeDB
End If
Case Else
MsgBox Err.Number & ": " & Err.Description, vbExclamation, _
"Error in dbLocal()"
Resume exitRoutine
End Select
End Function
Nov 13 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.