I just got A2007
wheres the help? found that eventually!
wheres the database window? there ain't one!
anyway
i've got A97, A2002XP, A2003, which all work seamlessly at the same time
but A2007 keeps reinstalling/conifguring and then forces the others (except A97) to do the same
as I only got because a client has it and I have to keep up, its not the end of the world but is this normal?
Thanks
I posted this before, but didnt get any answers
In A2007, has anyone had a problem with checking whether a text field is equal to "" in a query
ie - select * from whatever where targetfield = ""
-----------
this generated a type mismatch (I actually had <is null or ""> in the query definition, but it was the "" it didnt like.
Just doing my regular check-in. Wondering if Microsoft has come to grips with this yet :mad:. My form with dozens of databound controls opens instantly on Access 2003, but takes over 10 seconds on Access 2007. I can see poor little A2007 slowly drawing each control. It's rather sad, but humorous, and yet pathetic at the same time to watch Microsoft's flagship products going down the toilet along with their stock price.
The problem appears when:
- You have more than a few databound controls
- You have SQL server on the backend
Every time I try to get help, the Microsoft "MVP" of the moment declares that I have a problem with my query and "forgets" that the form opens instantly in the old standby Access 2003.
Or has Microsoft admitted yet that they have a problem? Like I said, I'm just doing my regular check-in :rolleyes:. My client is happy enough using Access 2003 and will continue to do so forever until I tell them they need to upgrade... but right now Microsoft is taking us both to the poorhouse :mad:
Hi,
I've been working on a database at work in Access 2003. I need to speed up though, so I thought I'd it bring it home on a USB memory stick and work on it here using Access 2007. I do this all the time with Word and Excel files and just take care to save them in 2003 version so I can use them back in the office.
But when I try to open this database, it's asking for a password. I know for a fact I haven't set any password on it, because I wouldn't know how to. Holding down the shift key is ineffective too.
Is Access 2007 not backwards compatible or something?
I have an unbound report - which is actually a form for the user to print out if they need one. There is no data on the form.
Here is the code that is run when the Button is Clicked:
'First, I reenable the Access menus so that they can use those to print
DoCmd.OpenReport "TransitionSurveyPaperFormLEA", acViewPreview
When I open the report on XP/Access 2007, it works just fine.
When I open the exact same accdb with a Win7/A2007 machine, the report does not open. If I debug and display the error, a msgbox appears
"The OpenReport action was canceled."
I have other bound reports and those open with XP/A2007 or Win7/A2007 just fine.
It makes me VERY nervous that the same exact ACCDB in A2007 runs differently on different OSs (XP vs Win7).