access 97 and access 2000 problem/question...

  • Thread starter Thread starter warpman
  • Start date Start date
W

warpman

We currently have an access 97 database. We have come
accross a problem were we have a couple of users with
access 2000 and others with access 97. The access 2000
users can not make any type of changes to the database. Is
there a way to fix this without having to change the
database from 97 to 2000 or with out having to upgrade all
the users to 2000? Any help would be greatly appreciated.
 
Are you familiar with the "Runtime Version" (a.k.a.
Developer's Edition) of Access? If your Access
programmer has this software, s/he can build you the
runtime environment for your Access 97 DB and you can run
it on any Windows system (95 and above) regardless of the
version of MS Access on the computer or if you do NOT
have MS Access on the computer at all.

Denny G.
 
Do you mean the data or the *design* (Forms, Reports, etc...) of the
database?

If data, all users should be able to.

If *design*, A2K cannot change the design of the database in A97 file
format. Only A97 users can change change the design of A97-file-format
database files.
 
warpman said:
We currently have an access 97 database. We have come
accross a problem were we have a couple of users with
access 2000 and others with access 97. The access 2000
users can not make any type of changes to the database. Is
there a way to fix this without having to change the
database from 97 to 2000 or with out having to upgrade all
the users to 2000?
Click to expand...

When you say changes presumably you mean to a query, form or report.
And not the actual data. You can't change an A97 MDB from A2000 or
newer.

But the users shouldn't even be changing it themselves anyhow. This
change will affect everybody. Even if it was possible, which it is in
A97, this can cause you troubles and possible corruption.

You want to split the MDB into a front end containing the queries,
forms, reports, macros and modules with just the tables and
relationships. The FE is copied to each network users computer. The
FE MDB is linked to the tables in the back end MDB which resides on a
server. You make updates to the FE MDB and distribute them to the
users, likely as an MDE.

See the "Splitting your app into a front end and back end Tips" page
at http://www.granite.ab.ca/access/splitapp/ for more info. See the
Auto FE Updater downloads page
http://www.granite.ab.ca/access/autofe.htm to make this relatively
painless.. It also supports Terminal Server/Citrix quite nicely.

You also give the A2000 users an A2000 version of the FE while the A97
users get an A97 copy of the FE.

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
-----Original Message-----
We currently have an access 97 database. We have come
accross a problem were we have a couple of users with
access 2000 and others with access 97. The access 2000
users can not make any type of changes to the database. Is
there a way to fix this without having to change the
database from 97 to 2000 or with out having to upgrade all
the users to 2000? Any help would be greatly appreciated.
Click to expand...
OK. I guess I should be more clear. What we have is the
following. There are 2 people who have access 2000. I have
access 97. We use access to keep track of our pc hardware
and software inventory. Either one of these 3 people are
authorized to make changes. Well, the database was created
using access 97. Now the people who have access 2000 can
not make any changes to any of the "items" within the
database. I'm talking about the tables, queries, reports,
etc... we don't want to convert the database to 2000 yet.
Don't ask why that is how it is... Any how, thanks so much
to all of you for your help.
 
See the last paragraph of my previous reply since you are talking about
changes to the *design*, i.e. A2K0 cannot change the design of database
objects in A97-file-format database.
 
Back
Top