Access Linking Problem

[Scott]

Hi,

I have an Access app with 2 mdb's (FE and BE). I want to put the backend
mdb on a hosted site but cannot figure out how to link to it there. I can't
find a way to point to the hosted site/path.

Any suggestions are welcome!

Thanks

 

[Larry Linson]

in message

Hi,

I have an Access app with 2 mdb's (FE and BE). I want to put the backend
mdb on a hosted site but cannot figure out how to link to it there. I
can't
find a way to point to the hosted site/path.

Sounds as if you have high hopes of using a split Access/Jet DB across the
Internet. That is much too slow to be practical, and it's not supported. A
file-server database such as Access, where all the work is done on the
user's machine just moves too much data across the network for an Internet
connection to handle.

If your host supports/supplies VPN (virtual private network) and Microsoft
Terminal Services, you might be able to run your application entirely on the
server, from your workstation, provided they have Access or the Access
runtime installed and supported.

Larry Linson
Microsoft Access MVP

 

[aaron.kempf]

if you were using an Access Data Project; this would be a possibility.
Access MDB you can't run over the internet; over a wireless network; or
over a WAN.

Access Data Projects don't have a problem with any of the 3.

Access MDB is obsolete, www.moveon.org

-Aaron

 

[Kevin3NF]

Long time no see Larry!

Scott...it might also be good to consider moving the back-end to MSDE or SQL
Express. Depends on your host though.

 

[Scott]

Larry,

Thanks. I completely agree that this is NOT the right way to do this but
the client wanted me to test the performance before they ruled it out. Now I
have your reply to use to support my suggestion to convert the backend to SQL
Server.

Thanks,

Scott

 

[Scott]

Kevin,

I agree completely and do that in all other remote-hosted solutions.

Thanks,

Scott

 

[aaron.kempf]

what.. you guys use Access Data Projects?

it just seems like such a pain to write code to update Sql
Passthroughs; things like that.. when a simple Access Data Project is a
WORKABLE SOLUTION RIGHT OUT OF THE BOX

 

[Larry Linson]

Larry,

Thanks. I completely agree that this is NOT the right way to do this but
the client wanted me to test the performance before they ruled it out.
Now I
have your reply to use to support my suggestion to convert the backend to
SQL
Server.

Thanks,

Scott