Printable View
Dear VB users,
I know this is not a question for this VB forum.
Trying:
Is it possible to use in the ASP code any DAO functionallity to get information from a database.
Because it is not possible to get with ADO all access field properties.
Are there any sites/source who can give information?
Nice regards,
Michelle.
What properties are you trying to get? Because using ADOX and ADO you can pretty much get all atributes for the property.
Hello Serge,
Thanks for reading my question.
To get information about the “DisplayControl” I allways use in DAO the next source:
------------------------------------------------
Dim DB As Database
Dim TD As TableDef
Dim VV As Byte
Set DB = OpenDatabase("c:\db1.mdb")
Set TD = DB.TableDefs("table1")
VV = TD.Fields(0).Properties(23).Value
------------------------------------------------
The number 23 is used to get information of the “DisplayControl”.
VV = 109: TextBox
VV = 110: ListBox
VV = 111: ComboBox
Please can you give me the source for ADO for this code, to get get this information?
Nice regards,
Michelle.
Ohh now I see what you mean. Unfortunately, you can't get this information with ADO. When you use DAO it uses many Access built functions that allow you to get information about appearance of your data. It gives you ablitity to control Access application itself. DisplayControl is a property that tells Access how you want to see data in the table.
ADO mainly based on OLEDB and doesn't know what Access exposes as an application, because it focuses on a database only.
By the way, why do you need to get this information? If you're developing your own front end, then it wouldn't matter any way.
Regards,
Hello Serge,
Thanks for your reaction.
We are trying to fill a database via internet.
The fillin structure on internet must be the same as the structure of the database.
For example: Default values / List-ComboBoxes.
Via the database structure we will make an asp file.
Do you think there is a more simply way to do this?
Nice regards,
Michelle.