I am looking for some code that would transfer data from a database on a person's desktop to a database on a central network server (either adding new records or updating existing records).

I don't want to just link tables, that would be too cumbersome and I don't want everyone just working off of the central database because there are too many users.

Can anybody help?

Thanks in advance.

Linking tables is not cumbersome.
and I don't want everyone just working off of the central database because there are too many users - The problem is the number of concurrent users, not the number of potential users. If you have too many concurrent users, a code solution won't necessarily help you. If you really have too many users, Jet is a poor choice for your tables. Use DB2 or SQL Server or Oracle. The front end can still be Access. Access works very well with linked ODBC tables.

No one is going to be able to offer much of a code solution without any details. You can run append queries to add new records or update queries to update existing records. If you are intent on using disconnected recordsets, you are in for a lot of coding. You'll need to reproduce all the things Access does for you with bound forms.