Thanks Graeme.

I was afraid of that (nicknames).

I was under the impression that the order of replication was determined by the order in which the objects are added to the publication,...

You're right about the PK not being replicated before the child. What do you mean by "nickname" and where does one set it?

Also, how do you ensure parent tables get...

Go with replication. Transactional or Merge will be fine. Create either a push subscription from the main server to your backup server or a pull subscription the other way. Set...

Don't dismiss Access so quickly without knowing the details of the required application. Depending on the needs of the company and what they want to do, Access could well be...

I'm not sure truncating will work on tables linked by referential integrity. You can either drop all constraints first, or delete the records from child tables first, then move up...

That looks about the way I would do it. Just make sure you can re-name a uniqueidentifier column and reset it as a primary key before you start - I'm not...

You will need to add a field to the "inventory item" table to hold the primary key of the "sales order item" table. When an inventory item is placed on...

I think you have the wrong syntax for ISNULL. That function requires two parameters.

I believe you still need to supply the username 'admin' even though no password is set for the admin user.

You could use SQL Login authentication - however, the same problem of the "open computer" would still exist. If a user logged into the Application/SQL Server and left it open...

Prasad assumed you would pass the value in as a parameter to the stored procedure. If this is the case, your SQL command to run the SP would look like:

        ...

You do development on your production machines?

Have you tried setting "Record Locks = No Locks" on the "Other" tab of the report design properties in Access. You really only need "read only" access to data showing on...

The user needs rights to run xp_cmdshell or you have to set up a proxy user for the SQL Agent.

I think you need to set up a "proxy" user in the SQL Server Agent properties. The proxy user should be a "windows" user that has permissions to run Agent.