Main > Everything Else

Database sharing

<< < (2/3) > >>

mpm32:
I have lots of Access Programming experience. i.e. VB
A little networking
A little web.

I think there will only be 5 or so tables.
   An ID table that contains the records
   A notes table that holds session notes
   A location code table
   A password table that would store the login ID.
   A couple of TBD tables that may hold report data etc.

At work here it's easy for me because I just put it on a shared drive if small, or on citrix if it's a larger db with many users.

I want to branch out and do some dbs for small businesses on the side.  If it was at one location I wouldn't have an issue, or if they had a network.

But they do not and they want to be able to use it from 3 locations.  I think they only have one PC at each location.

I was thinking of getting a small server to put it on rather than an outside hosting vendor.  Then I'd have to figure out a fee for hosting it for them, which would be less than the hosting service or built into my maintenance plan.  Not sure how hard that would be for me to set-up but I think I would be able to figure it out.

Matthew Anderson:
Well, it feels like you want to learn or at least ASP.net and IIS and use Access as your backend (or maybe SQL Server express)

But it is a lot of work especially making the gui.


So the user could login to your www site and do all the lookups and changes.

Of course if you have the bucks you could set up a Citrix desktop.

Anyone out there have a better idea?

Sounds like he needs a solution for 3 remote desktops all trying to access and update the same information without any dedicated links between them.

mpm32:
If I have a server, could I set it up so that the users would see their folder like a shared drive?

ark_ader:
You would be better off making Access your front-end with an Oracle back-end.

This is not hard to do, and you can get Oracle Express free so your cost would be lower.

You can then distribute the database to all sites link them up and then do incremental runs throughout the day.  :cheers:

stace:
+1 for MySQL  :applaud:

Navigation

[0] Message Index

[#] Next page

[*] Previous page

Go to full version