A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Using Database instead of Excel



 
 
Thread Tools Display Modes
  #1  
Old March 3rd, 2006, 02:58 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default 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  
Old March 3rd, 2006, 09:26 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default 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  
Old March 3rd, 2006, 09:43 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default 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  
Old March 4th, 2006, 03:40 AM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default 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  
Old March 6th, 2006, 04:17 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default 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  
Old March 8th, 2006, 09:21 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 10:19 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.