Can I put an exsisting database on a website

#1 (**permalink**) 28-Jul-2006, 08:18 AM

I need to make an exsisting database accesable to other offices. Can this be
done by putting on a web page? If so How? I'm using Access 2003

*

#2 (**permalink**) 28-Jul-2006, 08:18 AM

I think is better to share the Access Data Base putting it in a shared drive.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11186-can-i-put-exsisting-database-website.html
so many people can access to your aplication.

LD

--
Lorenzo DÃ*az
Cad Technician

"stillb" wrote:

> I need to make an exsisting database accesable to other offices. Can this be
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11186
> done by putting on a web page? If so How? I'm using Access 2003

#3 (**permalink**) 28-Jul-2006, 08:18 AM

The other offices are in diffrent parts of the country and possibly overseas.
Does this change things?

"ldiaz" wrote:

>
> I think is better to share the Access Data Base putting it in a shared drive.
> so many people can access to your aplication.
>
> LD
>
> --
> Lorenzo DÃ*az
> Cad Technician
>
>
> "stillb" wrote:
>
> > I need to make an exsisting database accesable to other offices. Can this be
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11186
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11186
> > done by putting on a web page? If so How? I'm using Access 2003

#4 (**permalink**) 28-Jul-2006, 08:19 AM

Of course it does, and even if they were in the same city, unless they were
on a high-speed Lan, Lorenzo's solution would not apply. There are several
ways that you can share the _data_, but all of them require a different user
interface. Data Access Pages, because of their limitations, are useful only
for simple access on intranets (and it has been stated that they will be
"deprecated" in the next version of Office), FrontPage 2002 or 2003 with the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11186
Data Interaction Wizard can also provide Read and Write access of a very
simple nature (but the FrontPage product is being dropped with the next
version of Office), there are third-party products such as ColdFusion that
can work with the Tables of an Access database with a re-written user
interface; Microsoft's ActiveX Server Pages .asp pages and the newer ASP.NET
can use Access tables but also require a complete rewrite of the user
interface. Only with advanced features of the .NET environment could you
begin to approach the richness of interface provided by Access itself.

A possible alternative is to use "remote access" software and allow the
remote users to run on your local machine. This can range from simple
products such as Reach Out, or PC Anywhere, which can be very slow over an
Internet or dialup connection to more advanced Virtual Private Networks
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11186
(VPN) supporting Microsoft Terminal Server or Citrix MetaFrame. In this
case, too, the remote users would actually be running software on your local
machine.

Larry Linson
Microsoft Access MVP

"stillb" wrote
> The other offices are in diffrent parts of
> the country and possibly overseas.
> Does this change things?

> "ldiaz" wrote:
>
>> I think is better to share the Access Data
>> Base putting it in a shared drive.
>> so many people can access to your aplication.
>> Lorenzo Díaz

>> "stillb" wrote:
>>
>> > I need to make an exsisting database
>> >accesable to other offices. Can this be
>> > done by putting on a web page? If so
>> > How? I'm using Access 2003

#5 (**permalink**) 28-Jul-2006, 08:19 AM

"stillb" wrote:
> The other offices are in diffrent parts of the country and possibly
> overseas.
> Does this change things?
>
Here *might* be a solution that has worked for us....

If you could dedicate a local computer for each
of your distant users, GoToMyPC has worked
well for us.

A valuable woman at our company had a "life change."
Actually, it was her husband, who quit academic life
and became a "horse whisperer" teacher. They go to
Colorado in the summer, and Florida in the winter.

She has her own regular, local computer at our company
which she uses when she is in the office.

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11186
All our Access dbs are split, with backends on a server
and each user getting a frontend on their computer.

Where ever she goes (she was up in Maine recently to
help her son and his wife who are expecting), she finds
*any* Internet connection, goes to GoToMyPC's website
and *securely* logs in to her computer here.

She ends up using her office computer like she was
sitting here in front of it.

The connection is initiated through common https so
nobody has to have any special ports open.
No router/firewall impediments so far.

And we don't have to worry about one more
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11186
Citrix/Windows 2003 server needing patches to
correct one more vulnerablility (and will this patch
break our server). It's all handled by Citrix people
at GoToMyPC.

Sure, we pay for the service (whereas an alternative
such a Himachi might be free), but we gladly pay the
small yearly fee to know she will always be able to
connect securely anytime, from anywhere.

She has mostly had broadband available to her, and
the Access db's perform just like if she were there in
the office.

Plus, she's an off-hours MAC freak and she gets to use
her new core-duo MacBook to run her office Windows
machine.

While not applicable to your case, she also does not
have to worry about synching Outlook!

As far as dial-up performance, I also have an account
and will connect in from my home dial-up (~44 Kbps)
sometimes to do db maintenance early in the morning,
or if they need something run /changed while I am at
home coding. There is a very-slight sluggishness when the
screen updates in Access, but not disagreeably so.

It has been a God-send for us.

#6 (**permalink**) 28-Jul-2006, 08:19 AM

Thanks Gary,
I will look into this and see if it will work for us to.
again thanks
Bill

"Gary Walter" wrote:

> "stillb" wrote:
> > The other offices are in diffrent parts of the country and possibly
> > overseas.
> > Does this change things?
> >
> Here *might* be a solution that has worked for us....
>
> If you could dedicate a local computer for each
> of your distant users, GoToMyPC has worked
> well for us.
>
> A valuable woman at our company had a "life change."
> Actually, it was her husband, who quit academic life
> and became a "horse whisperer" teacher. They go to
> Colorado in the summer, and Florida in the winter.
>
> She has her own regular, local computer at our company
> which she uses when she is in the office.
>
> All our Access dbs are split, with backends on a server
> and each user getting a frontend on their computer.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11186
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11186
>
> Where ever she goes (she was up in Maine recently to
> help her son and his wife who are expecting), she finds
> *any* Internet connection, goes to GoToMyPC's website
> and *securely* logs in to her computer here.
>
> She ends up using her office computer like she was
> sitting here in front of it.
>
> The connection is initiated through common https so
> nobody has to have any special ports open.
> No router/firewall impediments so far.
>
> And we don't have to worry about one more
> Citrix/Windows 2003 server needing patches to
> correct one more vulnerablility (and will this patch
> break our server). It's all handled by Citrix people
> at GoToMyPC.
>
> Sure, we pay for the service (whereas an alternative
> such a Himachi might be free), but we gladly pay the
> small yearly fee to know she will always be able to
> connect securely anytime, from anywhere.
>
> She has mostly had broadband available to her, and
> the Access db's perform just like if she were there in
> the office.
>
> Plus, she's an off-hours MAC freak and she gets to use
> her new core-duo MacBook to run her office Windows
> machine.
>
> While not applicable to your case, she also does not
> have to worry about synching Outlook!
>
> As far as dial-up performance, I also have an account
> and will connect in from my home dial-up (~44 Kbps)
> sometimes to do db maintenance early in the morning,
> or if they need something run /changed while I am at
> home coding. There is a very-slight sluggishness when the
> screen updates in Access, but not disagreeably so.
>
> It has been a God-send for us.
>
>
>
>