split database, ADO connection, what to do

[salmonella]

I hope this makes sense, I have just started to learn this stuff.

I want to split a database and presently I have ADO connections set to
CurrentProject.Connection. IF, the database will only be used locally on a PC
(FE and BE) , will this connection string work or will I need to map the data
source for each different PC it goes on once it is split?

Also, is there a problem that I need to look out for with the curser and
lock when I use the open method to open the recordset?


I am assuming that all I have to do with a split database is reset the links
to the backend tables for each PC (if drive map is different) and forget
about the ADO connection strings, cursers, etc…..I hope!


Many thanks