ASP and Access?!?!?!?!?!

[sabre28]

I am new to ASP, and I have a problem. I have an access database that is fairly large, not so much as records, but mostly table definitions. I need to have an interface that will basically combine all the data from all tables, one record (about 770 fields), and then create a text file from there. we have an html/java script form that lets us input the data, and then print and export the txt, but there is no way to go back and change data in the HTML form. that is why i created the access db, but realize that access cannot go over 255 fields per table, query, report, or dap. is it possible to do this using ASP?
:confused:
I would appreciate any help on this

[phpnovice]

Sure, you could write code to extract each table in turn and build a two-dimensional array to accumulate all of the table data into their respective rows within the array. This would be a tedious programming assignment, but definitely possible -- as long as server memory does not become a problem.

I wonder, though, what in the world kind of application would require keeping track of over 770 pieces of information for the same primary key. ;)

[sabre28]

I just wanted to make sure this could be done, thanks. Tedious is an understatement, so I wanted to make sure that this was a wise decision before I took on this assignment. The database is primarily used in a form base where our salesmen enter data pertaining to a quote for a job. As you can tell, entering all that info took a while. So when they found out that they would have to reenter all that data if something was wrong the first time, they, along with higher-ups were not very happy. plus the html file was written before my time here. thanks for the help! :)

[sabre28]

I am pretty sure, but could this be used to create an 'access form' and display one record at a time? - just curious
thx
;)

[phpnovice]

Not to my knowledge. FAIK, web-based Access database usage is limited to data tables only -- no queries, forms, reports, modules, etc. If anybody else knows better, I'd be happy to learn a thing or two. ;)

[wmif]

lets hear more about this project. i am siding with php in that i doubt that any project needs this kind of table structure. what kind of information are you storing in these fields?

[sabre28]

this db is broken down into 22 different tables in access. the full desc of this project is this: a while back, before my time here, someone wrote an html/javascript file that the users would enter data in the fields (mostly text boxes, dropdown boxes, and 2 memo type fields). the file has a total of 770+ entries. at the bottom of the html file there are two buttons, one to print out the data, and the other takes all the values in the fields and creates a .txt file to be imported into out accounting software. and for another bump in the road, the text file needs to have the values in the field directly beneath one another, or delimited by 'enter' or ^p. why i am redoing this? the people using this sheet (as well as the owners) said that sometimes mistakes can be made while entering this info, and they may not know it until they are done, or have to go back to it at a later date. the only way, using the html/jscript file, was to reenter ALL of the fields over again, and recreate the text file. as you may well guess that was not efficient. i need the users to go back to an old record, and be able to just change the data they need. i also tried, obviously to no success, to import the text file into the html file. right now i am just seeing double :eek:

[wmif]

do you have a sample of the html file they use to fill out the form?

[sabre28]

the file has over 14k lines of code, any specific area?

i have included the html file, sensitive info erased.

hve fun :p

[sabre28]

the file was too big the first time