developingprogrammer
asked on
Implementing backend database server for Access
Hey guys, in this question (http://mobile.experts-exchange.com/questions/28191163/Error-3077.html) Christian mentioned about having a backend database server to execute queries. His comment is at the end portion of the question.
For Access
1) how can I implement a backend server (this is different from FE and BE where BE cannot have any queries)
2) what would be the benefits of implementing that other than changing queries on server and having all the FEs have that change automatically without updating them? Thanks!!
For Access
1) how can I implement a backend server (this is different from FE and BE where BE cannot have any queries)
2) what would be the benefits of implementing that other than changing queries on server and having all the FEs have that change automatically without updating them? Thanks!!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hrmm that's interesting running regular imports. Ok cool thanks gustav!!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
whao Christian, Jim,
i'm eyes have been completely widened.
already with Access and VBA i'm having my head so full already.
hrmm. i'm really not sure what i should do. in terms of strategic direction.
hrmm ok. i'm super duper DUPER tempted to really skew in the way of SQL Server, and i think if my job position is more secure, my skills are better and my company are more pro tech, i will LOOOOOOOOOVE to use SQL Server. already with what you're saying Christian it is superbly tempting me. but i think my strategic direction is to master Access and VBA, and once i'm a super master of that, then i'll be considered an infant in the programming world. not a fetus anymore haha.
then i need to quickly go on to iOS programming.
yes Access is so noob compared to SQL Server but Excel is so noob compared to Access. i think it now comes to the choice of IT-Business alignment and what would yield the biggest benefits from the next step in technology. i think Access (despite all its myriad bugs and flaw) offers the biggest jump. from non relational to relational. like remember the days of black and white phones? i think the biggest quantum leap is from black and white to colour phones.
Christian, i FULLY acknowledge the flaws of Access database and i'm super, super, super excited to master SQL Server, but i think i must put that aside for now and use business wisdom to make tech relevant to my current situation instead of skewing the way into a tech geek (which i love to be haha) = ))
hrmm... SQL Server... it's so exciting really..... gosh!
i'm eyes have been completely widened.
already with Access and VBA i'm having my head so full already.
hrmm. i'm really not sure what i should do. in terms of strategic direction.
hrmm ok. i'm super duper DUPER tempted to really skew in the way of SQL Server, and i think if my job position is more secure, my skills are better and my company are more pro tech, i will LOOOOOOOOOVE to use SQL Server. already with what you're saying Christian it is superbly tempting me. but i think my strategic direction is to master Access and VBA, and once i'm a super master of that, then i'll be considered an infant in the programming world. not a fetus anymore haha.
then i need to quickly go on to iOS programming.
yes Access is so noob compared to SQL Server but Excel is so noob compared to Access. i think it now comes to the choice of IT-Business alignment and what would yield the biggest benefits from the next step in technology. i think Access (despite all its myriad bugs and flaw) offers the biggest jump. from non relational to relational. like remember the days of black and white phones? i think the biggest quantum leap is from black and white to colour phones.
Christian, i FULLY acknowledge the flaws of Access database and i'm super, super, super excited to master SQL Server, but i think i must put that aside for now and use business wisdom to make tech relevant to my current situation instead of skewing the way into a tech geek (which i love to be haha) = ))
hrmm... SQL Server... it's so exciting really..... gosh!
ASKER
hrmm i think if i can implement SQL Server in a way that no one knows a tech server is running then i'll surely do it haha.
but i need a physical computer server to implement SQL Server!!
you have no idea how tech averse my company is!! it's crrrraaazzzzyy!!!!
but i need a physical computer server to implement SQL Server!!
you have no idea how tech averse my company is!! it's crrrraaazzzzyy!!!!
> .. i need a physical computer server to implement SQL Server!!
No ... you can come close at very low cost by leasing one at Azure. A free trial period is available.
/gustav
No ... you can come close at very low cost by leasing one at Azure. A free trial period is available.
/gustav
ASKER
Whao cool!! I definitely want to try that moving forward! But think it will be quite hard cause I can't store customer information online! Or risk losing my job!! Haha = ) but thanks for pointing out that option gustav!! = ))
It is on-line, of course, but certainly not accessible for other than those you grant the permission for access.
/gustav
/gustav
<<It is on-line, of course, but certainly not accessible for other than those you grant the permission for access.>>
Still, many companies won't risk having data out of their control. Their relying on Microsoft to keep it safe.
Jim.
Still, many companies won't risk having data out of their control. Their relying on Microsoft to keep it safe.
Jim.
Hi,
I remember times when we only had a telephone at home or in small rooms in the city with a dial plate...:-))
If you only want to test, you can install a SQL Server Express on your local machine. It's free and it can do the same as it's big brother with only a few limitations.
Cheers,
Christian
I remember times when we only had a telephone at home or in small rooms in the city with a dial plate...:-))
If you only want to test, you can install a SQL Server Express on your local machine. It's free and it can do the same as it's big brother with only a few limitations.
Cheers,
Christian
ASKER
cool! thanks Christian, Jim and gustav! = )
ASKER
hey all, here's a good article by Jim that touches on this subject as well!!
https://www.experts-exchange.com/Microsoft/Development/MS_Access/A_1173-ACCESS-IS-A-TOY-FACT-OR-FICTION.html
i've amended Christian's comments there as well so that we can get a full read from both webpages = )
https://www.experts-exchange.com/Microsoft/Development/MS_Access/A_1173-ACCESS-IS-A-TOY-FACT-OR-FICTION.html
i've amended Christian's comments there as well so that we can get a full read from both webpages = )
ASKER
however if i am only sticking with Access cause i can't use any other tools, is there any way i can have an active back end database server a la SQL Server but done in Access? are there any benefits to it?
thanks once again Christian!! = ))