Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Is there a way to turn a Form into a web page?
- Thread starter Vette00
- Start date
What version of web developer do you have?
You will need to redesign your form, but much of the underlying code can probably be moved if you have 6.0
If you are looking at the .net variety your code will probably need some serious modifications.
Any queries that you use stored in the db will probably need to be modified and used as SQL statements performed on a data source, and you will have security issues to deal with as well.
HOpe this helps,
Alex
A wise man once said
"The only thing normal about database guys is their tables".
You will need to redesign your form, but much of the underlying code can probably be moved if you have 6.0
If you are looking at the .net variety your code will probably need some serious modifications.
Any queries that you use stored in the db will probably need to be modified and used as SQL statements performed on a data source, and you will have security issues to deal with as well.
HOpe this helps,
Alex
A wise man once said
"The only thing normal about database guys is their tables".
- Thread starter
- #3
Do you have visual studio 6.0? If so you can use interdev to create a 'classic' asp page.
If not, you can use visual web developer express (which can be found at MS web site for free).
You can use access DB as your back end if you place it on the web server, but a lot of your coding will need to be almost completely rewritten for compatibility with VB.net. There are also several issues with client vs server side code that you will need to resolve.
What kind of database is this, and why the push to make it web based?
A wise man once said
"The only thing normal about database guys is their tables".
If not, you can use visual web developer express (which can be found at MS web site for free).
You can use access DB as your back end if you place it on the web server, but a lot of your coding will need to be almost completely rewritten for compatibility with VB.net. There are also several issues with client vs server side code that you will need to resolve.
What kind of database is this, and why the push to make it web based?
A wise man once said
"The only thing normal about database guys is their tables".
- Thread starter
- #5
I don't have visual studio but they will buy it if that is the way to go. The reason for push is they want users from across the state to be able to use the same database instead of each section using their own. Plus they have no idea how much work that is.
Visual Studio is probably the way to go, and if you have a full blown rdbms like SQL Server or Oracle you will probably want to migrate to that as well. You have the potential for a lot of record locking issues it sounds like.
We have a work order database in access that we publish to users in a couple states over our network using CITRIX, not sure if that would be an option for you. It would make development MUCH MUCH MUCH easier for sure.
How are you handling potential record locking issues at the moment?
Good Luck,
Alex
A wise man once said
"The only thing normal about database guys is their tables".
We have a work order database in access that we publish to users in a couple states over our network using CITRIX, not sure if that would be an option for you. It would make development MUCH MUCH MUCH easier for sure.
How are you handling potential record locking issues at the moment?
Good Luck,
Alex
A wise man once said
"The only thing normal about database guys is their tables".
- Thread starter
- #7
I actually built DAP's for my state's transportation system. So:
What version of Access do you have? You can save your forms and reports as STATIC web pages.
How many forms do you have? If you need them for data entry, then you'll build a DAP (Data access page). Beware, DAP's are WEB pages, not Access forms so VBA doesn't work. You'll be coding in VBScript. No form/subforms. Web pages are hyperlinked.
Your IT department will have to learn how to employ DAP's on the web. They'll probably tell you to code in ASP or something.
If you only need one or two forms, then just create SIMPLE DAP's. If your boss thinks you're going to throw your whole Access database out there, tell him to pay you alot of money.
The last post is correct in one way. It's much easier and cheaper to get a citrix server ( and have them remotely login to just a single database. You don't have to do any coding. The other ways, be prepare for a year's work.
What version of Access do you have? You can save your forms and reports as STATIC web pages.
How many forms do you have? If you need them for data entry, then you'll build a DAP (Data access page). Beware, DAP's are WEB pages, not Access forms so VBA doesn't work. You'll be coding in VBScript. No form/subforms. Web pages are hyperlinked.
Your IT department will have to learn how to employ DAP's on the web. They'll probably tell you to code in ASP or something.
If you only need one or two forms, then just create SIMPLE DAP's. If your boss thinks you're going to throw your whole Access database out there, tell him to pay you alot of money.
The last post is correct in one way. It's much easier and cheaper to get a citrix server ( and have them remotely login to just a single database. You don't have to do any coding. The other ways, be prepare for a year's work.
fneily - I have never worked with DAP's but that does sound like it would be easier than visual studio route. Rewriting your code in VBScript though? Yuck! Although probably less painful than recoding in vb.net would be...
Is the performance on these comparable to an asp page?
A wise man once said
"The only thing normal about database guys is their tables".
Is the performance on these comparable to an asp page?
A wise man once said
"The only thing normal about database guys is their tables".
I am just learning ASP(.net variety - not sure how much difference as I never tried 'classic') but I like it as well. The nuances of the client side/server side coding can be vexing, but it has been fun thus far.
Remou - have you ever worked with DAP's? If so, how do they compare to ASP?
A wise man once said
"The only thing normal about database guys is their tables".
Remou - have you ever worked with DAP's? If so, how do they compare to ASP?
A wise man once said
"The only thing normal about database guys is their tables".
- Thread starter
- #12
A apologize as well. Thanks for the info Remou.
Vette - I have not used it, but as it is a free download, it can't hurt to try! Just make sure to do it with a copy of course.
Let us know how it works out for you.
A wise man once said
"The only thing normal about database guys is their tables".
Vette - I have not used it, but as it is a free download, it can't hurt to try! Just make sure to do it with a copy of course.
Let us know how it works out for you.
A wise man once said
"The only thing normal about database guys is their tables".
- Thread starter
- #15
When you create a DAP, it incorporates ASP and XML. You'll notice how everyone is trying to get you to do it in ASP. I ran/run into this with IT departments. DAP's have been around since 2000 but the "too busy" IT people don't want to learn/deal with it.
Access2Web sounds interesting. Never even heard of it. Got to check it out.
Remou - "I have not worked with DAPs. I decided against them," , Based on what??? Obviously, not from experience, your words.
Whatever you do, since this is your first try, keep it simple. Coding for the web can be time consumming. Just remember, you're in the Internet Explorer environment, NOT Access.
Access2Web sounds interesting. Never even heard of it. Got to check it out.
Remou - "I have not worked with DAPs. I decided against them," , Based on what??? Obviously, not from experience, your words.
Whatever you do, since this is your first try, keep it simple. Coding for the web can be time consumming. Just remember, you're in the Internet Explorer environment, NOT Access.
Actually, I hope that someday, someone will make data transfer on the Internet as simple as using a mouse so the populace can use it instead of "experts".
Asp, which you so energetically support and it seems IT departments want, is nice if you're a strong programmer. If you really want to be efficient, use assembler(you never hear about HEX anymore). Dap's are an attempt, a little one, so that the common person can create a web page for data transfer. My experience is that most people aren't as advanced as you and the other excellent contributers on Tek-tips.
Plus, nobody else seems to like poor, little, DAP's.
Asp, which you so energetically support and it seems IT departments want, is nice if you're a strong programmer. If you really want to be efficient, use assembler(you never hear about HEX anymore). Dap's are an attempt, a little one, so that the common person can create a web page for data transfer. My experience is that most people aren't as advanced as you and the other excellent contributers on Tek-tips.
Plus, nobody else seems to like poor, little, DAP's.
JUST A TIP:
What i did in the case like this with the business i work for so i transferred the whole database online to a mysql database and i created the form from linked tables to the mysql database and i created a small setupfile that creates the connections in the odbc and puts the access forms in place so when there is a new user i just email him a link from where to download this setup and the business uses it for three month already and they are really happy with it
What i did in the case like this with the business i work for so i transferred the whole database online to a mysql database and i created the form from linked tables to the mysql database and i created a small setupfile that creates the connections in the odbc and puts the access forms in place so when there is a new user i just email him a link from where to download this setup and the business uses it for three month already and they are really happy with it
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question