473,326 Members | 2,173 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Run MS Access as frontend only - possible?

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
3 1547
>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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Markus Ernst | last post by:
Hi I build a small content management system. I use different external stylesheets for the admin section and the frontend, called admin.css and frontend.css. Now I would like to preview some...
10
by: John Phelan | last post by:
I read an article by, by Mike Groh, in Access-VB-SQL Advisor Magazine, Week 37 that concerns me quite a bit on distributing Access Applications commercially. First I need to describe a "commercial...
4
by: Squirrel | last post by:
I've developed an Access 2002 database which will be deployed with the backend on a server and frontend on the users' PCs. I've now been advised that new employees will be given laptops with...
4
by: Trollina | last post by:
I have a medium sized Access 2000 database that has been split into front end/back end. I need some help understanding what to do when I add new tables to the database that I want on the network...
13
by: Manuel Lopez | last post by:
I have a puzzling form timer problem that I didn't experience prior to Access 2003 (though I'm not sure access 2003 is to blame). Here's the situation: a computer has two access 2003 databases on...
13
by: Zlatko Matić | last post by:
Is it possible to use Access as front-end for POstgreSQL and how ? What about Access Projects (.adp) and PostgreSQL ?
1
by: dfaul | last post by:
I have tested using a single .ADP file on a Win 2003 TS server, and have multiple people access this file. The backend is SQL. As I suspected, the 2nd user gets a Read-Only warning on the .ADP...
2
by: Peter Neumaier | last post by:
Hi NG! I am using within an ACCESS-Project an Access 2000 frontend to access data from a MS SQL SERVER 2000. I am wondering if it possible to create a _real_ .NET-Application from this ACCESS...
2
by: Gary | last post by:
I have the backend database on a network drive. There are 3 employees that access this backend database through their respective frontend databases (located on their respective C drive). One of...
6
by: Mark | last post by:
Currently using MS Access 2000 and SQL Server Express. Using the current DAO OpenRecordset code listed below, however I keep getting the error message.... 3254: ODBC --Cannot lock all records ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.