Printable View
I have a problem I want you guys to look at.
Is it possible to connect to an access database directly on the web without using DSN? I am not able to connect to the database with or without DSN. What I really wanne do is to connect through a datagrid into an access database... Can someone help me.. I need help!!!
Pet
You need some kind of data server middleware to pull this off - there's no direct connection possible over a network like this.
Yes. Switch to MSDE you can use the upsizing agent to migrate your DB. Do a search on the microsoft page to find and download MSDE - it's free.
The other thing that could be done is writing a little proggie that does the DB stuff and install it on the computer where the DB is installed. Include some winsock stuff. Write another proggie for the remote computer that uses winsock to contact the other proggie on the DB-computer. That's quite a hazzle --> use MSDE.
hth,
Helger