- Joined
- Oct 11, 2005
- Location
- Tau'ri
I am building a database with MS access for work.
The information contains, job numbers, addresses etc
The problem is that everyone that searches the data base (with their own access 2k3 or 2k7) tends to save their searches in it so I have to go through and clean it up periodically.
What I would like to do is to create something that will allow people (3-4 tops) to be able to search the database for any one of the columns. and get all results. We generrlly do searches with variables. (IE filter by form street = wash* instead of typing washington.
a) What is the best method for giving searchable access to the database, aside from having hte users run MS access? Is a webpage the only option?
I have been adding lat and long in decimal format so that I can export the mdb to google earth, to make a simple visual reference for nearby jobs.
b) Would building a webpage with the Earth API make do more than show points on the map? IE will it show the data in each record or make them clickable or even grabbing a few together and displaying results?
Lastly, I added another column to the database that includes associated files (mostly scans of surveys or documents that I have digitized or I have found on the current server) I would also like to make these links to networked files.
c) Is there a simple method to generating links to associated files? Or will I have to provide the full network path to each individual file?
I am rewriting the db in access 2k7, however the new server is probably going to be running Linux. My boss (as much as he loves his unix boxes) does not like OOo. Hopefully the compatibility has improved over the last decade
The current unfinished DB has over 18K records, but for now I am only interested in handling this millenium. (The current hard copies go back to hte mid 70s)
Example of the info
Work ORder number, house address, Street, block, lot, city (abbr), where pysical file is located, jobs performed, important notes, lat, long, associated digital files.
I toyed around with adding customer names, but it is something that changes too often to be worthwhile. It would be nice, but not necessary.
I am at a bit of a loss googling this information for myself, as my keywords are lacking since I never used access before. In my readings I did find out about google earth integration which I think is great. However dialing down my searches has been a bit difficult. So even if you do not know hte answers specifically, pointing me to a good resource or even helping out with keywords would be great!
Thanks In Advance
The information contains, job numbers, addresses etc
The problem is that everyone that searches the data base (with their own access 2k3 or 2k7) tends to save their searches in it so I have to go through and clean it up periodically.
What I would like to do is to create something that will allow people (3-4 tops) to be able to search the database for any one of the columns. and get all results. We generrlly do searches with variables. (IE filter by form street = wash* instead of typing washington.
a) What is the best method for giving searchable access to the database, aside from having hte users run MS access? Is a webpage the only option?
I have been adding lat and long in decimal format so that I can export the mdb to google earth, to make a simple visual reference for nearby jobs.
b) Would building a webpage with the Earth API make do more than show points on the map? IE will it show the data in each record or make them clickable or even grabbing a few together and displaying results?
Lastly, I added another column to the database that includes associated files (mostly scans of surveys or documents that I have digitized or I have found on the current server) I would also like to make these links to networked files.
c) Is there a simple method to generating links to associated files? Or will I have to provide the full network path to each individual file?
I am rewriting the db in access 2k7, however the new server is probably going to be running Linux. My boss (as much as he loves his unix boxes) does not like OOo. Hopefully the compatibility has improved over the last decade
The current unfinished DB has over 18K records, but for now I am only interested in handling this millenium. (The current hard copies go back to hte mid 70s)
Example of the info
Work ORder number, house address, Street, block, lot, city (abbr), where pysical file is located, jobs performed, important notes, lat, long, associated digital files.
I toyed around with adding customer names, but it is something that changes too often to be worthwhile. It would be nice, but not necessary.
I am at a bit of a loss googling this information for myself, as my keywords are lacking since I never used access before. In my readings I did find out about google earth integration which I think is great. However dialing down my searches has been a bit difficult. So even if you do not know hte answers specifically, pointing me to a good resource or even helping out with keywords would be great!
Thanks In Advance