Link to home
Start Free TrialLog in
Avatar of bfuchs
bfuchsFlag for United States of America

asked on

Splitting Database Users

Hi Experts,

We have an in place Access 2000/2003 FE Application that is currently linked to 50% SQL BE and the other 50% is still in Access BE.

Now management wants to split users to work in 2 locations, its a few blocks distance from one to the other.
What is the best way to organize that in terms of software development\architecture  regarding performance?

(Our IT guy claims that it would be best if database is on cloud and we access thru the web.., and he doesn't think that Access is the right product for that, however I am only familiar with Access/SQL programming)

What are my options?
ASKER CERTIFIED SOLUTION
Avatar of Kelvin Sparks
Kelvin Sparks
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of bfuchs

ASKER

Hi Experts,

Out IT guy claims that its not quite possible to have one network for such a distance...maybe you guys can tell me what is the limit in distance that can be wired under one network?

Re moving all tables to SQL, I know this should have  be done already long time ago, however there were constantly more urgent things to take care off, and this got always pushed off..

However now that this moving users issue came up suddenly..I'm not sure if I can do the conversion from Access to SQL which involves changing allot of code in front end as well, before that splitting takes place.

In addition I would like to know, how exactly will that work after I manage to convert all tables to SQL?

FYI- Currently we already have some users in that other location and they connect to the server using remote desktop connection, and server is set as terminal server, however he claims that this setup was good for a small quantity of users, but when moving dozens of users that will not be adequate.

Re Azure I'm not familiar with it, is it like a new software that would require a extensive learning curve & allot of programming adjustments to our app, or will it be just like upgrading to a new Access version?

Thanks,
Ben
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of bfuchs

ASKER

Hi Experts,

First of all, I would like to thank you for your time & opinions provided here.

At the moment our manager is leaving for vacation, planning to return in about 10 days, I will definitely present him with all these options, especially those that are not in my area of expertise (Like those network issues/solutions), and let him decide which route to take..

In Addition, If some of you have any additional information or similar experience to share that can be useful in order to make the decision, please post it here.

I will keep you posted upon his return

Thanks,
Ben
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of bfuchs

ASKER

Hi Bitsqueezer,

(Good to hear from you every once in a while at least..-:)

Thanks for sharing your experience, I'm keeping all those opinions for the upcoming meeting, just waiting for our managers return.
The more people assuring that this setup would work well even after the planned split, the better off I am in terms of convincing the manager to take this path.

Thanks,
Ben
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of bfuchs

ASKER

@Scott,

Thanks for bringing all these up.
We currently have already close to a dozen users connecting remotely to the server thru RDS, I guess all the licensing issues you're mentioning had to be done already for those in place, its just a matter of adding additional licenses as qty of users expands.

FYI- Re Office version, we have 2003 SP3 for all remote users (and doesn't look like we are planning to change any time soon, unless we're being forced to), and Windows Version is Windows Server2008 R2, the SQL version is 2008.

The manager is due to return any day and guess meeting will take place the end of this week or perhaps beginning of next week, will keep you all informed as thing develop..

Thanks,
Ben
Avatar of bfuchs

ASKER

Hi Experts,

At the moment our meeting was pushed off, and its unknown to me when we will resume, therefore I think there is no point to leave this question open, I guess when the meeting will take place I will post again & insert a link here  to the new question, so you will know how this will end up.

Meanwhile I got to hear all your expert advise and will save them for when the time will be appropriate.

Thanks very much to all participants!

Ben