maybe it is a stupid question... Can I get access/connection to an oracle databes from ms access 2000? E.g. create a form in ms access to put data into oracle?

Yes you can. : )

1) Set up an ODBC connection.

2) Use it to link to the Oracle Database.

3) Unfortunately, all fields look like varchar(255) but that's a small price to pay for the ease and simplicity of what you can do.

Good luck.

B.Dimple
DBA