accessing Access DB from multiple sites

Hi,

I've been asked to look into how to setup so multiple users can work on an Access 2007 DataBase, in several locations at once. Please can anyone suggest anything? I have a website hosted on SiteGround but they don't suport Windows I Googled for ages this morning and found some references to Microsoft SharePoint Services but I don't know if this is what we need.

any advice gratefully received!

thanks

 

We use a Citrix server to share an Access97 / VB6 database "Quote" system.

 

Hi foogoo,

thanks I will look into Citrix - not something I'm familiar with - do you have a local Citrix server or are you hosting on a Citrix server on-line? Can I also check what you mean by ' "Quote" system'? Sorry but I'm coming from a point of total ignorance here!

thanks!

 

We have a Citrix Farm setup. The Farm server controls 2 other Citrix boxes in the company. But the local Citrix server at my location hosts the quote system for our sales group. The quote system was written in VB6 and stores everything in an Access database. Using Citrix allows multiple terminal sessions so multiple users can use the program at once. I don't know our version of Citrix Presentation Server, but now days it is called something else, but I'd guess it works the same. I'm sorry I don't know the nuts and bolts, it was setup before I got here, now I just muttle through supporting it day to day.

I talked a little about this in another post where a user wanted to share an app to multiple connections.
Like I told them you may look into 'terminal services' and see if the is another soultion.