Access 2007 and web services, connecting to data over the internet

[BillE]

Can I use web services with Access 2007 to connect to data over the
internet?

Is it better to use Sharepoint for this? I don't really understand
Sharepoint, despite reading about it a lot, so I don't know if it is a good
back end for an Access front end.

Are there other preferable ways to connect to data over the internet, like
remoting?

 

[Fred Boer]

Desar BillE:

You will probably be interested in this:

http://blogs.msdn.com/clintcovingto...database-that-uses-amazon-s-web-services.aspx

and the follow-up...

http://blogs.msdn.com/clintcovingto...amazon-web-service-data-into-access-2007.aspx


I'm spending whatever spare time I can trying to teach myself about using
web services from within Access. You can obtain a Web Services Toolkit from
Microsoft to use web APIs with SOAP...

http://msdn2.microsoft.com/en-us/library/aa192537(office.11).aspx

I think version 2.0 of the Toolkit is available from here:

http://www.microsoft.com/downloads/...0F-002A-4F5B-AF74-978F2CD6C798&displaylang=en

and version 2.01 here...

http://www.microsoft.com/downloads/...0F-002A-4F5B-AF74-978F2CD6C798&displaylang=en

I'm currently reading the following book:

Professional Development with Web APIs by Denise M. Gosnell.

It provides examples of using web services with Office programs.. I've been
able to make various demos work, but haven't as yet mastered the process....


HTH
Fred Boer

 

[aaron.kempf]

if you don't know the differences between sharepoint and webservices
then you need to take some a class and get a clue


neither one should be used; you should be using Access Data Projects

 

[A a r o n K e m p f]

you don't need web services or sharepoint

you need A c c e s s D a t a P r o j e c t s

 

[BillE]

How would adp work across the internet?
Didn't microsoft recommend not using adps?

Thanks!
Bill

 

[Douglas J. Steele]

Aaron is a known troll, for whom the only answer is ADP, regardless of the
question.

You're best off ignoring him.

 

[Tony Toews [MVP]]

How would adp work across the internet?

Through the SQL Server port 1433.

Didn't microsoft recommend not using adps?

Not really. Microsoft recommend MDBs with linked tables to SQL Server. Not the
same as recommending not using ADPs. That said ADPs haven't had any improvements in
A2007 so I certainly wouldn't start anything new in them.

And you should be advised that Aar on Kem pf's answer to every question is to use
ADPs.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Tom Wimpernark]

ADPs haven't had any improvement in 2007?

YES THEY HAVE

MDB didn't have any improvments in Office 2000, 2002 and 2003-- does that
mean that MDB has been obsolete for a decade?

oh yeah; it does mean that

 

[Tom Wimpernark]

Doug

the only answer is ADP, regardless of the question

it's such an awful diagnosis lol


ADP FOR EVERYTHING AND **** JET NEWBIES IN THE MOUTH

 

[dbahooker]

Douglas is a known troll for whom the only answer is MDB, regardless
of the question

 

[Jeff Conrad [MSFT]]

Hi Bill,

I'm interested in hearing about your scenario. Can you describe in a little
more detail what you hope to accomplish? Can you describe your application a
little bit? Size, complexity, business need, etc?

In what way would you like Access to help you here? How do you envision your
users using this application? How many users?

Thanks,
--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

 

[BillE]

Thanks for the response. Would connecting to a SQL Server backend on port
1433 over the internet be stable enough for a retained connection like this?

 

[Tony Toews [MVP]]

Thanks for the response. Would connecting to a SQL Server backend on port
1433 over the internet be stable enough for a retained connection like this?

I would think so. However I have no personal experience with connecting to SQL
Server over the Internet. I'd suggest asking in a SQL Server newsgroup for comments
on that specific question.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Tony Toews [MVP]]

Can I use web services with Access 2007 to connect to data over the
internet?

BTW do you have some specific data sources in mind? Or your own database?

Is it better to use Sharepoint for this? I don't really understand
Sharepoint, despite reading about it a lot, so I don't know if it is a good
back end for an Access front end.

Sharepoint has it's niche as a web based replacement for spreadsheets and lists and
such. But for data it is nowhere near as suitable as SQL Server. For example, it's
my understandng that Sharepoint doesn't even have relational integrity.

Are there other preferable ways to connect to data over the internet, like
remoting?

Terminal Server/Citrix or WinConnect can also work very well. The advantage to those
is that there is no need to change your app. Disadvantage would be licensing costs.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[David W. Fenton]

Would connecting to a SQL Server backend on port
1433 over the internet be stable enough for a retained connection
like this?

It would be terribly insecure, an open invitation for hackers to try
to crack usernames/passwords.

 

[Tony Toews [MVP]]

It would be terribly insecure, an open invitation for hackers to try
to crack usernames/passwords.

Now that puzzles me. What's the difference between a SQL Server userid and password
and, for example, a Terminal Server userid and password?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[SmartbizAustralia]

Linking to SharePoint lists is the simplest way.
What makes them simple is that you can use the SharePoint security and
the Way Microsoft is promoting SharePoint, it is becoming very common
on alot of Internet servers..

Web Services are also fine and alow a more traditional table setup but
require a little more work.
Most of the work here is designing some simple web services and then
hooking into them.
Once you have written your first one, the rest are easy..
The irony though is that you would use csharp or vb.net to write the
web service, so why not use asp.net all the way as it does nice things
like url parameters etc.

It all depends on what you are trying to do.

Becuase I am very accustomed to using Access, I model everything in
Access and then rewrite the prototype in Aps.net if required.

The Irony is that one can write code in either solution or as we have
done often enough, using Excel to link over the web....

Regards,
Tom Bizannes
Sydney, Australia.

 

[BillE]

All i know so far is a prospective client has an all-access application, and
they want to distribute their front end (which they like very much) and
allow all users to connect to a common database on the web. We have
recommended conversion to a vs desktop or web app, but so far they are
determined to keep their existing front end.

 

[Jeff Conrad [MSFT]]

Hi Bill,

Thanks for the extra information. Please feel free to ping me directly if
you find out any more information about the specifics. Use the contact form
at my website.

Thanks,
--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

 

[Tony Toews [MVP]]

All i know so far is a prospective client has an all-access application, and
they want to distribute their front end (which they like very much) and
allow all users to connect to a common database on the web. We have
recommended conversion to a vs desktop or web app, but so far they are
determined to keep their existing front end.

I'd have to agree with them. Why spend tens or hundreds of thousands of dollars
redeveloping a working app when you can deploy it to other remote sites using
technologies such as Terminal Server or SQL Server.

And I'd recommend Terminal Server in this situation. Which means that your employer
or corporation would make no money from them.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/