If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Microsoft Access > Urgent... I need to put an Access Database online

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Sep 2004
Posts: 5
Exclamation Urgent... I need to put an Access Database online

Hi guys.

I have an Access Database which has switchboards and user-friendly forms. I want to put it online on my web server so that 3 - 5 users can use it.

The problem is when when i put it online and somebody clicks on the database to open it, its gets downloaded to their computer.

I need to know how to make changes to the database while it is still online. I do not want to use web based technology.

The link to the database will be something like this: www.mywebserver.com/mydatabase.mdb

Please help me out!!!

Regards,

Prasad
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Feb 2004
Location: Chicago, IL
Posts: 1,312
If you don't want to use web technologies then you will have to use networking technologies. I would look into setting up a VPN or using Terminal Services. I know enough to know that these technologies exist, but I have never had to set them up.
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Nov 2003
Location: Sussex, England
Posts: 404
OnLine?

If you want to share your database via a browser front end (the web) you're in the wrong place. You need a web base front end for which you can use Active Server Pages (.asp), PHP (er .php) or .net (Spawn of Satan) each of which is capable of connecting to your database on the server and allowing miltiple users to access it. ASP might be the easiest be in this respect as the language is slightly simlar to vba.

It sounds, thought like you want to share across a network. To do this split your database into a front end (Forms, Reports, queries etc) and a back end (tables).

Put the back end on the main server and copies of the front end onto the other machines. Link the tables from the front end to the back end (in the menu get external data > link tables).

That's putting it very simply and missing out a few steps, but it's basically the way to go.

Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On