Web-enabled database

Does anyone know if the following is true about a  web enabled Access database? Someone told me,

"This method is non platform dependant ie unix, NT and novell users can all access, update, and query the same database without needing the MS Access software."

If so, is there a way to view and test such a page offline (from a harddrive folder) on a Win95 or NT machine?
suobsAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

pspecketerCommented:
Are you speaking of using Access 2000 with web "pages" to display info?  If so, this depends on IE5.0 to display the page on the webserver.

If you are speaking of developing web pages using active server pages (*.ASP) and using IIS with FrontPage server extensions, you can easily build a site that uses ODBC connections from the server to your database.  The web page then uses SQL calls with the ADODB command or recordset object on the server.

If you have FrontPage 2000 you can create a web page that displays data and another for data entry using the database results area and using a form and submitting it to a web database.

Let me know what your after and I can give examples.
0
suobsAuthor Commented:
Access97 - not 2000.  I need to check about FrontPage version.

What I need to do is maintain a database with a large amount of data that needs to be updated often.  The data are

1) subsetted by fairly complex criteria (queries)
2) new data are entered from 2 different people (**and GET the data into the database without importing**-this is the hassel I hope to solve here)
3) new subset
4) repeat the procedure

I hope to do this all in Access without major development.

One of the parties involved  cannot access Access (Unix machine), so she cannot use Access files on her machine but can access intranet.  

One problem is satisfying myself that this will work suitably before investing much energy in it, not to mention getting server space etc.  To do this I want to save the database and asp files to my hard drive and test it, as I would with any web page before publishing it.  But I am having trouble determining what software I need to use these asp files.

Hoping for suggestions, solutions, alternatives on how to maintain a hassel-free flow of data in this situation.
0
pspecketerCommented:
The most simple way to view and enter data is to use frontpage 2000 to create your web pages.  If you purchase FP2000 and install personal web server(pws) for win98 or the Option Pack for NT you can set up a subweb inside your intranet that you own.  you then attach the subweb via frontpage to the access database, so you can create pages that use the database.  

Frontpage is cheap, and the Option Pack is free on the internet (PWS comes with win98, on the cd)

I built a database app with one data entry form and one results page in 10 minutes.  If you want to do this I can show you exactly how to create it with database results wizards and forms with submission to databases.

The other options require much more programming and you probably just want it to work as simple as possible.  The only downside to FP is that it can't do terribly complex things.  In fact in FP98 you couldn't even do this.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

suobsAuthor Commented:
Great - sounds like just what I'm looking for.  I'd be interested to see the stuff you mentioned.

I still don't understand whether I can create, look at, and test these pages prior to publishing them (use them from a hard drive, like an html document).  

I also do not get what Personal Web Server is - is it software?  What does it do?
0
suobsAuthor Commented:
Great - sounds like just what I'm looking for.  I'd be interested to see the stuff you mentioned.

I still don't understand whether I can create, look at, and test these pages prior to publishing them (use them from a hard drive, like an html document).  

I also do not get what Personal Web Server is - is it software?  What does it do?
0
pspecketerCommented:
well PWS is a win98 software that compliments the OS.  Kinda like microsoft networking allows two microsoft computers to see each other and share files, PWS allows your win98 computer to be a web server.  you then create a web site on your computer, set up the pages you want to for the database and then publish them to your intranet server.

once you get fp2000, you make a new web and create a new .asp page in that web.

to tie a database to the project web:
tools->web settings
hit the database tab and add your database to the web project.

for data display asp page:
then: insert->database->results and follow the wizard

for data entry asp page:
insert->form->text box (multiple boxes, etc.). right mouse on the form and set the properties for posting.  set the properties to database and choose the database you want(created.

you should search microsoft for asp pages and PWS for many examples.


0
suobsAuthor Commented:
I got a database table posted, thanks to you, but have not yet been able to do a data entry page that makes sense.  Your instructions for this are a bit vague - there is no choice in the dropdown for "multiple boxes" and its not clear which properties you are saying should be set.

Part of the problem is that I'm not sure what the end result should be.  Can I produce a table that will accept new data and changes?  Can I produce an Access-type form that will do the same?  When I create a text box, I end up with a little box on the page that lets me enter one piece of data - I do not see how to make this work with a multiple field database for data entry, or how to see changes to the table on the screen.
0
pspecketerCommented:
sorry, I was generalizing.  you need to create a form that acts as the user interface.  you can add text boxes(single or multiline), check boxes, options, pull downs, etc. you do this for each and every field (no shortcut)

once you have accounted for all the fields you wish to input to the database then you set the properties on the form to tie to the database.

There are other methods of presenting the data using ActiveX table controls, but that is less simple.  when you get this working, you can investigate better tools to do the job.  Visual Interdev has a great form manager that makes interacting with a database on the web a simple prospect.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.