Need advice on access database with FrontPage or SharePoing Design

[George]

I need a simple example of taking data from a web form and writing it to a
MS access database. I manage to link a database, and can list it browse it
and update it from a browse withdow, but can't find an example of just taking
user data and putting it into a form.

Can someone point me in the right direction? It's user identification, so
the data needs to be kept secure.

I'm using Sharepoint Designer, but can switch to FrontPage

 

[Wayne-I-M]

You can import the on-line DB onto your machine or any hard drive that you
can get to - thats any hard drive the you can define a "path" to.
eg
C:
D:
E:
etc
etc.


Once you have the DB on the hard drive you can either use it were t is (big
mistake if you do - but you "can" if you want). Be warned that this will
bloat your on-line file size. You really should just import the data into an
other database that is seperate from the on-line one.

You can use this as an example


I have given a step by step in another post so if you look at this it should
give you all the info you need. If you're sure about TabeDefs then just copy
the code and change the name to what you normally use.

http://groups.google.com/group/micr...8/8736182d9b1c59de?lnk=st&q=#8736182d9b1c59de

The VBcode is more access then FP so if you have problems, you could post to
the access forum and you will answers there.

Hope this helps

 

[George]

Thanks Wayne. This is a big help.

One thing I'm confused about: how do I get to the "on Click" event on th
ebutton? I can't find events in the button form properties? I assume you mean
a button created in FrontPage.

 

[Wayne-I-M]

No the button is on the access form. You can import the DB from frontpage
(just log in and publish "from" on-line "to" off-line)

After the DB is on your hard drive - or where ever just open access and
click the button.

I use this all the time for on-line booking forms.