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.

Quick 2007 Upgrade Question

P: n/a
I am looking for a quick sanity check, to make sure I my view of a
problem is reasonable.

Our organization just upgraded from Access 2003 to Access 2007. One
of our MS Access databases is not working the way it used to. It is
my understanding that this is a typical upgrade problem with Access
2007.

The database in question has a number of complex forms that talk to
one another. There is a lot of VBA code in the background making it
all work together.

After the upgrade to Access 2007, some of the screens stopped sending
information to one another.

Online, I found this statement regarding Access 2007:

Compatibility issues Access 2007 cannot understand some expressions
that work in previous versions. For example, this expression in the
Control Source of a text box results in #Name:
=[Form].[RecordsetClone].[RecordCount]

Soooooo.... is it reasonable for me to assume the problem is caused by
the type of compatibility issue noted above?

Someone who works with Acess all the time maybe sees this all the
time.

As always, any comments will be much appreciated.

Dan Allen
Jan 9 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
<da**********@gmail.comwrote in message
news:07**********************************@u10g2000 prn.googlegroups.com...
>I am looking for a quick sanity check, to make sure I my view of a
problem is reasonable.

Our organization just upgraded from Access 2003 to Access 2007. One
of our MS Access databases is not working the way it used to. It is
my understanding that this is a typical upgrade problem with Access
2007.

The database in question has a number of complex forms that talk to
one another. There is a lot of VBA code in the background making it
all work together.

After the upgrade to Access 2007, some of the screens stopped sending
information to one another.

Online, I found this statement regarding Access 2007:

Compatibility issues Access 2007 cannot understand some expressions
that work in previous versions. For example, this expression in the
Control Source of a text box results in #Name:
=[Form].[RecordsetClone].[RecordCount]

Soooooo.... is it reasonable for me to assume the problem is caused by
the type of compatibility issue noted above?

Someone who works with Acess all the time maybe sees this all the
time.

As always, any comments will be much appreciated.

Dan Allen

I don't have A2007 yet but this might help you find out where to start
looking:

http://allenbrowne.com/Access2007.html

Keith.
www.keithwilby.com

Jan 9 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.