Access or Excel: should I create a access database or keep the exc

[sam]

Hi,

I have a huge excel sheet with links that navigate user to different
documents (word, PDF, etc.)

My Question is:
Is it advisable to migrate to access database?

I also want to create forms (accessible by others over intranet site) in
access (or excel) using macros that would be filled by others and the details
filled would populate the access database (or excel sheet), the forms filled
by others would be available on an intranet site and will have accept and
decline button. If I click accept, it will populate the database (or excel
sheet) with the corresponding cells in the database (or excel sheet). If I
click decline, it will still populate the database (or excel sheet), but will
also set a status of declined in the database (or excel sheet).

Which tool will be more compatible with my requirements? Microsoft Access or
Excel? The forms that I am talking about should be created using macros. It
this possible?

Thanks in Advance.

 

[BruceM]

It is hard to say what will work better without knowing something about the
data you want to capture. Access is a relational database program that lets
you create an Access application. It is not a spreadsheet on steroids, but
rather an entirely different way of managing data. In Access you start with
the structure (tables and relationships), after which you create forms and
reports. An Access form is the user interface to the data stored in tables.
It is not a standalone object in the same way as an Excel spreadsheet.

What is the purpose of the macros? It is almost as if you are starting with
the idea that you need to use macros rather than using macros to solve a
specific problem. In any case, an Event Procedure using VBA may be a better
choice than an Access macro. It is certainly more flexible.

 

[Maarkr]

Add a Sharepoint server and MOSS 2007

 

[BruceM]

That doesn't address the OP's question about whether to use Access or Excel.

 

[sam]

Bruce,

I have an excel sheet that is edited, updated by two other people as well.
Now in excel only one person can edit at a time which wastes a lot of time.
So I was looking for something that can be edited, updated by multiple people.

ALso I want it to be password protected. Where only myself and one more
person can edit and others will have a view permission only.

Do you know if this is possible in Access? Also in future I want to create
some forms where certain fields are mandatory. the input in these forms will
populate the corresponding cells in the table in access database.

I hope I made it clear.

Thanks in Advance.

 

[BruceM]

Yes, what you seek is possible in Access, but it is beyond the scope of a
newsgroup exchange to describe how to put it together. Access is very
versatile and powerful, but there is a pretty steep initial learning curve.
This link is to a very good tutorial about Access basics:
http://allenbrowne.com/casu-22.html

More links:
http://www.allenbrowne.com/tips.html
http://www.allenbrowne.com/links.html
http://home.att.net/~california.db/tips.html#aTip1

How you protect the data depends in part on which version of Access you are
using, but you need to build the application before you can apply security.
First things first.

 

[Tony Toews [MVP]]

Add a Sharepoint server and MOSS 2007

Sharepoint has many limitations.

Tony