LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 983
Default Is this possible Yes or no.

Sure it's possible. It is also possible to build a barn using a butter knife
instead of a saw. It takes longer and there will be a lot more tradeoffs, but
it can be done. Even with only one license (on your machine of course) for
Access you can allow everyone to read and write to a database via ADO
recordsets. This is what my company does and it is very effective. What you
are proposing will run you into concurency issues and a whole host of other
difficulties which will cost the company far in excess of the value of the
software. Sometimes saving money is very expensive in the long run (and I am
an accountant).

HTH

"Pete" wrote:

Many comments on this one if possible.

The place I work for is a large corporation; the
licensing of the software has to be spot on. They are
too tight to pay for Microsoft access on every machine
and because of its synchronisation and replication system
they choose to use Lotus Notes domino for communication
and database purposes. I don't know Lotus Script. They
use excel for on sheet data manipulation. Word is also
licensed on the machines. I have been thinking that if I
would like to come up to a solution to the problems in my
area I need an Access database. I cannot have money to
do this though. Could I set up excel as a database with
combo boxes for selection and entry on one sheet and
predefined cells for data on another. I could use word
for reporting. I could write sql statements to run
queries if the data was in a regular order.

Am I right in what I am thinking?


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 11:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"