By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,962 Members | 1,791 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,962 IT Pros & Developers. It's quick & easy.

How to use Access with Web Services?

P: n/a
I have a number of users with the same Access app on each of their laptops.
When users have internet access, they want to be able to synchronize records
in their individual databases with a main server so they can share or update
particular "public" records. So I want to create a web service that gives
them this "sometimes connected" functionality and the ability to designate
"public" and "private" records.

Can Access do this? Do I have to rewrite in .NET to get this kind of
functionality?

The nice thing about the current mde's is they are easy to back up and give
users a sense of ownership - which is important because everyone is very
possessive of their data. Even if it was a .NET app, I would need to use
MSDE - which does not offer any advantage over Access as far as I can see.

Has anyone done anything like this with Access?

Thanks in advance.
Nov 13 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Google on Web Services Toolkit for Office

Unfortunately, I did not have much luck with it, so I wrote a dll in
..Net and registered it for COM interop. Works great on Windows XP,
still can't make it work on Win 2000 (working on it).

What you describe above sounds like Smart Client. Maybe google that as
well for ideas.

Johnny

Nov 13 '05 #2

P: n/a
For a limited number of users on internet, Windows Terminal Services is all
you need.

"deko" <de**@deko.com> wrote in message
news:PO***************@newssvr21.news.prodigy.com. ..
I have a number of users with the same Access app on each of their laptops. When users have internet access, they want to be able to synchronize records in their individual databases with a main server so they can share or update particular "public" records. So I want to create a web service that gives
them this "sometimes connected" functionality and the ability to designate
"public" and "private" records.

Can Access do this? Do I have to rewrite in .NET to get this kind of
functionality?

The nice thing about the current mde's is they are easy to back up and give users a sense of ownership - which is important because everyone is very
possessive of their data. Even if it was a .NET app, I would need to use
MSDE - which does not offer any advantage over Access as far as I can see.

Has anyone done anything like this with Access?

Thanks in advance.

Nov 13 '05 #3

P: n/a
"deko" <de**@deko.com> wrote in message
news:PO***************@newssvr21.news.prodigy.com. ..
I have a number of users with the same Access app on each of their laptops.
When users have internet access, they want to be able to synchronize
records
in their individual databases with a main server so they can share or
update
particular "public" records. So I want to create a web service that gives
them this "sometimes connected" functionality and the ability to designate
"public" and "private" records.

Can Access do this? Do I have to rewrite in .NET to get this kind of
functionality?

The nice thing about the current mde's is they are easy to back up and
give
users a sense of ownership - which is important because everyone is very
possessive of their data. Even if it was a .NET app, I would need to use
MSDE - which does not offer any advantage over Access as far as I can see.

Has anyone done anything like this with Access?


I have a couple of apps that our field people use as local databases and
they use HTTP requests to submit and retrieve data from our corporate
database. The requests are handled by Java servlets on our web servers and
the data is sent back and forth as XML.

Works well but each request for submission or retrieval has specific
programming set up for it on both ends so it was not trivial to implement.
Nov 13 '05 #4

P: n/a
> I have a couple of apps that our field people use as local databases and
they use HTTP requests to submit and retrieve data from our corporate
database. The requests are handled by Java servlets on our web servers and the data is sent back and forth as XML.

Works well but each request for submission or retrieval has specific
programming set up for it on both ends so it was not trivial to implement.


Perhaps I could have users could log into a site that uses Office Web
Components and click "check for updates" - like Window Update - to get a
summary of records to be synchronized with the central database - records to
be either uploaded or downloaded.

Can OWC can automatically update and pull records from a local MDE like
this? Would an Access Add-In be a better way to take care of the connection
to the site (or web service)?

As far as I can see, there's no advantage in rewriting the app in .NET. I'd
have to reference all the COM-based VBA object libraries for Office
automation (the app does a lot of Office automation), and I'd have to use
MSDE which also has a 2Gb limit. How is this better than Access?
Nov 13 '05 #5

P: n/a
"deko" <de**@deko.com> wrote in message
news:du*************@newssvr13.news.prodigy.com...
Perhaps I could have users could log into a site that uses Office Web
Components and click "check for updates" - like Window Update - to get a
summary of records to be synchronized with the central database - records to
be either uploaded or downloaded.

Can OWC can automatically update and pull records from a local MDE like
this? Would an Access Add-In be a better way to take care of the connection
to the site (or web service)?

As far as I can see, there's no advantage in rewriting the app in .NET. I'd
have to reference all the COM-based VBA object libraries for Office
automation (the app does a lot of Office automation), and I'd have to use
MSDE which also has a 2Gb limit. How is this better than Access?


You misunderstood. My app is an Access app, not a dot net app.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.