how to bring dbf on-line?

[dumdum2]

I'm not sure if I should be posting this question here, but here goes......I'll try to simplify it also.

We have an Access 2000 database on an in-house Windows 2003 Server network. We'd like to:

1. be able to share this database with our NY office (across a VPN has been too slow)

2. allow data entry from internet users (ie enter application information), so staff does not have to type in all the information.

I do not know where to begin to accomplish our goals. Can anyone suggest a starting point??

Thanks!

 

[Remou]

This may be of interest to you:
How to use an .mdb online?
thread181-946538

 

[abaldwin]

Have you thought about using Terminal Services for the external folks to log into and access the db? LAN users would be no change, External users would effectively become "LAN" users by virtue of using a TS.



Andy Baldwin

"Testing is the most overlooked programming language on the books!"

Ask a great question, get a great answer. Ask a vague question, get a vague answer.
Find out how to get great answers FAQ219-2884.

 

[fneily]

I've set up data entry and data access across the internet to an Access database for my state's transportation department using Data Access Pages (DAP's).
See:
How to deploy data access pages over the Internet

http://support.microsoft.com/?kbid=264080

Also, a quick and cheap way would be to set up a Citrix server (

http://www.citrix.com)

and let your users login remotely to a single database. Avoids any new coding you'll have to do.