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

Using a common DB with different versions of Access

P: n/a
I made a database (A97) for use at work and placed it on our server
with the intent that as other users acquired the program MS Access
they could access the information in it. Now..... surprise.... our
company can not find copies of A97 and has the option to get a "few
hand me down" copies of A2002. (as our managers get 2003)

Will Access 2002 be able to use this database (by adding or editing)
and "still" be available to the A97 machines?

If I split the database and keep only the "data" on the server will
this help? This was an original plan but as we never had more than (1)
copy of A97 it was never done.

What I have essentially is an index of shop drawings. Some 6000
entries with 8 fields (and 4 automatically filled in). Then, from the
switchboard one can search for (by various parameters) the details of
the drawing and if it is an electronic drawing view it. Made with
"much" help and advice from this group.

So, again, any help or advice on this potential problem will be much
appreciated.

Ralph V
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Ralph2" <no*******@hotmail.com> wrote in message
news:vj********************************@4ax.com...

Will Access 2002 be able to use this database (by adding or editing)
and "still" be available to the A97 machines?

If I split the database and keep only the "data" on the server will
this help? This was an original plan but as we never had more than (1)
copy of A97 it was never done.


Yes, if you place a mdb (preferably a mde) on each pc, that front end can be
in a97, a2000, a2002, a2003, and the back end can remain in a97. This will
allow you to function in a mixed environment.
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
http://www.attcanada.net/~kallal.msn
Nov 13 '05 #2

P: n/a
Thank you. Exactly what I had hoped to hear. A good project for this
rainy labor day weekend.

On Sat, 04 Sep 2004 19:42:54 GMT, "Albert D. Kallal"
<Pl*******************@msn.com> wrote:
"Ralph2" <no*******@hotmail.com> wrote in message
news:vj********************************@4ax.com.. .

Will Access 2002 be able to use this database (by adding or editing)
and "still" be available to the A97 machines?

If I split the database and keep only the "data" on the server will
this help? This was an original plan but as we never had more than (1)
copy of A97 it was never done.


Yes, if you place a mdb (preferably a mde) on each pc, that front end can be
in a97, a2000, a2002, a2003, and the back end can remain in a97. This will
allow you to function in a mixed environment.


Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.