473,888 Members | 1,603 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Shared access database "Object Invalid or No Longer Set"

1 New Member
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!
Aug 31 '07 #1
3 4141
VBPhilly
95 New Member
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.
Aug 31 '07 #2
JConsulting
603 Recognized Expert Contributor
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
Sep 1 '07 #3
Jim Doherty
897 Recognized Expert Contributor
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
Sep 1 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

3
2037
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
7
22750
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.
7
36733
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
3
4630
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...
3
8713
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...
7
7360
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.
5
1786
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
3
2893
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...
0
2222
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
0
9961
marktang
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...
0
11178
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10882
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9597
agi2029
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...
1
7990
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7148
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
4642
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4243
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3251
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.