multiple users creating "null records"

mpetersen

Registered User.
Local time
Today, 01:53
Joined
Oct 8, 2008
Messages
12
We have an issue with our database creating records which have no values. On occasion, when more than one person is working in the database the system generates a null record despite the fact that we have the primary key set to not allow nulls. That is each field is null.

Is there an obvious reason why our system would do this?
 
Without seeing your system impossible to say.
 
i was afraid of that....
thanks though!
 
i was afraid of that....
thanks though!

Please don't give up so quickly when advice is still a possibility.

How do your users use the database? (Please choose one or Identify Option #6)
  1. Share a common Access Database that is all in one File.
  2. Share a Common Access Database Front End that is connected to a common Access Database Back End.
  3. Each have their own copy of an Access Database Front End that is connected to a common Access Database Back End.
  4. Share a Common Access Database Front End that is connected to a Database other than Access.
  5. Each have their own copy of an Access Database Front End that is connected to a Database other than Access.
  6. Something Else (Please describe the setup)
Each of these options has the potential for advantages/problems, so knowing which it is will focus the assistance better. Also, we so not need to see your data, only the Database Structure. A copy of your database with sample data that creates your situation will usually be enough for diagnostic purposes.

Good luck and I look forward to your response.
 
the problem with nulls is that null datafields in keys are excluded from the indexes, so you can have multiple nulls effectively. make the null key field REQUIRED - that will stop it

is it just the key field thats null? the whole record cant be blank, surely
 
Well, actually, there is a way. If you don't require a field be entered ("required" and "allow zero length" on the field in table design view), then the user can pretty much do what they want. You should never implement a system without going through the design of each field and setting all the correct properties.
 
Thanks for the help, I guess I was feeling discouraged...

Situation three describes us. Our power just went out so I can't get to the actual database to get copy the database. Hopefully things will be up and running soon!
 
I should mention I inherited this very antiquated system just last month and NOBODY has any documentation on it. I'm just trying to piece it together.
 
I should mention I inherited this very antiquated system just last month and NOBODY has any documentation on it. I'm just trying to piece it together.


Join the club :D:D:D

But never give up

Think of how much you will learn and become the guru that saved the day

L
 
In my case, it was an inheritance for a guy who moved out of state. I ended up eventually becoming a Microsoft MVP because of events started by that inheritance. It can happen.
 
Perhaps it is too late to seek help for this one but here is a copy of our db which is creating the null record issue. If anyone cares to take a look I'd appreciate any insight.

Thanks,
mlp
 

Attachments

I should add that we are working with the image_metadata table.
 
Perhaps it is too late to seek help for this one but here is a copy of our db which is creating the null record issue. If anyone cares to take a look I'd appreciate any insight.

Thanks,
mlp

My system (Access 2003) was unable to run the application. I was able to determine that the database copy that I received seemed to have no tables and no queries.
 
we are in Access 2000 but our mysql database is offsite so maybe that is why the tables/queries don't save to the zip...
 
we are in Access 2000 but our mysql database is offsite so maybe that is why the tables/queries don't save to the zip...

I use SQL Server, and have a Linked Table copy for each table and view in each of my Front Ends. In addition, some queries have never been converted and are in the Front end. I was looking for something like that as the reason that hte databse would not open, and was surprised to find no tbales and queries at all.

It will be very difficult to diagnose any issues without at least dummy information in the tables and the queries that the forms use.
 

Users who are viewing this thread

Back
Top Bottom