If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Using Database instead of Excel
Good morning,
We have 5 departments in our company, and we track the jobs of those departments so that the upper management can see what is going on. This is how we do currently. I designed a job log in Excel for each department, and those job logs are linked to an Access database. The management then run the reports to see the status of those jobs. I know that is not a sufficient way to do it. Unfortunately, we only have a limited number of Access licenses. I want to know what you guys would do in my situation. Can the departments use the MDE files without having Access on their computers, and how does it work? Any suggestions or inputs would be greatly appreciated. |
#2
|
|||
|
|||
Using Database instead of Excel
An MDE alone won't help. You'll need to install the run time plus buy an
expensive package to create it. You might be able to create Active Server Pages and put them out on your network. Then people can work with the database through their web browser. -- Jerry Whittle Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "AccessHelp" wrote: Good morning, We have 5 departments in our company, and we track the jobs of those departments so that the upper management can see what is going on. This is how we do currently. I designed a job log in Excel for each department, and those job logs are linked to an Access database. The management then run the reports to see the status of those jobs. I know that is not a sufficient way to do it. Unfortunately, we only have a limited number of Access licenses. I want to know what you guys would do in my situation. Can the departments use the MDE files without having Access on their computers, and how does it work? Any suggestions or inputs would be greatly appreciated. |
#3
|
|||
|
|||
Using Database instead of Excel
Jerry,
Thanks. Can you tell me more about Access and ASP? I know what is ASP, but I have not used ASP with Access. Or can you give me a web site where I can go to learn more about it? Do the users need to have Access on their computers for the ASP? As I mentioned in my initial message, the users do not have Access on their computers. Thanks again. "Jerry Whittle" wrote: An MDE alone won't help. You'll need to install the run time plus buy an expensive package to create it. You might be able to create Active Server Pages and put them out on your network. Then people can work with the database through their web browser. -- Jerry Whittle Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "AccessHelp" wrote: Good morning, We have 5 departments in our company, and we track the jobs of those departments so that the upper management can see what is going on. This is how we do currently. I designed a job log in Excel for each department, and those job logs are linked to an Access database. The management then run the reports to see the status of those jobs. I know that is not a sufficient way to do it. Unfortunately, we only have a limited number of Access licenses. I want to know what you guys would do in my situation. Can the departments use the MDE files without having Access on their computers, and how does it work? Any suggestions or inputs would be greatly appreciated. |
#4
|
|||
|
|||
Using Database instead of Excel
There is a cost associated with using asp and it is much more than with
purchasing the VS Tools for MS Office which would allow you to distribute the Access runtime engine. You have to buy it. You have to learn it. You have to develop the web pages you need. You have to test them, etc. Only users who need to make development changes to an Access database need to have the full retail version of Access installed. Users who just run applications created by someone else can use the runtime engine. The package that includes the unlimited distribution rights to the runtime costs around $500. Much less if you are a non-profit or educational company. The runtime is not without problems however. You need to have complete error trapping and that means removing virtually all macros and you need to make custom menus. If this solution interests you, search the knowledge base and MSDN library for articles and problems. "AccessHelp" wrote in message ... Good morning, We have 5 departments in our company, and we track the jobs of those departments so that the upper management can see what is going on. This is how we do currently. I designed a job log in Excel for each department, and those job logs are linked to an Access database. The management then run the reports to see the status of those jobs. I know that is not a sufficient way to do it. Unfortunately, we only have a limited number of Access licenses. I want to know what you guys would do in my situation. Can the departments use the MDE files without having Access on their computers, and how does it work? Any suggestions or inputs would be greatly appreciated. |
#5
|
|||
|
|||
Using Database instead of Excel
Hi Pat,
Thanks for the information. I am just wondering what you would do if you are me on this project. Or what would be an efficient way of tracking the jobs? Thanks again. "Pat Hartman(MVP)" wrote: There is a cost associated with using asp and it is much more than with purchasing the VS Tools for MS Office which would allow you to distribute the Access runtime engine. You have to buy it. You have to learn it. You have to develop the web pages you need. You have to test them, etc. Only users who need to make development changes to an Access database need to have the full retail version of Access installed. Users who just run applications created by someone else can use the runtime engine. The package that includes the unlimited distribution rights to the runtime costs around $500. Much less if you are a non-profit or educational company. The runtime is not without problems however. You need to have complete error trapping and that means removing virtually all macros and you need to make custom menus. If this solution interests you, search the knowledge base and MSDN library for articles and problems. "AccessHelp" wrote in message ... Good morning, We have 5 departments in our company, and we track the jobs of those departments so that the upper management can see what is going on. This is how we do currently. I designed a job log in Excel for each department, and those job logs are linked to an Access database. The management then run the reports to see the status of those jobs. I know that is not a sufficient way to do it. Unfortunately, we only have a limited number of Access licenses. I want to know what you guys would do in my situation. Can the departments use the MDE files without having Access on their computers, and how does it work? Any suggestions or inputs would be greatly appreciated. |
#6
|
|||
|
|||
Using Database instead of Excel
As long as your company is willing to buy the VS Tools for you, keep
everything in Access. If they won't, you can distribute reports from Access in .snp format (the reader is free if you don't already have it installed). You could also export spreadsheets as reports. "AccessHelp" wrote in message ... Hi Pat, Thanks for the information. I am just wondering what you would do if you are me on this project. Or what would be an efficient way of tracking the jobs? Thanks again. "Pat Hartman(MVP)" wrote: There is a cost associated with using asp and it is much more than with purchasing the VS Tools for MS Office which would allow you to distribute the Access runtime engine. You have to buy it. You have to learn it. You have to develop the web pages you need. You have to test them, etc. Only users who need to make development changes to an Access database need to have the full retail version of Access installed. Users who just run applications created by someone else can use the runtime engine. The package that includes the unlimited distribution rights to the runtime costs around $500. Much less if you are a non-profit or educational company. The runtime is not without problems however. You need to have complete error trapping and that means removing virtually all macros and you need to make custom menus. If this solution interests you, search the knowledge base and MSDN library for articles and problems. "AccessHelp" wrote in message ... Good morning, We have 5 departments in our company, and we track the jobs of those departments so that the upper management can see what is going on. This is how we do currently. I designed a job log in Excel for each department, and those job logs are linked to an Access database. The management then run the reports to see the status of those jobs. I know that is not a sufficient way to do it. Unfortunately, we only have a limited number of Access licenses. I want to know what you guys would do in my situation. Can the departments use the MDE files without having Access on their computers, and how does it work? Any suggestions or inputs would be greatly appreciated. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can we import an Excel sheet to use as base for report? | StargateFan | New Users | 9 | November 4th, 2005 08:32 PM |
Toolbars, Drop-Down Menus | Rick | New Users | 1 | September 21st, 2005 11:17 AM |
How do I use Excel to post data to an external database? | ctimrun | General Discussion | 0 | June 14th, 2005 05:39 AM |
Encrypt AccesS File? | milest | General Discussion | 2 | February 9th, 2005 08:58 PM |
Access Error Message when opening database | eah | General Discussion | 3 | January 26th, 2005 11:04 AM |