Hi,
Does anyone know how I can connect to an MSDE db using VB with a
read-only file? The file will be on a CD, and is actually just archived
data off a SQL server. I would like to package my app on a CD along
with the data file and allow users to pop in the CD and run the app,
assuming they already have MSDE running. Any help?

Thanks,
Jason

hi Jason,
"Jason" <jnorsworthy@etrade.com> ha scritto nel messaggio
news:1104275382.477692.322310@z14g2000cwz.googlegroups.com
[quoted text, click to view]

actually this is possible, providing you mark the database as available on
CD using system stored procedure sp_create_removable and
sp_certify_removable...
this method requires at least 3 physical files, 1 database system data file
that MUST reside on read/write device, 1 data file that will contain all
application's data and that will reside on the removable device, and 1
transaction log file....

please have a look at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_03_92hx.asp
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply