A
ALMA_J_III
Hi,
I had ACCESS project:
Two Access2003 DB. In first I had forms and reports in second - Data tables.
I have worked with Table links from form MDB to Data MDB.
But situation changed - when two and more users had connect to the data MDB,
work of forms was very slowly.
I have exported Data tables to MSDE database and made Table links as ODBC
connection to the MSDE.
I have made some code changes.
The most of functions work without problem. But I have the next problem:
When I worked with data from MDB I have used autonumber fields, after
creating of new record:
DoCmd.GoToRecord , , acNewRec
I had ID field value.
In MSDE SQL I have created same increment (identity) fields. But I haven't
new ID value.
Only after going from current to previous record ID field on form I have ID
number.
I am asking about way for retrieving new record ID from MSDE DB table after
DoCmd.GoToRecord , , acNewRec statement:
Thank's
ALMA_J_III
I had ACCESS project:
Two Access2003 DB. In first I had forms and reports in second - Data tables.
I have worked with Table links from form MDB to Data MDB.
But situation changed - when two and more users had connect to the data MDB,
work of forms was very slowly.
I have exported Data tables to MSDE database and made Table links as ODBC
connection to the MSDE.
I have made some code changes.
The most of functions work without problem. But I have the next problem:
When I worked with data from MDB I have used autonumber fields, after
creating of new record:
DoCmd.GoToRecord , , acNewRec
I had ID field value.
In MSDE SQL I have created same increment (identity) fields. But I haven't
new ID value.
Only after going from current to previous record ID field on form I have ID
number.
I am asking about way for retrieving new record ID from MSDE DB table after
DoCmd.GoToRecord , , acNewRec statement:
Thank's
ALMA_J_III