Alternatives to Data Access Pages? 2

[a98dsu98sad8sua]

Hi guys,

I have a form in my Access database which contains about 8 subforms (All links through a shared primary key, the 8 forms have 8 corresponding tables).

I've been told Data Access Pages aren't that great, but I have limited coding experience with web based lanaguages. I know VBA, and a bit of VB6, but other than that, nothing!

Any advice that people could give me on how to proceed would be excellent.

(PS: On my form there are images that load whenever the record is changed, it is stored as a URL in the table, then when the next button is pressed, the URL is reread and the picture loaded, is this possible to do in a web based format?)

I know HTML and CSS, and have "Hello World"ed in PHP before. Other than that, I'm a newbie!

Thanks for the help guys,

T

 

[AlexMidd]

Personally, I would use PHP and MySQL instead of Access.

Have fun! )

Alex Middleton

 

[a98dsu98sad8sua]

Arg! I've spent loads and loads of time on this database, and then been told I have to distribute the Database to people who don't have access.

So I have a few options:

Completely rewrite this with a web frontend (Half the reason I'm using Access is because I'm not too good with that)
Buy Developer Edition and Package the Database (Not sure how viable this is, anyone know how much retail price is in UK?)
Data Access Pages (I've heard that they are, for want of a better word, pants)

Thanks,

Toby

 

[AlexMidd]

The easiest, but not necessarily the cheapest, way is to use Developer Edition. Not sure of the prices. Web front-end will take a lot of work. Data Access Pages, I would agree, are not very good.

Have fun! )

Alex Middleton

 

[fneily]

You may want to check out the following site. It has links to various DAP articles from Microsoft.com
You'd probably be interested in
How to Simulate a Subform on a Data Access Page
Passing Parameters to a Data Access Page

http://www.kayodeok.btinternet.co.uk/favorites/kbofficeaccesshowto.htm

Also, I placed an Access DB online for the Maryland Department of Transportation which show a picture for each property they're selling. I did it the same way, stored the URL of the picture and then when the record changed, so did the picture.

 

[a98dsu98sad8sua]

Thanks for the info.

The Database is going to be used on a LAN, I'll try the simulating subforms approch.

Thanks very much guys.

 

[MajP]

Could you distribute the Access RunTime to the other users who do not have Access? I have never used it(and no nothing about it), but I know it exists. Maybe if that is an option, other people could provide details on using it. That would be cheap and quick.

 

[a98dsu98sad8sua]

Thanks MajP, but unfortunately that's what I meant about using Developer Edition, you need this to distribute the runtime

 

[Crowley16]

I've had to do the same thing recently...

what you have to do is to get office profesional 2003 and office developer extensions (about £300)

you can't get developer for officeXP as it's been discontinued...

once you've got the extentions, it's not that much trouble to produce an install executable using the standard install wizzard, there's a reasonably simple gui to guide you through this process, all written in access and with the code available for you to mess about with...

--------------------
Procrastinate Now!