J
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
say 2000 but give me the option to convert to 2002 should
I do this??
John
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
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.
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.
J
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
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
A
Allen Browne
Answers in-line.
You will have to decide that.
Where relevent.
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.
John said:[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.
T
Tim Ferguson
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.