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

Run MS Access as frontend only - possible?

P: n/a
Hello,

I'm working on a proposal for migrating a set of MS Access applications
over to an Application Server setup. We would want to be capable of
running things in parallel for a bit. The idea is to migrate the
database schemata and actual data over to a different, more scalable
DBMS and keep using the existing MS Access Applications, while we
migrate the applications module by module.

The question is: is it possible to use MS Access Applications working on
a remote data source, which is an entirely different database?

Thanks a lot!
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
>The question is: is it possible to use MS Access Applications
working on a remote data source, which is an entirely different
database?


Yes. I did just what you describe, moving the data from a local .MDB
file to a MySQL database on a remote server. It works very well,
although getting the MyODBC connection to work was a bit fussy.

Nov 13 '05 #2

P: n/a
Yes.

Look at:-
Linked tables
Passthrough queries
Unbound forms

which are all things you will probably want to consider utilising in your
migration.

--
Terry Kreft
MVP Microsoft Access
"Juergen Lorenz Simon" <ju***********@mac.com> wrote in message
news:d6**********@newsreader3.netcologne.de...
Hello,

I'm working on a proposal for migrating a set of MS Access applications
over to an Application Server setup. We would want to be capable of
running things in parallel for a bit. The idea is to migrate the
database schemata and actual data over to a different, more scalable
DBMS and keep using the existing MS Access Applications, while we
migrate the applications module by module.

The question is: is it possible to use MS Access Applications working on
a remote data source, which is an entirely different database?

Thanks a lot!

Nov 13 '05 #3

P: n/a
Juergen Lorenz Simon <ju***********@mac.com> wrote in
news:d6**********@newsreader3.netcologne.de:
The question is: is it possible to use MS Access Applications
working on a remote data source, which is an entirely different
database?


Any properly designed Access database would already be doing exactly
that, even if Jet is being used as the data store (i.e., an MDB
file). It's the only rational way to design an Access application
and always has been, completely indepent of the question of server
back ends.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.