Im doing a project named “Activex employee builder” using VC++ with MS Access.
In my project when the user types the employee name in textbox , the details of the employee popups in as floating menu.
The Details r obtained at runtime from the database,.The details includes “Email
Of the employee” . I would like to know how can I use “ mailto” utility of HTML into the Floating menu at runtime. Should I use DHTML?
How can I get the information about the tables. I know there is a system table named MSysObjects. But this table just gives the names of the tables in the database. I want information about the fields in the tables. Like field name, field length, nullable or not and so on.
I would greatly appreciate if you tell me, in which system tables this information is stored. As in case of Oracle the metadata about all columns in tables is stored in a system table named as USER_TAB_COLUMNS. We can get information about the field of a table from this table. There must be a similar way in access too.
I have never been a formal computer student so my knowledge about programming or databases is just like that of a layman. I have just designed my website by using wizards of MS Frontpage. I have a search page on that website. I want that search engine to search from some of my folders and display the results in a list like the most search engines do.
Please tell me how can I do it. I don't have a large database. It is just short list of the .mpg files that I have on my computer. Please consider while replying that I do not understand the languages or codes like what you say VB or OBDS etc.
I'm using a ODBC Access database (I steered clear of DAO, since I was advised it was not part of UDA and therefore not as future-proof) and cannot seem to get rid of the deleted record fields. I have a file that is 600K, but when viewed in Access only contains one record. This is due to the number of additions and deletions this database has had performed on it.
I know that DAO has a nice CompactDatabase method, but can I do the same thing for my ODBC database?
I am using CRecordset::open
with the following query:
WHERE (([Mytable]![Field2] In (SELECT Field2
ORDER BY Field2"
i am getting an exception as follows:
Too few parameters. Expected 2.
State:07001,Native:-3010,Origin:[Microsoft][ODBC Microsoft Access Driver]
First-chance exception in PRP.exe (KERNEL32.DLL): 0xE06D7363: Microsoft C++ Exception.
I am new to database programming.
Please help me.
any help would be greatly appreciated.