Sharing a Database

Status
This thread has been Locked and is not open to further replies. The original thread starter may use the Report button to request it be reopened but anyone else with a similar issue should start a New Thread. Watch our Welcome Guide to learn how to use this site.

tomlunt

Thread Starter
Joined
Feb 9, 2001
Messages
803
Hi -

I have been asked to create a database for our small company. Nothing too serious - contacts primarily, and links to some scanned in .pdf files (old tax returns, meeting minutes, stuff like that). I think it would be pretty easy, except we eventually need to share the info with different people in different locations around the country.

I have MS Access, but no one else does. I don't really want to have to buy Access for 10 people (kind of expensive) and would prefer a web-type solution if possible. This is where my experience drops to nothing. (I looked at OpenOffice - Base, but it doesn't look very good for designing the forms i will need (it uses OpenOffice Write to create forms)).

I can create a database on my computer, probably starting with one of the MS templates. I think i can eventually create the appropriate forms and reports, and link stuff together appropriately.

Where my experience stops is what to do next. How do i share the database with other people at different locations? Do I need a server? what kind of software? something web-based? My budget tops out at $1,000 (or so).

Any suggestions you can provide to get me headed in the right direction would be greatly appreciated. Thanks in advance.

Tom
 

Anne Troy

Anne
Joined
Feb 14, 1999
Messages
11,751
What kind of web hosting do you have? PHP/MySQL hosting generally comes with free installable software. For instance, my clients get something called Fantastico, which comes with many scripts that automatically install software onto your server.
http://cpanel-host.com/fantastico/
Easily, for $1000, you should be able to have someone at www.rentacoder.com customize one of those softwares to suit your needs.
 

tomlunt

Thread Starter
Joined
Feb 9, 2001
Messages
803
Anne Troy said:
What kind of web hosting do you have? PHP/MySQL hosting generally comes with free installable software. For instance, my clients get something called Fantastico, which comes with many scripts that automatically install software onto your server.
http://cpanel-host.com/fantastico/
Easily, for $1000, you should be able to have someone at www.rentacoder.com customize one of those softwares to suit your needs.
Anne -

Thanks for the info. I'm not even sure what kind of web hosting we currently have. Someone else in my company was in charge of that (I'll call him next week and find out).

I like the idea of Rentacoder .... i was wondering where i would turn to get some help.

Is there any way i can take an Access database and make it available on the web (with usernames and passwords)?

Tom
 

Anne Troy

Anne
Joined
Feb 14, 1999
Messages
11,751
Sure, Tom. Here's the thing...

If you use an Access database, you'll likely need ASP programming on a Windows server. Yuk. You're talking more expensive programming required. PHP programmers are generally much cheaper 'cause it's open source.

Without programming, each user has to have Access installed...
 
Status
This thread has been Locked and is not open to further replies. The original thread starter may use the Report button to request it be reopened but anyone else with a similar issue should start a New Thread. Watch our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top