PDA

View Full Version : ODBC Connectivity and MS Acess



LasseJ
8-Sep-2005, 02:28 AM
Hi group!

I've been asked to convert a couple of DF datafiles to an Access DB. I'm
really a beginner in this area so bear with me.

Two problems:

1. An Access Autonumber field, used as the primary key, seems to not get
saved. At least I can't see any number in that field in the debugger. I
found a KB article about this and have set PRIMARY_INDEX_TRIGGER YES and
DUMMY_UPDATE_COLUMN 2 in the INT-file. No luck!

2. Then I started DBExplorer and could see several new records. ( se
attached) So I checked the table in Access (see attached). That was a
surprise. I've obviously missed something, but what?

Regards
Lars J
OA SYSTEM AB

LasseJ
8-Sep-2005, 02:29 AM
Oops! forgot attachment...
/L
"Lars Jarnhäll" <lassej@oasystem.se> wrote in message
news:Wus4hbEtFHA.4048@dacmail.dataaccess.com...
> Hi group!
>
> I've been asked to convert a couple of DF datafiles to an Access DB. I'm
> really a beginner in this area so bear with me.
>
> Two problems:
>
> 1. An Access Autonumber field, used as the primary key, seems to not get
> saved. At least I can't see any number in that field in the debugger. I
> found a KB article about this and have set PRIMARY_INDEX_TRIGGER YES and
> DUMMY_UPDATE_COLUMN 2 in the INT-file. No luck!
>
> 2. Then I started DBExplorer and could see several new records. ( se
> attached) So I checked the table in Access (see attached). That was a
> surprise. I've obviously missed something, but what?
>
> Regards
> Lars J
> OA SYSTEM AB
>
>

LasseJ
12-Sep-2005, 06:59 AM
Forget it, my mistake!
/Lars
"Lars Jarnhäll" <lassej@oasystem.se> wrote in message
news:Wus4hbEtFHA.4048@dacmail.dataaccess.com...
> Hi group!
>
> I've been asked to convert a couple of DF datafiles to an Access DB. I'm
> really a beginner in this area so bear with me.
>
> Two problems:
>
> 1. An Access Autonumber field, used as the primary key, seems to not get
> saved. At least I can't see any number in that field in the debugger. I
> found a KB article about this and have set PRIMARY_INDEX_TRIGGER YES and
> DUMMY_UPDATE_COLUMN 2 in the INT-file. No luck!
>
> 2. Then I started DBExplorer and could see several new records. ( se
> attached) So I checked the table in Access (see attached). That was a
> surprise. I've obviously missed something, but what?
>
> Regards
> Lars J
> OA SYSTEM AB
>
>