novell server crashing because of access 97

[mattsmusicpage]

Hi. I have been fixing up some access 97 programs on the computer systems at my work. The main changes I made was creating a search function using a query behind a form to search the database (no more than only 90,000 records). I am running a novell server. The data tables are in a database on the server. The access program on the desktops have their own access database program that use linked tables to the data tables on the server. The following is my issue:

Apparently, some of the changes I made to the searches caused the server buffer to become full and not flush itself. Anytime I was working on creating the fixes, it seemed to make the server crash. I 'm just wondering if anyone has had a similar problem with access 97 running on a novell server and causing any buffer issues. Any ideas on how to prevent the server from crashing?

 

[The_Doc_Man]

More likely you are running into file access conflicts. You should never make changes to a "live" database. You should always have a design master and update it, then propagate changes to the working databases from the master. Look up help topic DESIGN MASTER to see more about this.

You should also prepare to set aside some time during which you can perform simple maintenance of your DB so no other users are on. Search this forum for the topic of "Forcing User Logout" (or Logoff) and "Ejecting Users"

 

[mattsmusicpage]

still a lil confused

Hi again. I did some more research and it seems to suggest that modifying the database with others having it open should not cause problems (so long as you do not change the tables. I only made new queries and changed forms on the version of the front end database I was using. So everyone else was still using the old front end version. It just seems a lil weird it would bring the whole server down.
Also, I currently created extra front end versions for each computer by just copying and pasting the original database, not using the "replica" tool. Could this cause problems? I've never heard of the replica thing before. What is the difference?

 

[dfenton]

I don't see you mention anything about using replication, so I'm not sure what DocMan's answer is about.

You don't *want* to use replication to propagate changes to your front end -- Jet Replication works reliably only for pure Jet objects (tables/queries), and thus really only works for back end data files.

--
David W. Fenton
David Fenton Associates
http://dfenton.com/DFA/