Difference between Access 2007 and Access 2010?

  • Thread starter Thread starter BrianDP
  • Start date Start date
B

BrianDP

I have an application that I wrote in Access, Client/Server, "Split"
Database if you like. Some of the workstations run on Access 2007,
and they work fine. We got some NEW installations faster newer
<better??> Anyway I figured try the application out on multiple
versions of Access. It works on all the versions of Office I have,
EXCEPT Office 2010. Does anyone know of anything special about
office 2010?

Thanks!

-BrianDP
Best Data Processing
 
:
I have an application that I wrote in Access, Client/Server,
"Split" Database if you like. Some of the workstations run on
Access 2007, and they work fine. We got some NEW installations
faster newer
<better??> Anyway I figured try the application out on multiple
versions of Access. It works on all the versions of Office I
have, EXCEPT Office 2010. Does anyone know of anything special
about office 2010?
Click to expand...

Well, what doesn't work?
 
Well, what doesn't work?
Click to expand...

It opens, and just sits there. It says it's calculating along the
bottom. Fairly quickly, the application turns all white, and
crashes. I've tried removing any code that may be running when that
form opens, but it still hangs on open. The very same application
when you run it on a 2007 or earlier install works just fine.

Any clues?

-BrianDP
 
m:
It opens,
Click to expand...

What opens?
and just sits there.
Click to expand...

What are you expecting it to do?
It says it's calculating along the
bottom. Fairly quickly, the application turns all white, and
crashes. I've tried removing any code that may be running when
that form opens, but it still hangs on open. The very same
application when you run it on a 2007 or earlier install works
just fine.

Any clues?
Click to expand...

Have you tried all the corruption troubleshooting methods first?
 
m:







What opens?


What are you expecting it to do?



Have you tried all the corruption troubleshooting methods first?

--
David W. Fenton                  http://www.dfenton.com/
contact via website only    http://www.dfenton.com/DFA/- Hide quoted text -

- Show quoted text -
Click to expand...

Well, I FEEL like I've tried all the corruption methods, but, is there
a list of them somewhre so I can be sure I've tried everything?

I'm no access n00by, but this one has me stumped!

Thanks in advance!

-BrianDP
 
m:
Well, I FEEL like I've tried all the corruption methods, but, is
there a list of them somewhre so I can be sure I've tried
everything?
Click to expand...

Well, you should try to avoid various methods of corruption! ;)

The canonical list for corruption troubleshooting, so far as I'm
concerned, is Tony Toews's:

http://www.granite.ab.ca/access/corruptmdbs.htm

(Grrr -- I really hate how Google now munges the links with its
tracking crap so you can't copy them to the clipboard directly any
longer)
 
Well, you should try to avoid various methods of corruption! ;)

The canonical list for corruption troubleshooting, so far as I'm
concerned, is Tony Toews's:

 http://www.granite.ab.ca/access/corruptmdbs.htm

(Grrr -- I really hate how Google now munges the links with its
tracking crap so you can't copy them to the clipboard directly any
longer)
Click to expand...


Okay, I've made sure it's not corrupted. Since I've posted, I've
discovered some other things. When they open the database, everything
is fine. it's one particular form, that has several sub forms on it,
that seems to give it the most trouble. In fact, if you open it to
another form first, then everything starts working the way it should.
I thought of writing a little piece of code, that opens the other
window, and closes it, that way, the database is already "Fixed" But
what is it about this one form with its subforms, that when it opens,
it just locks up. It has "Calculating..." at the bottom. and it
never goes away. What is it calculating? All the fields that are
sorted on are indexed..

Help!

-Brian
 
m:
Okay, I've made sure it's not corrupted. Since I've posted, I've
discovered some other things. When they open the database,
everything is fine. it's one particular form, that has several
sub forms on it, that seems to give it the most trouble. In fact,
if you open it to another form first, then everything starts
working the way it should. I thought of writing a little piece of
code, that opens the other window, and closes it, that way, the
database is already "Fixed" But what is it about this one form
with its subforms, that when it opens, it just locks up. It has
"Calculating..." at the bottom. and it never goes away. What is
it calculating? All the fields that are sorted on are indexed..
Click to expand...

Perhaps you should now read Tony's Performance FAQ:

http://www.granite.ab.ca/access/performancefaq.htm

It sounds to me like the persistent connection may be the solution
to your problem.
 
Back
Top