Access Runtime .adp To MSDE?

[Medhat Nasr]

Hi group,

For a single desktop computer that hasn't Access retail package installed :

How can I possibly manage attaching a SQL Server 2000 Database files to an
installed instance of SQL Server 2000 Desktop Engine (MSDE) - to which , an
Access 2002 Runtime-(.adp) or (.ade) should've been connected in developing
time?

For more detail :

1. I usually manage the (.adp)'s connection , while developing , through the
File-Connection command in Access menu.

2. Also, when I installed the Access 2002 Runtime-(.adp) or (.ade) , on a
new machine that has a SQL Server 2000 already installed , I could modify
that Access 2002 Runtime-(.adp)'s connection through some VBA code in a
Login-Startup Form ; and I could have the new connection working - only
after I attached the relevant SQL database files to the running SQL Server
2000 on that machine using its Enterprise Manager.

3. Now, my specific question is : how can I do so on a machine that has a
MSDE rather than a SQL Server 2000 installed?
In other words, how can I attach the relevant SQL database files to the only
MSDE instance available on that machine?

If this is possible, it'd matter a lot.

Thank you all.

Medhat Nasr

 

[TF]

look at :
http://groups.google.fr/groups?hl=f...&selm=eGD6%24lHqBHA.2412%40tkmsftngp03&rnum=1

 

[Medhat Nasr]

Hi TF,

Thanks for the great link.
Unfortunately, It didn't answer my question!
Maybe because my question wasn't clear after all, so let me refine it :

I don't have problems with setting or changing the .adp connection on the
user machine, my real problem is how to properly attach the relevant SQL
Database files ( e.g. ProSysSQL.mdf and ProSysSQL.ldf ) to MSDE, the way
I can do with SQL Server Enterprise Manager.
Simply, if I could do that , my problem is solved!

Thank you in advance.

Medhat Nasr

 

[Kevin3NF]

Have you looked at running sp_attach_db from the command line (via osql)?

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

 

[Medhat Nasr]

Hi Kevin,

Thanks a lot, this is what I'm going to do right now, and I know , for sure,
it's going to work !

By the way, I've already found some good resources on that regard through
Microsoft Knowledge Base Articles Nos. 290623 ,299297 and 301413 - if any
SQL Server
beginner , as myself , could be interested .

Thanks again ,

Medhat Nasr

 

[Medhat Nasr]

Hi Kevin,

Thanks a lot, this is what I'm going to do right now, and I know , for sure,
it's going to work !

By the way, I've already found some good resources on that regard through
Microsoft Knowledge Base Articles Nos. 290623 ,299297 and 301413 - if any
SQL Server
beginner , as myself , could be interested .

Thanks again ,

Medhat Nasr