stands for Microsoft's ActiveX Data Objects.
Questions tagged [adox]
69 questions
0
votes
1 answer
VB.NET -> C# Syntax problems
I want to create a new MS Access database table using ADOX. On this page, is code in VB.NET, but obviously it's not working in C# (when I want to "convert" the code). I'll be grateful if someone converts it correctly.
In VB.NET is:
Dim Cn As…
Tony
- 12,405
- 36
- 126
- 226
0
votes
2 answers
VB.NET - Modifying MS Access Table Name with ADOX
I'm trying to modifying a table name based on two textbox inputs. I have one form creating the table using OleDb so I want to use the inputted information from that form to search for the table in the database then rename it to what the use wants on…
Karl
- 17
- 1
- 7
0
votes
1 answer
I cannot obtain Metadata using ADO/ADOX
I am trying to obtain meta data based on a users selection. I am using the ADODB namespace to provide a connection to the database and a recordset to retrieve data from it. I have set up a connection and tested it, this works fine, but the retrieval…
AdamWest
- 29
- 1
- 9
0
votes
1 answer
Issue with Disposing Adox Object
Using ADOX Catalog class I am trying to create an empty Ms Access Database.The code is working fine(as far as I know) and generates the database but when I try to open the database from windows explorer, I am getting the "Could not use name.accdb ;…
Suffii
- 5,694
- 15
- 55
- 92
0
votes
1 answer
How to Implement IDispoable with ADOX Catalog Class
I am trying to create a disposable ADOX Catalog instance by implementing IDisposable interface but I am getting a Error which is:
ADOX.Catalog' does not contain a definition for 'Dispose' and no extension method 'Dispose' accepting a first argument…
Suffii
- 5,694
- 15
- 55
- 92
0
votes
0 answers
ADOX or SQL DDL
I tried two method to create tables inside a new Ms Access database generated by ADOX catalog class. The first method is using ADOX classes and Properties to create columns and tables and eventually add them to Database at the same time of…
Suffii
- 5,694
- 15
- 55
- 92
0
votes
1 answer
How to access properties of Access Database Table using C# ADOX?
I have created MS Access Database using C# ADOX library. I have created one table with several columns. What I want to achieve is when I insert date in one column, the date format should be YYYY-MM-DD and not MM-DD-YYYY. I know its just display…
Sachin G
0
votes
1 answer
Error when I try to create an .accdb file in C#
This is my code that creates an .accdb file if it can't find one :
Catalog cat = new CatalogClass();
string createStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|/saveDB.accdb;";
cat.Create(createStr);
Table tbl = new…
Stefan Manciu
- 490
- 1
- 6
- 19
-1
votes
1 answer
Database column creation through ADOX.Table
I'm trying to create columns in an existing access database. The database has already been created, it contains the empty table named "table1", but it does not contain any columns, now I want to add a column into it. But it produces some…
Pretty_Girl3
- 41
- 8