by Joel Konecny (1 Submission)
Category: Databases/Data Access/DAO/ADO
Compatability: Visual Basic 3.0
Difficulty: Advanced
Date Added: Wed 3rd February 2021
Rating: 
(13 Votes)
the engine i am providing is an asp code generator that i am currently using on my website (www.intratelligent.com) to allow asp developers to upload access databases online and build simple asp interfaces to interact with their data. (insert / update / delete and reporting functionality).
Inputs
the only input that the code requires is an access database and the base path for the project... you will notice that all parameters are left variant because this was originally built as a dll for calls from asp.
Assumes
there are a few dependencies that my code relies on... dao 3.6 and microsoft scripting runtime (filesystemobject)... the reason i am using dao is for database information (adox in next release). the vb version also uses the common dialog component (standard with vb).
Code Returns
the main function will return a boolean value letting you know whethere the function succeeds or fails... the vb version let's you know with a msgbox.
Side Effects
the code is completely independant of anything on your system... once the code is generated it can be transfered to any iis server and run as long as the server supports asp and ado connectivity.
Download ASP Code Generator (8 KB)
VBcoders