Hi,
I have developed a sql server 2000 database with an Access 2003 (adp) frontend for one of my local hospitals.
Since its installed on the hospital WAN, and contained patient information, the hospital IT department cannot send a copy of the data by email,post or any other media.(My access to their WAN is still pending)
So to keep the development database uptodate I have to go onsite and obviously with user login restriction, from the client front end I can only copy the tables, plus the data and export them to an access (mdb) database.
Can anyone direct me on how to get this data back into the development SQL database back in the office, in the correct sequence without altering autonumbers, without having to resort to temporarely alterning the SQL relationships, transfering the data and reseting the links.
Any help would be appreciated