Access 2007 Buggy?

[Joseph]

Is anyone else notising that Access 2007 seems very buggy?

I run into issues often when clicking on the properties of a report
control. The program appears to hang. Testing this issue has proven
that the program will return eventually after about 10 minutes. I am
the IT manager and recently upgraded the power users to Access 2007.
Between me and my CFO we are about to rip our hair out dealing with
editing reports. Seems to happen most often when attempting to change
the control source of a control.

My CFO is running Vista and I am running XP. I have had the problem
on both his and my machine and both running the DB locally and from
the network.

Has anyone found a solution to this issue or seen similar issues?

 

[Allen Browne]

Joseph, have you applied SP1 for Office 2007 yet?
If not, grab it from:
http://office.microsoft.com/search/redir.aspx?AssetID=DC102486291033&Origin=HH102511011033&CTT=5

IME, Access 2007 is useable after applying the service pack, i.e. the worst
of the bugs are fixed, and you can work around most of the rest of the bugs
if you know about them. More info about those bugs:
http://allenbrowne.com/Access2007.html#Bugs

Not sure the SP will solve your performance issue though. SP1 does address
some perf. issues, but your problem could be something else, particularly if
you are connecting across a network, and even more so if the tables are not
JET. If you have linked tables, try copying both the front end and the back
end to your local hard drive, and relinking the tables. That would at least
inform you whether your network is a factor.

Tony Toews has more general suggestions on performance issues in Access:
http://www.granite.ab.ca/access/performancefaq.htm
The bulk of those issues apply to A2007 also.

 

[angbob]

I have SP1 on XP Home. Access still is unreliable and inconsistent. For
example, perfectly good, simple SQL produces error codes for which there is
no message, but closing tables and queries, and reopening, clears the
problem. The standard workaround is to close everything, and start over. Is
Alpha Five any better?

 

[rrabins30]

I dont want to comment on Access 2007 (I will leave that to others)

Full Disclosure - I work for Alpha Five www.alphasoftware.com and we
have just released a major new version - Alpha Five v9 Platinum -with
extensive SQL support (including stored procedure suport and portable
SQL support), the abiltiy to build fast web 2.0 AJAX web apps with
full reporting (in very little time), supercontrols, drill down
reporting and major improvements to forms, browses,xbasic and xdialog.

I would suggest going to our web site and asking our message board
customers about its level or reliability and productivity.

I can say that the just ended beta program for Alpha Five v9 Platinum
went extremely smoothly and the release time was not keyed to a targe
date but rather was based on when we felt the product was ready (not
being a public company allows one to do this rather than having
release dates be dictated by CFO's and Wall Stree)

Thanks Richard Rabins

 

[gllincoln]

Checking the newsgroup header, yep, Microsoft Communities,
microsoft.public.access -

If a new version of software falls on the table amongst a forest of other
wannabees and no one is listening - did it make any noise?

Gordon



I dont want to comment on Access 2007 (I will leave that to others)

Full Disclosure - I work for Alpha Five www.alphasoftware.com and we
have just released a major new version - Alpha Five v9 Platinum -with
extensive SQL support (including stored procedure suport and portable
SQL support), the abiltiy to build fast web 2.0 AJAX web apps with
full reporting (in very little time), supercontrols, drill down
reporting and major improvements to forms, browses,xbasic and xdialog.

I would suggest going to our web site and asking our message board
customers about its level or reliability and productivity.

I can say that the just ended beta program for Alpha Five v9 Platinum
went extremely smoothly and the release time was not keyed to a targe
date but rather was based on when we felt the product was ready (not
being a public company allows one to do this rather than having
release dates be dictated by CFO's and Wall Stree)

Thanks Richard Rabins

 

[valentina kesler]

I dont want to comment on Access 2007 (I will leave that to others)

Full Disclosure - I work for Alpha Five www.alphasoftware.com and we
have just released a major new version - Alpha Five v9 Platinum -with
extensive SQL support (including stored procedure suport and portable
SQL support), the abiltiy to build fast web 2.0 AJAX web apps with
full reporting (in very little time), supercontrols, drill down
reporting and major improvements to forms, browses,xbasic and xdialog.

I would suggest going to our web site and asking our message board
customers about its level or reliability and productivity.

I can say that the just ended beta program for Alpha Five v9 Platinum
went extremely smoothly and the release time was not keyed to a targe
date but rather was based on when we felt the product was ready (not
being a public company allows one to do this rather than having
release dates be dictated by CFO's and Wall Stree)

Thanks Richard Rabins

 

[WylieCoyote]

Yes, I have found Access 2007 to be loaded with bugs. Major problems
supporting any earlier versions of Access like 2000 or 2002. Applications
just stopped running, I.e. hung, and Access 2007 just crashed. MS got dozens
of very large dumps but to date is not indicating any issues. When previously
running applications crash you get "2950" errors with no clue to what
actually caused the error. Since the same software runs under Access 2002
native with no issues I can only assume all of the errors are related
directly to Access 2007. Using dependencies or performance analysis on a
medium size system just about guarantees a system crash.

Bottom line is I would stay away from Access 2007 for at least another year
and or until MS come forward with some statement of their problems and
associated fixes.
Access 2002 is pretty stable.