suobs
asked on
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?
"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?
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?
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?
ASKER
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?
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?
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.
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.
ASKER
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.
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.
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.
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.
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.