Re: Conversion to 2007

Thanks to all for the good suggestions.

I'm always a bit hesitant to ask for help here because then I really get into
areas that I really do not understand.
Since I had no training or understand VBA I really don't know what a well
designed database is.
All I know Iis have multiple tables used to store data and multiple tables
for drop down menus in forms.
Sometime I used multiple queries to filter the information or shape reports
that I wanted.
It works very well but it was designed by using wizards and queries criteras.
During the 3 months since I discovered this site I have learned a lot of
things that would have done different from the beginning. So is it well
designed? I would venture to say no, but it works well, I was told it is user
friendly compared to other programs off the shelf. I was an opearation
manager and a user so I developed this out neccessity and used my experience
to makes the result usefull.
Next wednesday I will make it available to people that receaved new PC with
Office Pro 2007 and hope it will work as well with office 2003

Charles

Allen Browne wrote:
Access 2007 can natively handle the Access 2000 or 2002/3 database formats,
so a well-designed database may work without modification in A2007.

However, the user interface is quite different in A2007 (e.g. ribbon in
place of menus and toolbars), and there are some compatibilitiy issues to be
aware of. For details, see:
Converting to Access 2007
at:
http://allenbrowne.com/Access2007.html

There are some properties you may want to set before you let the A2007 users
loose in this db:
Prevent Access 2007 users modifying existing databases
at:
http://allenbrowne.com/ser-69.html

The mixed front ends should be okay. As always, an MDE is best as it does
not decompile.

Don't miss the point about trusting the folder where the front end resides.

I have developed a database in 2003 and now I need to install it in a mixed
enviroment some PC have 2003 and some 2007 is there an easy way to make
[quoted text clipped - 4 lines]
same
shared network with desktop shortcuts.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200802/1

.

Relevant Pages

  • Re: Multiple databases - best performance scenario
    ... My company has the need to manage data for multiple customers. ... Multiple small physical servers connected to SAN ... When I'm using the word database ... You might consider checking licensing costs at the oracle store ...
    (comp.databases.oracle.server)
  • Re: Rails app organization question
    ... I -really- like Rails, though. ... Have one instance of the app and somehow allow it to use different databases depending on the user's login. ... Have multiple instances of the app running on virtual servers, similar to how cPanel sets up accounts for multiple hosts -- each host has its own directory, MySQL database, and so on. ...
    (comp.lang.ruby)
  • Re: Merging Data Dynamically
    ... not mind multiple back-ends. ... But if you had told me your Sailing Clubs are all owned by ... then loop through all the tables to detach them from 1 back end database ... sudden addition of Removals5 and create a linked table for it. ...
    (comp.databases.ms-access)
  • Re: MySQL vrs SQLite
    ... Can multiple applications or multiple instances of the same ... But only one process can be making changes to the database at ... >>will need to implement your own data conversion though. ... declared as integer and float to the appropiate Python types. ...
    (comp.lang.python)
  • Working with large number of search results in struts/jsp application
    ... 30000 results obtained from a very complex schema and multiple queries ... creating a database Connection as a session variable is not a good ...
    (comp.lang.java.programmer)