Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

MSDE

Discussion in 'Information Technology' started by Newbie, Jul 28, 2006.

Tags:
  1. Newbie

    Newbie
    Expand Collapse
    Guest

    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
     
  2. Sylvain Lafontaine

    Sylvain Lafontaine
    Expand Collapse
    Guest

    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.

    --
    Sylvain Lafontaine, ing.
    MVP - Technologies Virtual-PC
    E-mail: http://cerbermail.com/?QugbLEWINF


    "Newbie" <Newbie@discussions.microsoft.com> wrote in message
    news:15181641-032E-4A9E-AAC7-A0CE0960F36E@microsoft.com...
    > 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
    >
    >
     
  3. Sylvain Lafontaine

    Sylvain Lafontaine
    Expand Collapse
    Guest

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

    --
    Sylvain Lafontaine, ing.
    MVP - Technologies Virtual-PC
    E-mail: http://cerbermail.com/?QugbLEWINF


    "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
    wrote in message news:OGKqbKrpGHA.4116@TK2MSFTNGP03.phx.gbl...
    > 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.
    >
    > --
    > Sylvain Lafontaine, ing.
    > MVP - Technologies Virtual-PC
    > E-mail: http://cerbermail.com/?QugbLEWINF
    >
    >
    > "Newbie" <Newbie@discussions.microsoft.com> wrote in message
    > news:15181641-032E-4A9E-AAC7-A0CE0960F36E@microsoft.com...
    >> 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
    >>
    >>

    >
    >
     
  4. Newbie

    Newbie
    Expand Collapse
    Guest

    Thanks

    "Sylvain Lafontaine" wrote:

    > Sorry, my error: I should have wrote .MDF files and not .MDB files in my
    > previous posting.
    >
    > --
    > Sylvain Lafontaine, ing.
    > MVP - Technologies Virtual-PC
    > E-mail: http://cerbermail.com/?QugbLEWINF
    >
    >
    > "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
    > wrote in message news:OGKqbKrpGHA.4116@TK2MSFTNGP03.phx.gbl...
    > > 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.
    > >
    > > --
    > > Sylvain Lafontaine, ing.
    > > MVP - Technologies Virtual-PC
    > > E-mail: http://cerbermail.com/?QugbLEWINF
    > >
    > >
    > > "Newbie" <Newbie@discussions.microsoft.com> wrote in message
    > > news:15181641-032E-4A9E-AAC7-A0CE0960F36E@microsoft.com...
    > >> 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
    > >>
    > >>

    > >
    > >

    >
    >
    >
     

Share This Page