How can access mdb ?

manuo5

HI , We have one webapplication which using this mdb file and this mdb file reside in website folder,we donot know physical path of website and we are creating another window based aplication and want to use this mdb in my window aplication .How it is possible ? Please give me some Suggestion .Its urgent Manu Sharma

pmarfleet

Is this an Access database? Paul

manuo5

yes this an Access database .

pmarfleet

A connection string for an Access database requires the physical path to the database file to be specified. Paul

manuo5

Problem is that website host in another server .so we donot know physical path of mdb .

pmarfleet

I don't think there is an easy solution to your problem. You should probably consider migrating your database to SQL Server or something similar. Paul

manuo5

Thanks but web Aplication running now so it is not possible . Manu

Paddy Boyd

How come you don't know the physical path to the webserver? Is it not on your network? Do you need access to all the data in this database file? If you only need a small subset, you could create a couple of webservices to return the data you require, although this becomes very cumbersome for more than a couple of queries.

manuo5

Thanks for reply it is not on your network ,it is another server not on my network.I know Ip of this server only and name of mdb file . we want to fetch subset of all tables userwise data .

Paddy Boyd

So it's on another network that you don't have direct access to? I don't think you will be able to directly access this database.

manuo5

They also provide one usename with full access on this mdb then it is possible to access or not ? Manu

Paddy Boyd

Yes, but if you can't actually access the network to get to the mdb file to try and login to the DB with the provided username, it's not really going to help you, is it?