Run app + DB from CD

[rdlind]

I am wondering if there is a way to get an SQL Server DB to be accessed by an application, both on the same cd, without anything installed to the client computer.

Preferably I would like to use MSDE or something else that will work without me having to convert my DB. However, if Access has this ability that is an option.

Ideally I would also like this to be freely distributable.

Thank You for Your Time

[dinesh123]

Problem is when ur writing to the databases

for CD noprmally u can't write. So how are u going to update database with new data :confused:

[rdlind]

I'm sorry I should have mentioned that.

There is no writing needed. All I need to do is to issue Select statements on the database. No Insert, Updates, or Deletes.

[M Owen]

BUT creating a temporary table in the DB is writing to it .... I don't see any way to do what you want to do ...

[rdlind]

I am not saying the application and the DB can't use the systems memory I am just wondering if there is a way to have a DB located on a CD and access it with an app without installing anything to the client computer.

[dinesh123]

when u r opeening acces db. db it self create a tempory file saying Microsoft Access Record-Locking Information
file extension is ldb(if i 'm correct)

There fore u can't even open a access table in CD