transport .adp from laptop to other server

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I made an .adp-file on my laptop and I want ot transport is to the
MSSQLserver on my work.
+ when I use the fucntion off access 2003 "extra" "database-utilities"
"database transport", access give me the message that there's no server
installed on my laptop. But that's no true!
+ So I used my usb-stick en copied the adp-file and the /data files to the
MSSQLserver. on the same places.
Everything seems to be ok, but when I execute an "insert into" query, I've
this message:
"- Kan de index PK_opnamegegevens niet maken.
ADO-fout: CREATE UNIQUE INDEX beëindigd omdat er een dubbele sleutel is
gevonden voor index-id 1. De meest significante primaire sleutel is 2429.
Kan beperking niet maken. Zie voorgaande fouten.
De instructie is beëindigd."
so, the server can't make a dubble key value, but I can't find the value
'2429' in the table!
I never had this problem on my laptop.
What did I wrong?

Please help me (sorry for my broken english)
 
What does exactly "transfort .adp" mean? Are you move the *.adp file to
other computer, or you meant to move the data used by *.adp file to other
computer?

*.adp, as Access Project Application, is just a file, not containing data in
database, you can copy, move, delete it without affect actual data, which is
in a SQL Server/MSDE database (*.mdf/*.ldf). If you only need to run the
*.adf from other computer, simply copy it to that computer with Access
installed. As long as the *.adp connects to correct SQL Server/MDSE
database, you should not have any problem.

My geuss is that you also has SQL Server/MSDE installed on your laptop, and
the *.adp is working with this SQL Server/MSDE. In this case, if you connect
your laptop to the network, other computers should be able to run the *.adp
file and connect it to the SQL Server/MSDE on your laptop.

If what you meant is to actaully move the SQL Server/MSDE database to other
computer, then the simple way to do it is to use Backup/Restore, or
Detach/Attach. The other computer must have SQL Server/MSDE installed. You
cannot simply copy *.mdf/*ldf file to other computer.
 
Back
Top