Access Runtime .adp To MSDE?

  • Thread starter Thread starter Medhat Nasr
  • Start date Start date
M

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
 
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
 
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
 
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
 
Back
Top