 | |
#1
 
| |||
| |||
|
Re: Rewrite to internet -
08-20-2005
, 04:29 PM
|
Some advise please. I have a fairly complex MS Access database and would like to re-write it for use on the internet/intranet. This would be used in a hospital environment, accessible then from any terminal. Here is my question, what should I re-write it in? Be specific please. It should have decent ability to protect the data on the backend. I would like to just port into my current Access backend tables, but am open to something if better and not too! dif. to learn. Thank you in advance. Monty |
#2
| |||
| |||
|
|
Monty: I would convert the back end to SQLServer. Access will do that for you. How many problems you will have with that aspect depends on how you have named your fields. Access lets you get away with field names that SQLServer will not. There is a tool that will do most of the work for you (Speed Ferret) but it is $200 the last I looked. It sure saved me a lot of work when I converted about 10 systems. I would use ASP or one of the newer .Net variants. Since ASP allows you to use VBScript which is very close to VBA your learning curve will be easy. You can simply copy the SQL from your current Access queries and use them in the ASP code (although there are some changes due to SQLServer conventions) I use Dreamweaver for the forms. It works well. I barely had to use any HTML myself which is good because I barely know it. It also provides some basic database connections saving you a lot of work. Lots of books, forums, etc., but not cheap! I have also seen some tools that claim to convert Access forms to ASP. I haven't tried them, but depending on what you are doing they might save you a lot of work and you might not need Dreamweaver if you have an HTML person on hand. Good luck Ira Solomon On Fri, 19 Aug 2005 13:51:36 -0700, "Monty" <monty (AT) chartered (DOT) net wrote: Some advise please. I have a fairly complex MS Access database and would like to re-write it for use on the internet/intranet. This would be used in a hospital environment, accessible then from any terminal. Here is my question, what should I re-write it in? Be specific please. It should have decent ability to protect the data on the backend. I would like to just port into my current Access backend tables, but am open to something if better and not too! dif. to learn. Thank you in advance. Monty |
#3
| |||
| |||
|
|
Ira, first thanks very much. What version of Dreamweaver would recommend? Version 7 or the new 8? Thanks Monty "Ira Solomon" <isolomon (AT) solomonltd (DOT) com> wrote in message news:0i7fg1lfbifq6tj757nntl2msqrgj88jpn (AT) 4ax (DOT) com... Monty: I would convert the back end to SQLServer. Access will do that for you. How many problems you will have with that aspect depends on how you have named your fields. Access lets you get away with field names that SQLServer will not. There is a tool that will do most of the work for you (Speed Ferret) but it is $200 the last I looked. It sure saved me a lot of work when I converted about 10 systems. I would use ASP or one of the newer .Net variants. Since ASP allows you to use VBScript which is very close to VBA your learning curve will be easy. You can simply copy the SQL from your current Access queries and use them in the ASP code (although there are some changes due to SQLServer conventions) I use Dreamweaver for the forms. It works well. I barely had to use any HTML myself which is good because I barely know it. It also provides some basic database connections saving you a lot of work. Lots of books, forums, etc., but not cheap! I have also seen some tools that claim to convert Access forms to ASP. I haven't tried them, but depending on what you are doing they might save you a lot of work and you might not need Dreamweaver if you have an HTML person on hand. Good luck Ira Solomon On Fri, 19 Aug 2005 13:51:36 -0700, "Monty" <monty (AT) chartered (DOT) net wrote: Some advise please. I have a fairly complex MS Access database and would like to re-write it for use on the internet/intranet. This would be used in a hospital environment, accessible then from any terminal. Here is my question, what should I re-write it in? Be specific please. It should have decent ability to protect the data on the backend. I would like to just port into my current Access backend tables, but am open to something if better and not too! dif. to learn. Thank you in advance. Monty |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.