Access + FrontPage web based/updated db...

[SQLBI]

Hi,

I've been asked to develop an Access DB to updated via a FrontPage wesite.

Now creating the db and the site are not a problem for me, however this will be the first time i've linked the 2 together and was wondering if anyone had any tips/tricks or experiences that they'd like to share. Especially any pitfalls that are likely to catch me out.

Thanks in advance.

Leigh Moore
Solutions 4 MS Office Ltd

http://www.solutions4msoffice.co.uk

 

[JoeEskimo]

If you use the Database wizard in frontpage to design your forms, you will find that when you wish to make changes that MS has coded the forms so changes are difficult.

I suggest Peter Nortons book on VB6 and reviewing the ASP/vbscript portion for connecting to database. Very helpful and you can use your FrontPage to wrikte the ASP code.

 

[SQLBI]

Joe,

What about Data Access Pages...?

Had a little play with them and they seem straight forward enough.

Am i correct in saying that there would need to be an instance of the db on the Web Server and another one linked to it on the clients local machine?

Thanks,

Leigh Moore
Solutions 4 MS Office Ltd

http://www.solutions4msoffice.co.uk

 

[nell1]

Hi Leighmoore,

Connecting to an access db via a website is pretty straight forward. Never used FrontPage myself so ignore me if this is of no use, have always hand coded the connections using ASP etc...

You can set up a system DSN, connect via ADO and manipulate the data how you want. Would you like me to post some example code?

Nell1

 

[SQLBI]

Nell1,

I can use ADO to create/manipulate recordsets using VBA/VB quite effectively, but if you feel you have any code that may be useful, fell free to let me have it, either here or by email. (Via website below.)

Thanks for you help.



Leigh Moore
Solutions 4 MS Office Ltd

http://www.solutions4msoffice.co.uk