A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Access Services?? Accessing DB from web??



 
 
Thread Tools Display Modes
  #1  
Old March 8th, 2010, 04:41 PM posted to microsoft.public.access.tablesdbdesign
Doctor
external usenet poster
 
Posts: 75
Default Access Services?? Accessing DB from web??

Could someone explain to be the workflow/possibilities of Sharepoint or other
Access services? Please forgive me, in advance, if I do not get all my
terminology right on this subject.

I continue to read things about Sharepoint and Access Services that hint at
what I would like to do, but I don't quite understand what they do or how
they intergrate into Acess or if they will for sure be a solution.

Do any of these services make it possible for users to access a database
from the the internet? If not is there a way to do this without building a
php or asp based website to access the data?

I understand that Access can connect to a mysql database, but can it connect
to one that is on a web server? Am I even asking the right questions?

Thanks.
Ads
  #2  
Old March 10th, 2010, 07:44 PM posted to microsoft.public.access.tablesdbdesign
Maurice
external usenet poster
 
Posts: 1,585
Default Access Services?? Accessing DB from web??

You have a lot of different questions let's see:

Access services relies on sharepoint technology and therefore you need
sharepoint technology to access the database via IE. But read the database is
accessed via a secure environment within sharepount. Once you have an
environment like that it's possible to access a database created with access
via sharepoint. You can work on and offline. The datamodel of the db has to
be fairly straight and sometimes you might even have to think outside the
normalization box :-)

You can use Visual Studio express for creating a front end and use an Access
backend with the data. VS Express can be downloaded from MS site.

You can connect to a mysql database on a webserver, that's all a question of
making the right connections and securitysettings for connecting to that
webserver.

But as you stated there is a lot out there so first figure out what you are
looking for and then decide what best fits the occation. From there on ask
the questions in the appropriate NG. It might take some time to get your
ideas into something productive so take your time.
--
Maurice Ausum


"Doctor" wrote:

Could someone explain to be the workflow/possibilities of Sharepoint or other
Access services? Please forgive me, in advance, if I do not get all my
terminology right on this subject.

I continue to read things about Sharepoint and Access Services that hint at
what I would like to do, but I don't quite understand what they do or how
they intergrate into Acess or if they will for sure be a solution.

Do any of these services make it possible for users to access a database
from the the internet? If not is there a way to do this without building a
php or asp based website to access the data?

I understand that Access can connect to a mysql database, but can it connect
to one that is on a web server? Am I even asking the right questions?

Thanks.

  #3  
Old March 11th, 2010, 07:08 PM posted to microsoft.public.access.tablesdbdesign
Doctor
external usenet poster
 
Posts: 75
Default Access Services?? Accessing DB from web??

Maurice,
Thanks so much for your responses. Yes, I'll clarify my desire.

I would like for users who are traveling around the country to be able to
access the same data from wherever they are. Right now, these users "package"
the BE to take with them, but when they do so, it is read only until they
connect to the BE on the network.

Do the afore mentioned microsoft services make it possible to put the BE on
a microsoft serve, then allow users to continue to use the currect FE to
access it?

Kind regards,
Doc
  #4  
Old March 13th, 2010, 09:48 AM posted to microsoft.public.access.tablesdbdesign
Maurice
external usenet poster
 
Posts: 1,585
Default Access Services?? Accessing DB from web??

It most certainly does, seeing it i was impressed because it's also possible
to create an interface on the site. So when logging in it is not even
necessary to have a client fe on the client pc. But remember for this to work
properly you do need sharepoint 2010 to get it up and running. My god am i
advertising here? pls don't see it like that it's just my enthousiasme :-)
--
Maurice Ausum


"Doctor" wrote:

Maurice,
Thanks so much for your responses. Yes, I'll clarify my desire.

I would like for users who are traveling around the country to be able to
access the same data from wherever they are. Right now, these users "package"
the BE to take with them, but when they do so, it is read only until they
connect to the BE on the network.

Do the afore mentioned microsoft services make it possible to put the BE on
a microsoft serve, then allow users to continue to use the currect FE to
access it?

Kind regards,
Doc

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:33 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.