Go Back   Access World Forums > Microsoft Access Discussion > Tables

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-08-2009, 09:14 AM   #1
RexesOperator
Registered User
 
Join Date: Jul 2006
Posts: 604
Thanks: 0
Thanked 0 Times in 0 Posts
RexesOperator is an unknown quantity at this point
Unable to add new records to linked table

I am using Access 2003. I used the database splitter wizard to split the db. I have the backend on a server and the frontend on three other users' computers.

The problem right now is that they can't add any new records using forms (which are based on queries). When I look at the tables on the backend the little + sign showing the related tables is not there.

ATM the users can add new records manually into the table, but they still can't enter using the forms. The forms all worked before the split.

__________________
"The pessimist complains about the wind; the optimist expects it to change; the realist adjusts the sails. William Arthur Ward.
RexesOperator is offline   Reply With Quote
Old 04-08-2009, 10:42 AM   #2
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 10,540
Thanks: 597
Thanked 1,008 Times in 950 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
Re: Unable to add new records to linked table

Have the table names changed?
__________________
Code:
                 |||||
               @(~^~)@
-------------oOo---U---oOo-------------
|                                     |
|      Uncle Gizmo              |
|  
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)
Uncle Gizmo is offline   Reply With Quote
Old 04-08-2009, 01:06 PM   #3
RexesOperator
Registered User
 
Join Date: Jul 2006
Posts: 604
Thanks: 0
Thanked 0 Times in 0 Posts
RexesOperator is an unknown quantity at this point
Re: Unable to add new records to linked table

Thanks for looking.

No the table names haven't changed. I did find out the user wasn't entering data in the form correctly. That problem has been resolved

I am still curious as to why the related tables don't show up as related in the be. The relationships show up correctly in the relationship window. And everything else is behaving the way it should (operator errors not withstanding).

Unfortunately I don't have access to the db at home. I retired last week and they won't give me an account to work with. Hmm. They still hope I can fix the db though. I will be in the office next week and can explore a few options then.

__________________
"The pessimist complains about the wind; the optimist expects it to change; the realist adjusts the sails. William Arthur Ward.
RexesOperator is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Unable to edit sql linked table dzirkelb General 2 06-05-2008 06:25 AM
Delete blank records from linked table arifmasum Macros 5 04-27-2008 09:04 PM
Can't update records in Linked table TClark14 Tables 1 04-03-2006 07:15 PM
Can't add new record in linked table in Windows 2000 draaYak Tables 1 12-05-2005 01:54 PM
Auto add records to related table Sandre Tables 2 07-30-2004 12:24 AM




All times are GMT -8. The time now is 12:08 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World