Keep recordset open from Db start-up until Db closing

[jayke]

Hi,

I have read some posts about splitting the DB and I am going to use this for my Database. Currently I open a recordset when the Database is opened and I close the recordset when I shut down the form/Database.

Now my question:
- Is this smart? Can it corrupt my database when more users open the Database and all of them have a recordset open during their session.

- What if one user eddits a record and the other is browsing through the records?

- Is it better to always close and reopen the recordset after an action? I think that by doing this the performance will extremely decrese...?

Can someone help me?

grtz jayke

 

[modest]

Don't we just love recordset clones