Entry

How do I connect Access to FP2K. I've installed the server extentions and the PWS. I can't seem to use the 'web settings' and 'database' options

Jan 2nd, 2002 06:19
Suban Asif, tansar hussain, suban_asif@indiatimes.com

First you check whether PWS is running. If it is then create a new web 
in FP2k from "File", "New", and "New Web".In the dialog box which 
appears type the name of you web as "http://localhost/yourname" or 
"http://MyMachine/MyName" and Click "ok".That's it, Nothing.
Using Access DB is pretty easy. Just go to insert menu and choose 
database. But before that you need to create database connection, in 
your web.Open your web in FP2K .On the Tools menu, click Web Settings, 
and then click the Database tab: To create a new database connection, 
click Add, and then follow the appropriate procedure to create a new 
database connection to a file or folder in the current web.
Now go to Insert menu, select Insert Database, and choose the database 
connection you created above.Then select the table and click next. 
follow th rest of wizard dialog boxes. After the wizard, completes you 
will see a HTML table created in your asp page, with field names of your 
tables. and, Bingo!