Can I put an exsisting database on a website

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[Larry Linson]

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
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
(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

 

[Gary Walter]

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.

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.

 

[Guest]

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

 

[lake2212]

I have a question. I have 2 people at 2 other locations that I would like to
share a database with. I would also like them to be able to update the
database and run reports. If I use something like GoToMyPC for them, do they
have to have a copy of Access on their remote location computer? This is all
very new to me. Thanks.
Julie