how i can use Access Database in my application

ranakdinesh · April 16th, 2004, 04:12 AM

i have a Access database on our Website is it possible to access that database without downloading it so that i can genrate crystal reports using an application on my machine

dinesh Rana

predal · April 27th, 2004, 03:39 AM

I don't belive that is posible. When usin the net you should use MySQL databases.

Lucian Preda
[email protected]

ranakdinesh · April 27th, 2004, 05:12 AM

thanks for your reply. but this is possible and during the course of time i have done this and still working on it. the root is A
CCess Database->asp.net uning Ado.net ->XML ->ADo.net of Application->XML ->XML-CrystalReport i know this is a long process but till the time it is working fine reducing my time to download the data. in this case if you find any further solution Please Let Me Know

dinesh Rana

gschretter · May 21st, 2004, 01:47 PM

You got me thinking here.

Why not pop open and IE form. Pass the parameters to a ASP page.

The asp page return the requested data in the IE form.

VB reads in the IE form body and there is your result.

Tell if this works.

bmains · May 21st, 2004, 03:06 PM

Hello,

You can get to an access database in code. Never tried crystal reports, but I would imagine that it could happen. I've ran into problems trying to get to an access database on another server though...

Not sure if this is the answer that you are looking for?

Brian