Does any one have a nice piece of code for creating Tables and Fields using RDO methodology?
I know DAO or ADO is better, but unfortuately I have to use RDO.
Can any body please help????!!!!!
:confused:
Printable View
Does any one have a nice piece of code for creating Tables and Fields using RDO methodology?
I know DAO or ADO is better, but unfortuately I have to use RDO.
Can any body please help????!!!!!
:confused:
Quote:
Originally posted by djrmkr
Does any one have a nice piece of code for creating Tables and Fields using RDO methodology?
I know DAO or ADO is better, but unfortuately I have to use RDO.
Can any body please help????!!!!!
:confused:
what database engine are you using?
I'm using an msaccess97 MDB. I'm using RDO references to access the data
eg.
myconnection.rdocolums("ID") = MYID
I need to create some new tables and feilds so I can add some new functionality to my program. But I don't want the user to create the tables and feilds themselves. (to higher risk of them stuffing it up)
I don't want to add another file (system.mdw) to the list of files installed with the software.
P.S (I'm planning on upgrading it to SQL server, which means I can then use the ADO references, Problem solved, but for now I'm stuck with RDO.
Quote:
Originally posted by djrmkr
I'm using an msaccess97 MDB. I'm using RDO references to access the data
eg.
myconnection.rdocolums("ID") = MYID
I need to create some new tables and feilds so I can add some new functionality to my program. But I don't want the user to create the tables and feilds themselves. (to higher risk of them stuffing it up)
I don't want to add another file (system.mdw) to the list of files installed with the software.
P.S (I'm planning on upgrading it to SQL server, which means I can then use the ADO references, Problem solved, but for now I'm stuck with RDO.
Stuck RDO?? Why not DAO?
Including DAO, means another reference (Not a big issue), However I need to use the command
SystemDB.Engine = ???????????
And I don't know where the system.mdw file will be located on various machines.
It also doesn't regonise that fact the I want to change the path to the SystemDB to something like:
SystemDB.Path = App.Path & "\system.mdw"
Which is why I want to use RDO. I know there is a command in RDO that is similar to the DAO command, but uses the RDO connection methods.