Convert an Access Object to ASP

[Kunal]

Hi,

I have recently started to learn about ASP and how to go about converting my Access Database to ASP.

Now I've found various third party table and query converters but have not come accross anything that will convert other objects such as forms, reports and macro's. I have tried convert a form by right clicking and save as ASP, but this doesn't do much just create a basic datasheet view of the forms, missing all the buttons, combo's etc.

Now I was wondering if it is indeed possible to convert a form to ASP and if so how?

Many thanks,

Kunal

 

[Ovatvvon]

I know you can with Access XP...however we've found some problems with it...it uses DSN connections that aren't necessarily there...you'd have to create them or change the code within to a dsn-less connection.

However, I don't think this is your problem from the sounds of it. I can't really help you more then to say that it can be done (at least with XP) because we don't really use Access to generate ASP pages. That is an incredibly weak component to create ASP pages. Sorry I couldn't help you more. -Ovatvvon :-Q

 

[Guest_imported]

Hi,
I just read your email. I having a similiar problem. But I am user Access 2002, how do I convert from mdb to asp for my web page?

 

[Turkbear]

There may be some confusion here ...an mdb ( the Access database ) has data in it that can be retrieved and displayed on a web page ( using asp, for instance ) and no 'conversion' is needed...However to use the forms and reports which were designed in Access and are used in an Access application ( not just the data) is not possible as far as I know..
( Maybe with XP as noted, but I cannot imagine that it is the best way to do it )

 

[Guest_imported]

Oh OK,

Im new to this. Ive saved two mdb's as asp's. which appear on the web, with most of the database coming with it. I can even review the records. But the option to add more records is greyed out.

JOe

 

[Ovatvvon]

As far as I know...access XP is the only version that will allow to you convert your forms within access to asp pages. If you get a connection to the database ok, then you should be able to do anything with it. I don't have much experience with these types of documents, however my guess would be if it's not letting you add records, your connection info may need to be changed. Perhaps it is set to 'read only' and you need to change it to allow you to write to it. Or perhaps access won't design the forms/pages to allow you to add records to the database and you'll have to add them yourselves. I'm honestly not sure.

certainly access would be a very crude way to design your web pages...and why anyone would want their web page to be designed like an access form is beyond me. However, I'm sure it provides a simple way to create simple database driven pages for beginners.

Hope this has been helpful! -Ovatvvon :-Q

 

[smartyme]

Hi Kunal,

What I thank you need an application that can help you create your asp pages without headach while learning asp.

There are a lot of third party application that can create asp but the best that I havve come across adn the cheapest so fat is ASPMaker, it cause about 19.50 USD. search for ASPMaker and I hope I am not doing the wrong thing by posting this information on this site.

 

[Tarwn]

Only if you are getting a percentage

I would agree that you should either go with a product specifically designed to create ASP or learn it yourself. Access, like other MS products, probably creates a real mess when it creates your ASP code. I have noticed from day one that MS went way over the top in trying to allow people to save documents and data to web format. Generally The cookie cutter code produced by these applications creates 2 to 3 times larger files or loads then if it had been hand written. The upside of using MS conversions being, of course, that you don't have to write the pages yourself. So it's probably more of a personal thing. I have not used ASPMaker or similar products before, but I think those would be better for the task then Access, as they at least are aiming at strictly making ASP pages. Myself, I have always perferred text editors.

Oops, I may have just invited everyone to write down there favorite editors. (EditPlus!, EditPlus! Ra! Ra!)
-Tarwn
Still On my first cup of coffee today ------------ My Little Dictionary ---------
Reverse Engineering - The expensive solution to not paying for proper documentation

 

[roy29]

I understand what you're trying to do. The terminolgy is what's causing the most confusion. We're still using Access 98 in my shop and I know it changed in Access2000 so here's the best I can give you.

In 2000 they changed the name to Data Access Pages which are essentially the same thing. I haven't played with them so here's a link that walks you through the process.

http://databases.about.com/library/weekly/aa012801a.htm

Hope this helps