Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How can I copy an Access table with its column props & constraints?
Yes, that's how I did it previously using ADOX.Catalog but I want to get rid of all the "legacy" ADO classic code. I'm finding it hard to understand how or why the ADO.NET provider seems to have lost some of the functionality of its predecessor? Thanks- Lexxxa
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
How can I copy an Access table with its column props & constraints?
Hello PHV, thanks for your reply. I had a look at this and this DoCmd appears to be a VBA object. Do you know how to do the same using ADO.NET's data providers for MS Access - either OLE DB or ODBC? Many Thanks again --Axel- Lexxxa
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
How can I copy an Access table with its column props & constraints?
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...- Lexxxa
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
-
How can I copy an Access table with all its structure & properties?
I have an application that uses an access database to store data. In this database I have "template" tables that I need to be able to copy the template and all its structures (such as autoincrement columns, allow zero value, properties etc.), rename it and write back to the access database. The...- Lexxxa
- Thread
- Replies: 0
- Forum: C# (C sharp): Microsoft
