Stack Overflow
Stack Overflow

Questions tagged [adox]

stands for Microsoft's ActiveX Data Objects.

69 questions
1
vote
1 answer

How to determine IN APP if a .mdb(access database) created from a delphi app already exist or not?

I am writing a delphi project where I am having to create an access database. I am using ADOX for the purpose. Let me admit, I am a novice when it comes to db handling, and I followed the tutorial on net and successfully created by CreateDatabase…
Priyabrata
  • 1,202
  • 3
  • 19
  • 57
1
vote
2 answers

ADOX can't be used in VS2010?

I want to use ADOX to create a database in VS2010 but on using 'ADOX.catalogClass' i get the unusual error: Interop type 'ADOX.CatalogClass' cannot be embedded. Use the applicable interface instead. Actually the specific line being marked as an…
mac007
  • 113
  • 1
  • 5
  • 11
1
vote
1 answer

How can I access a view command through T-SQL?

I'd like to be able to retrieve programmatically the command strings that generate the views on our SQL Server. I though the ADOX collection, used together with an ADODB connection, will allow us to access this through the catalog/view/command…
Philippe Grondier
  • 10,900
  • 3
  • 33
  • 72
1
vote
0 answers

How to set MS Access Field Caption Property in C# with ADOX

Can you please let me know how to set MS Access Field Caption Property in C# with ADOX? I already tried this setting: colFName.Properties["Caption"].Value = "First Name"; and colFName.Properties["Jet OLEDB:Caption"].Value = "First Name"; but i am…
Suffii
  • 5,694
  • 15
  • 55
  • 92
0
votes
1 answer

Is there a .NET library that does what ADOX did, i.e. a cross-db DDL library?

I'm writing a cross database application. When it comes to commands and connections, it works beautifully with ADO.NETs base classes and oledb providers. Now I need to write some code to make tables, indexes, drop them, query the list of tables, etc…
MatthewMartin
  • 32,326
  • 33
  • 105
  • 164
0
votes
0 answers

Get datetime when access database content was last modified

I am trying to get the last modification date of database content, to know when to refresh some data. I thought this would work: Static ADOCat As ADOX.Catalog If Not ADOCat Is Nothing Then Set ADOCat = New ADOX.Catalog If ADOCat.ActiveConnection Is…
j74nilsson
  • 146
  • 7
0
votes
1 answer

msadox28.tlb is not a valid .Net assembly file while registering it

I am developing application with vb.net (2015) and MS Access database. I can work fine with existing database. I have now situation where I need to create database programmatically, for billing purpose. It is the situation where each folder will…
Hemu
  • 13
  • 5
0
votes
1 answer

ADOX leaving file handles open

Has anybody ever had trouble with the ADOX library leaving file handles open? I am experiencing a strange issue with a VB6 -> VB.Net conversion. There is a function that uses ADOX to look through the tables in a given database, and reset the seed…
Brian S
  • 1
  • 2
0
votes
0 answers

"msadox28.tlb File is under windows system file protection" error while attempting to build an installer

I am trying to build an installer for my project. The problem is that i am unable to successfully build the installer with the following error: ERROR: 'msadox28.tlb' should be excluded because its source file 'C:\Program Files (x86)\Common…
Thys Wentzel
  • 21
  • 4
0
votes
2 answers

Microsoft Access (mdb) : List connected Oracle tables

We are developing in Oracle ERP environment. There a quite a few view legacy MDB databases (dozens), that are connceted to Oracle views (hundreds of dependencies). In Oracle there are a custom 800+ views, that are subject to be reworked, set to…
olippuner
  • 394
  • 4
  • 16
0
votes
0 answers

Set MS Access column format using ADOX in C#

I'm trying to set an MS Accessa date/time column format using ADOX. Here's an example of my code: Column col = new Column(); col.Name = "name"; col.Type = DataTypeEnum.adDate And so far, it's working. What i need to do is setting this date/time…
Handryck
  • 9
  • 1
  • 5
0
votes
0 answers

C# Protect newly created Access Catalog with workgroup file

I'm trying to protect a Access database by using a workgroup file as user-security. The file must be in the same folder as the database and you must enter a user name and password to access the database. I read something about the parameter "System…
Scorch
  • 153
  • 2
  • 17
0
votes
0 answers

How to create a varchar(max) field in ADOX in VB6

Using VB6, MSSqlServer and ADOX, I need to create a field to store large text, and to use varchar (MAX). A [DefinedSize] property of ADOX is long. I would like to know how to set this field to varchar(max) on create. A exemple of my code: Case…
Odilton Junior
  • 41
  • 5
0
votes
2 answers

How can I use ADOX components in Delphi XE4?

I read in a tutorial written to Delphi 6 : to install ADOX components, select from the main menu Project\Add type Library menu item. But in Delphi XE4 there is not such a menu item. How could I install/use ADOX components in Delphi XE4 to create an…
The Bitman
  • 1,279
  • 1
  • 11
  • 25
0
votes
0 answers

Create MSysIMEX* ms-access tables proggramatically

I want to create a link with MS-Access MDB database with a txt file via Delphi. MSysIMEXSpecs and MSysIMEXColumns are system tables with link properties (column separator etc), but these tables are only created by Access assistant. Is there a way…
marciel.deg
  • 400
  • 3
  • 17
1 2
3
4 5