Hello again Ladies and Gents,
Like most of you Access x-perts, I have a great table driven method of adding new tables and fields to my access database. I don't think I've actually opened or created a table in design view in years. In my TableMod table, I enter a few fields of detail for the item and the startup code does the rest. I never have to worry about it after that.
With my new found enjoyment (SQL Server), I would like to try to do the same kind of thing. And I would like to try to use the same method, down to using the same record itself, to do the creation of alteration for my SQL backside.
Scenario is, we have lots of clients. Some are Access backends, some are SQL. Up till now, the maintenance of the structure changes for the SQL side has been a manual thing. Managing these structure changes needs to happen in one place, one entry in a table, adding the same fields regardless of whether its Access or SQL.
So I go and add a few different field and table options to my TableMod table and I'm pretty sure I can create a passthrough query to feed a stored procedure that will use parameters passed from access to complete an Alter or create statement.
Here's the question then.
I KNOW I'm not the first one to do this. Has anyone already come up with a system/method of doing this that they can share? I'm more than willing to build my own, and I will if it comes to that, but I thought I'd bang this up against my x-pert buds first, and see what was out there.
Thanks already!
J
Start Free Trial
