Do you know if it is possible to convert the new format (assuming Access 2010 has a 'new' format too, like the other office programs), into something compatible with 2000/2003? Because if it is way easier and more intuitive to design stuff like forms/reports and switchboards in Access 2010, I might consider installing it just for that (provided it can be installed side-by-side with the old... hmm)
No, unfortuantely you can't save it in a compatibility mode if it uses any of the new features as they aren't backwards compatible.
quote:Originally posted by CookieRevised
PS: another big advantage of multiple-table design... you wont get not-found entries when you search for "John" but have typed "Jonh" in one of the actor fields just trying to convice you
You wouldn't be you if you didn't try to convince me . Luckily I'm a meticulous typist
Yeah, thanks for the suggestion Adeptus....I'm kinda going for the "If it aint broke...." approach at the moment. I understand that when you code/work with databases a lot of the time you'd want to suggest something more practical, I'm the same way with stuff I spend a lot of my time on