I'm new at all this so i'm sorry if it's a silly question, but i've split my db into a front and back end on a server but need to copy them and put a copy onto a laptop for my boss to take somewhere. How do i copy them so that they dont look for the other one in the server folder but on the hard drvie.

For that you will need to use replication.

Hello,

I've quite same "issue" as well, all tho I would create replication from users PC to server and database is splitted as well, so what you suggest I should do? Is this replication possible to complish programmatically?

In order to have a "disconnected" backend while on a laptop, you need to use replication. You would set up the replication manually (I don't know that it can be done programmatically) by going into the backend and then using Tools > Replication > Create Replica and creating a replica on the laptop (the laptop needs to be accessible to you from the main db). Then, you can go into the database's front end and relink to the replica.

You can code your database front end to synch your replica (I've not done it programmatically so I don't know the exact syntax).

Copy that. :)

I would also recommend that you not use the Design Master as the production editing replica on the LAN. Instead, create a new replica in a safe location and transfer DM status to it. That will be your DM from then on and you'll need to do all your schema changes in it and synch with the LAN replica. You do need to synch the DM with another replica often enough to keep it from expiring, but the default retention period is 1000 days, so once a month would suffice.

--
David W. Fenton
David Fenton Associates
http://dfenton.com/DFA/