Recent content by peej228

Sql Server Nulls passed to a Date Data Type Nulls cannot be passed to a Date data type with sql server. You can create a date in access without a value and pass that to the parameter 'For currency dim dblValue as double dblValue = val(nz(me.txtCurrency,0)) 'Pass dblValue normally dim DtValue...

SQl Insert Your missing this: docmd.runsql strsql But you should be using ADO with Parameters Sql injection is possible when you use strings to pass your values to parameters. Also excaping characters in your string must be done if your going to use strings to pass your values Ado tutorial...

Timestamp Adp problem I had the same problem and researched and found that with a access mdb microsoft recommends adding a timestamp field to the table to resolve write conflicts. However Access Adp's do not use linked tables like in an access mdb linked table I found in a different forum that...

Linked Tables install mysql odbc driver 3.51 setup odbc connection (control panel, adminstrative tools, odbc, system dsn tab) put in mysql server host name, username, password, database open access right click on the table section, select link tables, files of type select odbc, select the...

Linked Tables First intall mysql odbc driver 3.51 then setup odbc connection to mysql database (control panel, administrative tools, odbc, system dsn tab). open access then in the tables section of access right click and select link tables in Files of type select odbc the select the odbc...