Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sturner333
Starting Member
22 Posts |
 Posted - 2008-04-17 : 13:47:00
|
| Sorry for the lengthy question, but here goes:I currently have an access database with a FE and BE that resides on each users laptop. Weekly they connect to the network and synch the BE the master on a network drive. There are numerous propblems with this as it has grown quite extensive. We would like to have this be a server based database with the remote users either having access through the web or something else?A few of the capabilities of the current database:1. generate and print reports 2. update project forms. 3. enter time logs 4. enter notes My question is:What are my options for a remote FE? I am well versed in VB6 and Access. Would be willing to learn other languages (VB.net, my SQL, etc.) Would I be able to have the same functionality or would I have to have separate software for certain functions? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-04-17 : 15:55:48
|
what's FE and BE?you can have all data in sql server and have access as a front end that get the data from sql server.that way you can still have reports, etc... in access.for we you'll have to create a web page  _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-17 : 15:59:50
|
| FE = front-end, BE = back-end?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-04-17 : 16:01:20
|
| DOH..._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
sturner333
Starting Member
22 Posts |
Posted - 2008-04-17 : 16:04:23
|
| I am looking for specifics on what software one would suggest for the remote laptop for a web based solution, or other solution.Thanks |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-04-17 : 16:27:35
|
| for a web based solution you only need an internet browser installed on the client.the website is on the web server anyway. in what language you want to build the website is your choice._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
|
|
|
Front End