I have recently posted a new access database and its oracle tables onto a shared folder for various users. It is a search database and me and a few other users are able to pull from the file and use it perfectly. But, when other users pull from the shared folder they suffer from dragging performance and then the fields within the forms error to "#Name?" and an "Object Invalid or No Longer Set" error button comes up.
Seeing as though we are all using the same database, I have tried to make sure the users with the error are using the correct, updated copy of the database. I have tried running an oracle driver update to make sure they have the correct mapping. I created this file on XP and it's access 2003. The users also have access 03. I feel like it shouldn't be a coding issue seeing as though the database itself works on some computers and not on others. I'm leaning towards a Microsoft Jet database situation? I don't believe it is a memory situation either, as that might explain the slow performance on some users databases, but not the errors. I am hoping to see if anyone has an idea as to why the database works perfectly on some computers and errors out after a couple searches on others. Thanks!
3  4132  
I have recently posted a new access database and its oracle tables onto a shared folder for various users. It is a search database and me and a few other users are able to pull from the file and use it perfectly. But, when other users pull from the shared folder they suffer from dragging performance and then the fields within the forms error to "#Name?" and an "Object Invalid or No Longer Set" error button comes up.
Seeing as though we are all using the same database, I have tried to make sure the users with the error are using the correct, updated copy of the database. I have tried running an oracle driver update to make sure they have the correct mapping. I created this file on XP and it's access 2003. The users also have access 03. I feel like it shouldn't be a coding issue seeing as though the database itself works on some computers and not on others. I'm leaning towards a Microsoft Jet database situation? I don't believe it is a memory situation either, as that might explain the slow performance on some users databases, but not the errors. I am hoping to see if anyone has an idea as to why the database works perfectly on some computers and errors out after a couple searches on others. Thanks!
This might be a shot in the dark, but have your tried reparing?
Also, how big is the mdb. anything over 1GB makes problems. Try shrinking the mdb in that case.
I have recently posted a new access database and its oracle tables onto a shared folder for various users. It is a search database and me and a few other users are able to pull from the file and use it perfectly. But, when other users pull from the shared folder they suffer from dragging performance and then the fields within the forms error to "#Name?" and an "Object Invalid or No Longer Set" error button comes up.
Seeing as though we are all using the same database, I have tried to make sure the users with the error are using the correct, updated copy of the database. I have tried running an oracle driver update to make sure they have the correct mapping. I created this file on XP and it's access 2003. The users also have access 03. I feel like it shouldn't be a coding issue seeing as though the database itself works on some computers and not on others. I'm leaning towards a Microsoft Jet database situation? I don't believe it is a memory situation either, as that might explain the slow performance on some users databases, but not the errors. I am hoping to see if anyone has an idea as to why the database works perfectly on some computers and errors out after a couple searches on others. Thanks!
This could very well be a permissions issue also. It could be something as abstract as the user's virus protection. It could be a timeout issue. Without knowing more about your database design, this one is very difficult to try to offer any kind of concrete and intelligent diagnisos.
J
I have recently posted a new access database and its oracle tables onto a shared folder for various users. It is a search database and me and a few other users are able to pull from the file and use it perfectly. But, when other users pull from the shared folder they suffer from dragging performance and then the fields within the forms error to "#Name?" and an "Object Invalid or No Longer Set" error button comes up.
Seeing as though we are all using the same database, I have tried to make sure the users with the error are using the correct, updated copy of the database. I have tried running an oracle driver update to make sure they have the correct mapping. I created this file on XP and it's access 2003. The users also have access 03. I feel like it shouldn't be a coding issue seeing as though the database itself works on some computers and not on others. I'm leaning towards a Microsoft Jet database situation? I don't believe it is a memory situation either, as that might explain the slow performance on some users databases, but not the errors. I am hoping to see if anyone has an idea as to why the database works perfectly on some computers and errors out after a couple searches on others. Thanks!
Are they sharing the SAME database ie the one file on a standard pc acting as a server, or is it a proper server.? How many concurrent users are there?
My advice FWIW is give each user their own copy db working directly of their client machine and deal with any mdb distribution issues via logon batch file (if authenticating against a domain) or whatever other method suits you.
They can then deal with compaction of their own frontend database copies, have their own particularised features if necessary, you then have the advantage of isolating any future connectivity issues per seat rather than having no start point at all and maybe not knowing where to start with issues such as this merely because everyone accesses the one MDB file across a busy network.
To test this out you might want to try running the db from the problematic client pc's.you are using the oracle driver which if so you'd have to ensure this odbc driver was also obviously on the problem pc etc etc. The extra effort may sound painful but it is necessary to isolate and resolve the problem. On certain occasions ie mega busy network, slow NIC cards and so on ended up using CITRIX to resolve it.
Wishing you luck
Jim
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Pro Grammer |
last post by:
Hello, all,
I am not sure if this is the right place to ask, but could you kindly
tell me how to "load" a shared object (like libx.so) into python, so
that the methods in the .so can be used? That too, given that the shared
object was written in c++, compiled with g++ ?
Thanks,
Pro Grammer
|
by: Ryan Park |
last post by:
Hi,
//SITUATION
I got a panel control that hold a certain position on a form.
Every controls or UIs are on this panel.
At certain situation, I called dispose() method of this panel control
and change it with other panel which contains other business logic and
UI controls.
|
by: deko |
last post by:
I'm getting intermittent "Object Invalid or No Longer Set" errors in my
Access 2002 mdb.
What causes these errors?
Has anyone dealt with this before?
I can't trace it because it's not easy to duplicate -- it just show up...
I've heard that spurious queries that use Now() or Date() or some other date
|
by: Paul |
last post by:
I have an Access 2000 database with a form that is giving me some
major headaches. When you open the form, it displays all records and
allows editing, but has AllowAdditions set to False so that the user
has to use my New Record button. When you click the New Record
button, the form presents a new record for editing. My client wants
to use the Escape key to cancel changes to new or existing records.
On existing records, Access already...
|
by: Marco Castro |
last post by:
I have a picture stored in an ole field in one of my access databases. Im
trying to put that picture into a picture box in one of my vb.net programs.
Unfortunately I keep on getting a type cast error whenever I try to copy it
there (through code) If I set a variable to variant and then read the value
into there, it wont error out on me and it's no longer set as nothing so
something was read into it but I still can't type cast the variable...
| | |
by: Carsten H. Pedersen |
last post by:
Hello
I want to create a kind of shared object. I have created a class,
Counter, which you can then import. Through the Counter class, i would
like to have access to a shared object.
Lets say that Counter contains only an int, initialised to 1. Each
time a class importing Counter would do Counter.getNextNumber(), the
getNextNumber() method would increase the local int, and return the
next number.
|
by: dk9 |
last post by:
I want to use Access Object Model from .NET to open access database
files and change/add/delete Tables, Views, etc and to repair/compact
Databases.
MSDN is lacking this kind of information.
Any links where I can get source code examples?
Thank you
|
by: Michel Couche |
last post by:
Hello,
I have an ASP.Net application that uses the Wizard control to build a newsletter.
There are three steps in the wizard.
The customer's specific design data are loaded from a database in step 1 of the wizard and saved into a session variable.
In step 2, when the user clicks on a button, I load the design data from the session variable and these are saved for further handling in a HashTable.
The HashTable is defined in the...
|
by: =?Utf-8?B?SkhhbGV5?= |
last post by:
Our system is:
IIS Server: dual Intel Xeon 2.80 GHz, 4 GB Ram
Windows Server 2003 SP2
IIS 6.0
SQL Server: dual Intel Xeon 2.80 GHz, 4 GB Ram (separate server)
Windows Server 2003 SP2
SQL Server 2000
We are having some problems with a website we are developing, and had some
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
