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

Strange behevior! The same code gives different results on same type of machines!

Expert 100+
P: 1,418
When I use the statement:

Set objDatasheet = Application.Screen.ActiveDatasheet

there is no problem on the majority of machines, but
on one or two of them Visual Basic generates this kind of error:

Out of Memory

On the same kind of machine the code runs normally. I swaped the RAM but there was no result!

What can provoke this behevior?
Aug 29 '06 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 1,418
In plus this code for some queries is executed perfectly! But for others not!
Aug 30 '06 #2

Expert 100+
P: 1,418
I've changed the hard disks of a computer that everthing is ok and a problematic one ...

and Surprise...

The problem isn't in the machine or in the memory.... The problem is in reation with the hard disk...

But pls... It is the installation of the same windows, the same office... nearly everything is the same... And it don't want work....

Is it from the registry? Or maybe parameters that concern MS ACCESS..

I'll do other tests next week... But I'm really fed up!

Any suggestions are welcome! :)
Nov 4 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.