Building on John idea with a few of my own (from a real word system I've
developed...)
Creating a blank MDB from scratch is particularly painful - so, like John
said - start with a ready made template.
Next make a copy with a unique name (there are loads of ways of doing this,
timestamps, uniqid(
You could use ODBC to do it. Create a template access DB, poulate it
with ODBC, then read the file and send it to the user. After it's
downloaded clear the table. the downside to this is that you would only
be able to haev one user ata time get an access database. I'm sure
there are better
I'm trying to supply our Contract Counties with mailing labels, already formatted.
They log on to our website and PHP will hit our SQL Server and return a list of Public
Water Systems for the County chosen. I would like a link on this page that says
something like "Send me an Access .mdb with ma
On Tue, 12 Nov 2002, John A DAVIS wrote:
> Want to give the user the ability to download a dynamic Access.mdb file
> that has a table and linked report formatted for Avery 5160 labels. Know
> how to create all this stuff in VBA code, but not using PHP.
It is better to give too much information t