Access 2000 file format to 2002

[John]

I have office xp pro 2002 and the file format in access
say 2000 but give me the option to convert to 2002 should
I do this??


John

 

[Allen Browne]

If you are writing an application for other people to use, you will probably
want to release an MDE so the user cannot tamper with the objects or code,
or decompile the app. You need to use the 2002 format to relese the MDE.

Otherwise the file format does not matter. The Service packs (SP-2 for
Office XP, and SP8 for JET 4) that you and your users have *is* important.

 

[John]

Thank You very much Mr. Browne you answered my question
to a tee... I have one more for you I am a very new
access programmer and I am putting together a database at
work I have been asking Mr. Ferguson another MVP on this
site for some assistance and He can go no further I am
having real trouble with the desgn model here is a copy
of what I posted hope you can help....

I am trying to develop a access database version 2002
from scratch and I am a novice programmer and need much
direction. I have been researching and studying about
relational database design and normalization I am
including the 9 tables and there fields that I have
already developed. I have and I am not sure what to name
the tables and I am thinking of making the incident #
field the pimary key?? Can I put that in all the tables?
I am determined to develop this and do it well. We are a
Refuse Disposal site , is there any Disposal Management
Database examples out there... If not can I get some
free advice and help in designing this database . Are my
tables looking okay? Can I use the( Incident # )as the
primary key for all the tables to connect them ? In one
of the tables I want to put digital pictures of the
dump sites can I develop a table for this to get them to
show up on the form..or do I need another database??
There are about a 100 pic's.. in all. I have to scan
them in using the .bmp ext. is this okay???. My OS is
Win Xp Home Editon and Office Xp Pro 2002 I only have 128
Mb memory..Do I need more? Here are the tables with the
fields: I have gathered the following information from
the 3 forms that the staff fills out by hand and then the
secretary takes 3months worth and then types them out to
look better. I am confused on how to design the table
logic and make it relational

1. Location/Name= This is the name of the road or a
persons name
2. Incident # = the number that it assign as they
are called in
3. Directions from the court house= name of road
where site is
4. Latitude and Longitude this is a question
5. Dump Size = (ft) Width x (ft)Length x (ft)
Depth = (ft)to the 3rd power volume How do I make this a
field?
6. How Many Single Axle Dump truck loads ?
7. Is there a well within 500 ft. of an open dump ?
(this is a yes no box)
8. Date Dumpsite Identified
9. Date to Clean
10. List any local schools or historic sites
11. Responsible Party (yes/no)
12. Enforcement actions Underway (Yes/No)
13. County
14. Nearest road

Contents (All Yes/No Boxes) Do I make this a lookup box
for all this?
1. Household
2. CD/D Building Material
3. CD/D Concrete
4. Brush/Landscape
5. Appliances
6. Tires
7. Hazardous Material
8. Other / List


Accessibility is another question with Y/N Boxes make
this lookups ?

1. Paved
2. Gravel/dirt
3. steep slope
4. trees surrounding site
5. water surrounding site
6. other/ List

Type of setting is another question with these
selections Y/N Boxes .

1. Public Property
2. flood plain/floodway
3. open field
4. sink hole
5. cliff
6. hillside
7. woods
8. creek/river
9. old quarry pit
10. roadside
11. other/list

Digital Photos Table I think I understand how to do
this? I found a picture example within the Northwind
Database VB code under event procedure...i will work with
it. may have questions later

Equipment Cost is another field with these questions for
the surveyor
1. Equipment Type has multiple listings under it
like bulldozer 8 different kinds also dump trucks,
backhoes just depends on what is needed to cleanup sites
2. Max Hourly Rate = how much we charge for our
equipment use
3. actual hourly rate= same as max
4. hours used.
5. total= a formula of actual x hours used

Disposal Fee = when the site is cleaned and the waste is
hauled off and dumped at the main dump site (which by the
we have a contract with them) .
1. Facility Name and location = where we dump it at
2. Tons estimated = how much the load is on scales
3. Per ton cost =
4. total

Labor Cost = this part of the form is where we figure our
labor cost for the job site.
1. Employee Title= this is made up of 4 different
titles do I put this in a lookup box?
2. estimated work hours
3. hourly wage
4. total

Miscellaneous Supplies
1. Specific Item
2. quantity
3. per unit cost
4. total


Please help me with any advice as to line these out...
Thanks John

 

[Allen Browne]

Answers in-line.

[snip] I have and I am not sure what to name
the tables ...

You will have to decide that.

... and I am thinking of making the incident #
field the pimary key?? Can I put that in all the tables?

Where relevent.

I am determined to develop this and do it well. We are a
Refuse Disposal site , is there any Disposal Management
Database examples out there... If not can I get some
free advice and help in designing this database .

You probably need to study other existing examples, learn about
normalization, learn about queries, learn about VBA, and practice with some
simple examples, e.g. Northwind. We cannot give you all that in a few
newsgroup posts. Then, when you understand how it all works and understand
about the big picture, we may be able to help with a specific, small
question.

 

[Tim Ferguson]

Mr. Ferguson another MVP

I wish... <g>


Tim F