Front end/back end with different versions of access.

[Fuga]

I´ve designed a small customer db for a company.

The users have different versions of access so I´m thinking of using the front/back technique to overcome the "convert" problem.

1. Can I have the data db in A97 and the front db in either A2k or A97?

2. I´m thinking of having the tables and the queries in the back, and just the forms in the front. Is this the right way to go about it? Will there be problems with the code behind the forms?

I´m not used to this technique so any advice, however trivial, will be great?

Fuga.

 

[RichMorrison]

Yes.

Access 2000 "front end" can use
Access 2000 "back end" tables
and
Access 97 "back end" tables.

RichM

 

[pitou]

ref:Front end/back end with different versions of access

hello Fuga !

Nice to "read" somebody from Sweden.

I do not know exactly the answer to your question, but if I had been faced with the same problem I would have chosen, without hesitation, the same version of Access for the front end (FE) and back end (BE) applications.
In fact, to mix up two versions means that you will have perheaps two installations of two versions (2K or 97 or XP) on your hard disk and it is something really to avoid. That could create confusions !

As for the Front end applications, i think it is better to have the queries with the forms and all what implies treatments.

To summarize, on one hand : BE database with only datas, on the other hand : FE database with treatments (it is a kind of client/server architecture)

As for the FE database just put it on your hard disk (E.G C:\stockholm\sweden.mdb)
As for the BE database just put it on the network server.

I do not know how many users intend to use the FE database in your company ?
If it is 5 people you will have to install on their hard disk (for each of them) the FE application and to have one BE application on the network server.

Thus, all those 5 people will be able to be connected at the same time, on the same database to enter datas, for instance, in the same table .

Beware at the number of users. Do not exceed 10 to 15 users if possible, 10 should be wiser.

What else to say ? yes, just compact your BE database from time to time. Do not exceed roughly 80 M.O for your BE database, the one that contains datas.

if something remains "obscure", just reply

Pitou

 

[Pat Hartman]

This is actually a fairly common problem since most companies can't convert everyone at once. They need to do it over a period of time. From a few days to a few months. The be needs to contain ONLY tables and needs to remain in the older version until every user of the fe has been converted.