By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,316 Members | 2,355 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,316 IT Pros & Developers. It's quick & easy.

Host mdb file question

P: n/a
Jim
Is there a way to access a mdb file remotly via MS access?

I have a application that I'll need to us access for reporting.
and local updating

I'd like to keep the mdb file (data file) on a server hosted by
another company so that I can use asp for the web site hosted there.

Is there a way to connect to the mdb file just like you might a SQL
server?

Jim
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Jim wrote:
Is there a way to access a mdb file remotly via MS access?

I have a application that I'll need to us access for reporting.
and local updating

I'd like to keep the mdb file (data file) on a server hosted by
another company so that I can use asp for the web site hosted there.

Is there a way to connect to the mdb file just like you might a SQL
server?

Jim

No[1]. You might see if you can use Remote Access or VNC to control a
PC/Server local to the MDB.

[1] Well actually, a VPN connection would do it but have you ever
started a new job and been sent to the stores to ask for a long weight?

--
But why is the Rum gone?
Nov 12 '05 #2

P: n/a
Jim,
Later versions of Windows--2k, XP & so on, do a better job of presenting the
contents of folders on a web server in standard Explorer window. Pretty
much if Windows can connect to it, Access can too. Also, ODBC or its
current equivilant, is rather good at presenting to Access data as tables
from lots of formats & locations. So, short answer--it isn't hard to do
what you want.

There are issues around Jet's ability to support a limited number of
concurrent connections to an .mdb that have been discussed here previously.
The argument boils down to capacity--if your transaction volume is low
enough Jet will do fine. If you anticipate exceeding roughly a dozen or so
concurrent connections then it may be worth investigating a different rdbms
server engine.

"Jim" <go****@whatifcomputers.com> wrote in message
news:39**************************@posting.google.c om...
Is there a way to access a mdb file remotly via MS access?

I have a application that I'll need to us access for reporting.
and local updating

I'd like to keep the mdb file (data file) on a server hosted by
another company so that I can use asp for the web site hosted there.

Is there a way to connect to the mdb file just like you might a SQL
server?

Jim

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.