stands for Microsoft's ActiveX Data Objects.
Questions tagged [adox]
69 questions
2
votes
2 answers
No overload for method 'Open' takes 1 or more argument
I have a error regarding ADOX and i have no idea how to solve.
enter code here public static string[] GetTableExcel(string strFileName)
{
string[] strTables = new string[100];
Catalog sCatalog = new Catalog();
…
Philemon
- 101
- 2
- 14
2
votes
2 answers
Can't create Access Database with ADOX
I have a really strange problem with ADOX Interop.
I have this code:
try
{
if (File.Exists(path))
File.Delete(path);
var cat = new CatalogClass();
…
Agustin Meriles
- 4,866
- 3
- 29
- 44
1
vote
0 answers
How to programmatically create an encrypted database that is Access 2007 compatible from the Access 2010 database engine?
I'd like to upgrade my application to use the newer Access 2007/2010 database engine. It currently stores its data in a Jet 4.0 (MDB) database. My application is written in Delphi, and it uses ADODB (ADO classic) to interact with the database. …
Troy
- 1,237
- 2
- 13
- 27
1
vote
0 answers
Why does ADOX GetPermissions return 0 for an Access Form with Open/Run group permission set?
Here's the scenario:
I have an Access 2003 (.MDB) database with User Level Security
I have a group G and a form F
Through "User and Group Permissions" dialog box, I explicitely set Open/Run permission (and only that) for group G on form F
I log in…
Aram Gharib
- 81
- 1
- 4
1
vote
0 answers
Cannot execute sql insert into .mdb file using ACE driver. Works with .accdb file
I am using ACE database driver. I am creating access database using ADOX and am trying to insert the data using SQL command. When the filename is using .mdb extension it doesn't works while it works when using .accdb. I am using the x64 ace…
Louis
- 21
- 3
1
vote
1 answer
How to set Adox.table auto increment property to a column?
The .Item("Key").Properties("AutoIncrement") = True is not setting the column type to autoincrement number. It says it's read only, but it's in the microsoft official website. This was in the older non updated version of microsoft docs…
Pretty_Girl3
- 41
- 8
1
vote
1 answer
C# Compact and repair .accdb files using DAO or ADOX
As stated here I'm rebuilding tables from SQL Server to Access by using C#
Thanks to the help I received I could finish the process but since the .accdb files are pretty large, I need to compact and repair them afterwards.
For that, I used the…
Scorch
- 153
- 2
- 17
1
vote
1 answer
Access Database File not closing while opening it in c# programmatically
I am new to this. In fact this is the first time I am ever posting a question on stackoverflow. I have done many searches but yet could not find an answer to this.
Here is a gist of what I am trying to do.
Open an access database file using…
Lakki
- 11
- 1
1
vote
1 answer
Can a database be created in C# using OLEDB and nothing else?
I've been using OLEDB programmatically (No References in Visual Studio, just accessing the database, which is in the same folder as the program, through code) to access and modify Microsoft Access databases in Visual Basic. I've always made sure my…
pfthroaway
- 85
- 1
- 8
1
vote
1 answer
Numeric Field types when creating access db with ADOX give me COMExceptions
I'm trying to create Access DB using ADOX namespace...
Everything worked fine when I was defining all the fields as ADOX.DataTypeEnum.adVarWChar for test purpose, but now I'm trying to define
integer or decimal (numeric types) and my code doesn't…
solujic
- 924
- 1
- 18
- 43
1
vote
0 answers
Rename Excel file column names using ADOX
i am trying to pull in the field names from a closed Excel file using ADOX into a Dictionary object. However, some column names are ENCLOSED in Single quotes or some are just PREFIXED or SUFFIXED with a Single-quote.
"'GLOBAL VIT/ACE'" OR "'GLOBAL…
sifar
- 1,086
- 1
- 17
- 43
1
vote
2 answers
grab and filter from more than 255 columns from a huge closed workbook
i have a huge workbook (0.6 million rows) and 315 columns whose column names i need to grab into an array. due to the huge size, i don't want to open and close the workbook to copy the 1st row of the range. Also, I want to only grab certain columns…
sifar
- 1,086
- 1
- 17
- 43
1
vote
1 answer
C# ADOX adDBDate type column not working
I want to create programatically a database and I create into that database a table.(.MDB Access database)
I create the database and the table using the ADOX integrated functions, "Catalog" for the database and "Table" for the table inside the…
Marius Todoran
- 55
- 6
1
vote
1 answer
Using ADOX via VBScript
Shouldn't you be able to implement the ADOX library via VBScript? The code below runs perfect via Access 2010 on Windows 7, Office 2010 32-bit, but doesn't via a VBScript. Isn't ADOX just another COM Object like say FileSystemObject?
Dim…
Steve
- 549
- 6
- 21
1
vote
1 answer
ADOX - tables in an SQL Server Schema not listed
I am retrieving table names using ADOX, but any tables that are within a schema other than DBO are not listed.
Sub ListTablesADOX()
Dim Conn As New ADODB.Connection
'Open connection you want To get database objects
Conn.Provider = "MSDASQL"
…
Richard Briggs
- 423
- 4
- 14