Software

Ask something
Question Locked

Remote access to an MS Access database on a desktop machine

0 helpful
8 replies

by cisco124

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am in the process of designing an Access 2000 database for a small business (Garden Design).
The database is installed on a desktop machine at the business premises.

How can I set it up for remote (Internet) access by 1/2 users?

I'm doing well with the database design, but have no experience of this sort of deployment.

Any help would be greatly appreciated.

Dominic

8 replies

by p.j.hutchison

First you need to configure the folder where the database is as a share so others can access it.
Then for shared access, you need to set up a workgroup and add users (in Access 2003 its in Tools, Security, Workgroup Administrator). The System.mdw should also be stored in the share as well so all users can access it.

by cisco124

Hi, P.J.
Thanks for your reply. It has been helpful.
However, I need to set it up for 1-2 users to access the database on the Internet.
Can I do this?
I am using Access 2000 and Windows XP Pro installed on one desktop machine.

Dominic Rocks

by jdmercha

You need a web server that is on the Internet. This can be one of the desktop PCs. Then you need to build a web site using ASP.

by cisco124

Thank you for your reply, jdmercha.
The small company the database is for have a website hosted on an ISP.
When I was at college we touched on ASP (I mean touched!).
Can we host a website on a desktop PC?
I know I could build Data Access Pages and load them onto the existing website. the problem is time. They want it finished quick.
I've been following the 'Remote Access' post here and have been thinking of using Radmin or a similar program.
Any other suggestions?
Dominic

by susan1979

PC Anywhere to access the system?

For a situation where only 2 people are accessing the system, just seems like it would be more cost effective than another system, web page, etc.

by luckysoft

Dear,
I need your halp in MS Access, i have make the Database but i want to run the .exe setup file and Desktop application, no any budy permission to change any thing in this project,

Liaquat Ali,
IT Manager
Pakistan

This discussion is closed to new replies.