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