B
Bill
Hi,
i just upgraded from access xp to adp with SQL backend. A couple of issues
i need help on URGENTLY:
1. i have managed to convert all my previous database
connection/interactivity to use adodb. eg:
On database startup i have:
Dim cnn As ADODB.Connection
Set cnn = New ADODB.Connection
cnn.Open ConnString
and when accessing underlying forms from vba code:
dim rst as new adodb.recordset
rst.activeconnection = <connection string>
where connection string is:
"Provider=Microsoft.Access.OLEDB.10.0;Persist Security Info=True;Data
Source=SQL;uid=***;pwd=***;Initial Catalog=ERGON Test;Data
Provider=SQLOLEDB.1"
the performance is now very slow. i think i am doing it wrong. Could
somebody PLEASE tell me what string i should use (if any), or the correct
way to connect to my sql database. I am a bit confused about the difference
between ADO, OLEDB, DAO etc... which doesn't help the issue. I would
appreciate if you simply treated my like a complete idiot and explain so
that i would understand.
2. the autonumber field in access works great. eg: when i open a form to
add a new record (whose underlying datasource is a table), as soon as i
start entering details into the new record, the autonumber is generated at
that instance. When using the ADP, the autonumber defaults to '1' until I
physically close the form. How can i get this number to be updated
immediately, as i refer to this particular identity field on the form to
perform lookups and other associated data entry?????
I am very confused...
Thanks for your help.
Bill
i just upgraded from access xp to adp with SQL backend. A couple of issues
i need help on URGENTLY:
1. i have managed to convert all my previous database
connection/interactivity to use adodb. eg:
On database startup i have:
Dim cnn As ADODB.Connection
Set cnn = New ADODB.Connection
cnn.Open ConnString
and when accessing underlying forms from vba code:
dim rst as new adodb.recordset
rst.activeconnection = <connection string>
where connection string is:
"Provider=Microsoft.Access.OLEDB.10.0;Persist Security Info=True;Data
Source=SQL;uid=***;pwd=***;Initial Catalog=ERGON Test;Data
Provider=SQLOLEDB.1"
the performance is now very slow. i think i am doing it wrong. Could
somebody PLEASE tell me what string i should use (if any), or the correct
way to connect to my sql database. I am a bit confused about the difference
between ADO, OLEDB, DAO etc... which doesn't help the issue. I would
appreciate if you simply treated my like a complete idiot and explain so
that i would understand.
2. the autonumber field in access works great. eg: when i open a form to
add a new record (whose underlying datasource is a table), as soon as i
start entering details into the new record, the autonumber is generated at
that instance. When using the ADP, the autonumber defaults to '1' until I
physically close the form. How can i get this number to be updated
immediately, as i refer to this particular identity field on the form to
perform lookups and other associated data entry?????
I am very confused...
Thanks for your help.
Bill