MSDE

N

Newbie

Hello,

I am new for MSDE.

Our ISA2004 server has report in *.mdf and *.ldf format.
We don't have SQL server. I installed MSDE on my workstation.

Is there any step-by-step instruction to show me, how to create Access
Project to view the ISA2004 report?

Thanks
 
S

Sylvain Lafontaine

MSDE is the free version of the SQL-Server. They are both using .mdb and
..ldf for their database files and you can detach a database from SQL-Server,
copy the .mdb and .ldf files and reconnect them directly to MSDE; at the
condition that the size of the database is under 2Gigs.

Instead of detaching/copying/reattaching the database, you could also make a
backup/restore process.

However, you will have one problem with MSDE: it doesn't have a graphical
interface so you must use a command line utility such as osql or you must
install the graphical interface (also called the Enterprise Manager or the
client tools) of SQL-Server on your machine.

If you don't have a commercial version of SQL-Server, then you can buy the
developer version of SQL-Server 2000 (around 50$) or try with the SQL Server
Management Studio Express; which is for SQL-Server 2005 Express but should
work equally well with MSDE or SQL-Server 2000:

http://www.microsoft.com/downloads/...AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

If you have questions, then you can post in the m.p.sqlserver.msde
newsgroup. There is also a newsgroup for ADP: m.p.access.sqlserver.adp .

Now for your reports under ISA2004: I absolutely don't know anything about
them. MSDE is a database and doesn't have any integrated reporting
functions. SQL-Server 2005 has something about that but it's not a standard
installed component of ISA2004.
 
S

Sylvain Lafontaine

Sorry, my error: I should have wrote .MDF files and not .MDB files in my
previous posting.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top