problems running access 97 db over network on machine using access 2000

problems running access 97 db over network on machine using access 2000

Post by Steven Sca » Sat, 10 Jan 2004 00:33:59


I have a database on the server built in access 97. I am trying to run it
over the network on a machine that has got access 2000 installed.

The problem lies in the activex components i have used. The word 8.0 object
model was used in the development. I thought that because i am running the
database over the network from the servers hard drive the database will
check on the server for the component and not on the local machine, which is
what it appears to be doing.

Does anyone know of a way to make the database work as it should.

TIA
 
 
 

problems running access 97 db over network on machine using access 2000

Post by Norman Yua » Sat, 10 Jan 2004 01:25:25

What exactly the problem you have?

Just to verify your doubt: yes, the application is actaully run in local
computer, all components the app references must present in local computers.
It sounds that you did not split the Access app into two parts of front end
and back end. In this case, a *mdb file contains both data part (mainly,
tables) and application part (forms, reports, queries...). Although the file
is located on a server computer, when user runs it, the application part is
read into client computer and runs locally (that is why you need to install
Access on all clients computers), data part may or may not entirely be read
into local computer, depending how the tables/queries is designed/performed.

It becomes clearer if you split the app into front/back end: the fron app is
installed locally, so all referenced components are required to be present.

Note, it is alway good practice to split Access app into front/back end,
especially if you have more users than just 2 or 3. It makes backup easier,
reduce the chance of data corruption, and prevent your code from altering
(by making front end a *.mde file)...



object
the
is

 
 
 

problems running access 97 db over network on machine using access 2000

Post by Steven Sca » Sat, 10 Jan 2004 01:39:07

The database is the back end database the front end is an intranet site
built in ASP. The secretary needed a bit of automation between word and
access and i forgot about the split between front and back end. I'll just
have to write a few front ends for the different versions. Shouldn't be a
problem i'll just re-use the code

thanks for your help




computers.
end
file
is
install
read
designed/performed.
is
present.
easier,


it
which