Hi,
I am trying to do something that I thought would be very easy (and I have done very easily before using other RDBMS like MySQL) but it appears because of some limitations of the JET engine is proving to be anything but easy when using an Access database.
In my application's Access database there are lots of 'template' tables - they have a pre-defined structure and constraints but contain no records.
What I need to do is at the appropriate time copy one of these template tables and insert it into the database under a new name with all the column properties and constraints of the template table. I have no idea in advance the order in which the tables are to be created from the templates or indeed which tables will need to be created when the application is run.
I have posted this in the C# section of this forum but then thought maybe I was asking the wrong people and the JET experts may be more able to help.
Many thanks in advance.
--Axel
I am trying to do something that I thought would be very easy (and I have done very easily before using other RDBMS like MySQL) but it appears because of some limitations of the JET engine is proving to be anything but easy when using an Access database.
In my application's Access database there are lots of 'template' tables - they have a pre-defined structure and constraints but contain no records.
What I need to do is at the appropriate time copy one of these template tables and insert it into the database under a new name with all the column properties and constraints of the template table. I have no idea in advance the order in which the tables are to be created from the templates or indeed which tables will need to be created when the application is run.
I have posted this in the C# section of this forum but then thought maybe I was asking the wrong people and the JET experts may be more able to help.
Many thanks in advance.
--Axel