How do I copy a adp database to a server?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Edmund Mather - 28 Apr 2006 17:57 GMT

I have developed an access project on my laptop, and wish to transfer it to a
server. So uses on the network can use the database on the server, from there
PC's.

Reply to this Message

Sylvain Lafontaine - 28 Apr 2006 20:37 GMT

You can make a backup/restore or detach the database, copy the files .LDB
and *.MDF to the server and re-attach the database.

If you want to continue the development on your laptop then the use of a
synchronising tool like Red Gate SQL-Compare will be a real time saver.

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

>I have developed an access project on my laptop, and wish to transfer it to
>a
> server. So uses on the network can use the database on the server, from
> there
> PC's.

Reply to this Message

Edmund Mather - 29 Apr 2006 14:55 GMT

Thanks for your reply Sylvain.
I am unable to use a backup as the server does not have access loaded. I
found the .LDB and .MDF files on my laptop. There are 2 that are the same
name as my database, do I also need the others that have been updated at the
same time? That is the mastlog.ldf, master.mdf, msdblog.ldf, msdbdata.mdf,
modellog.ldf, model.mdf files? I have not as yet detached or re-attached a
database, I will have to do some work on this, are you able to give me any
pointers. Kind regards, Ed.

> You can make a backup/restore or detach the database, copy the files .LDB
> and *.MDF to the server and re-attach the database.
[quoted text clipped - 7 lines]
> > there
> > PC's.

Reply to this Message

Sylvain Lafontaine - 29 Apr 2006 19:04 GMT

Even if you don't have Access, you can use SQL-Enterprise manager or any
tool that will execute SQL code. (The latest incarnation of SQL Server 2005
Management Studio Express (SSMSE) might be the ticket for you but I didn't
try personally:
http://www.microsoft.com/downloads/details.aspx?familyid=4C6BA9FD-319A-4887-BC75
-3B02B5E48A40&displaylang=en
.)

You only need the 2 files that have the same name as your database. (In
fact, only the .MDF is really necessary - especially if you are using the
simple recovery model - but it's simpler to go with these two files.)

See http://www.15seconds.com/issue/050127.htm for more informations,
particularly the other links at the bottom of this article.

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

> Thanks for your reply Sylvain.
> I am unable to use a backup as the server does not have access loaded. I
[quoted text clipped - 18 lines]
>> > there
>> > PC's.

Reply to this Message