Hi,

I usually only use MS Access a my database manager.

BUT today I have to create a module. Well I guess.

I need to do a massive change to the values of some tables so I have to get recordsets, apply updates on many tables.

--

I'm blocked on the first lines of code which are to open a recordset.

How do I refer to the database?

In VB its: rstData.Open mySQL, myConnection
In MS Access what is it?

If I don't specify a connection is crashes, if I try to open a connection the same way I would in VB is tells me that the database is in use (makes plenty of sense, i am in the database) .

--

So basically, I need to know how to establish the connection, open a recordset.

The rest I will figure out by myself as for the syntax. I guess it is close to VB.

Thanks.