Posting from Access form to a website database

  • Thread starter Thread starter Mark A. Sam
  • Start date Start date
M

Mark A. Sam

Can anyone direct me as to how I can post from an Access form on a local
machine to a website database? Is such a thing possible?

Thanks

Mark A. Sam
 
What do you mean by website database. Would it be a
database on an intranet or server within your company, or
on the internet.
 
Ted,

It would be on the internet. I want to distribute an Access DB so the
companies can post to my website without using webforms. Right now I am set
up to receive files and an setting up an Access db which will send me files,
but if I can post directly it would relieve me of having to process the
files.

God Bless,

Mark
 
Mark A. Sam said:
Ted,

It would be on the internet. I want to distribute an Access DB so the
companies can post to my website without using webforms. Right now I am set
up to receive files and an setting up an Access db which will send me files,
but if I can post directly it would relieve me of having to process the
files.
Click to expand...

I do this by converting the data to XML and submitting it to a URL with an
HTTPRequest using the MSXML.DLL library. On the web server I have a Java
servlet that handles the request, parses the XML, and then inserts it into
my database. I'm using SQL Server, but I see no reason why you couldn't do
the same using an Access data file.
 
-----Original Message-----
Ted,

It would be on the internet. I want to distribute an Access DB so the
companies can post to my website without using webforms. Right now I am set
up to receive files and an setting up an Access db which will send me files,
but if I can post directly it would relieve me of having to process the
files.

God Bless,

Mark
Click to expand...
Hi Mark,
have you considered using front page? it has the ability
to create web forms that are connected to an access
database.

Luck
Jonathan
 
Jonathan,

The site already has webforms, Active Server Pages. This method is ok it
you have a few entries to make, but I am looking for thousands of entries to
me made, hundreds from come companies per day, and will need a better
interface. Access will privide that.

God Bless,

Mark
 
Back
Top