Keith- Are you *sure* you're editing the shared table database on the "W" drive? You must be the only one in the database (including users of the application with linked tables) when you try to make a change to a table structure. You cannot edit the structure from the linked tables in the "code" copy of the application.
John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Keith Browning Sent: Sunday, January 15, 2006 9:19 PM To: Access user Group Subject: [ms_access] adjusting split database tables ?? Hi again, I have split my current masterpiece database, so the tables are on drive W. I love the ability of being able to work on the forms etc without the users having to stop. This is the first time Ive organised one this way. However as the database is evolving (as they sometimes do) I needed to change a field in a table. The chages did not take effect. This was an unused one, and I found a use for a new one. Is it normal for the changes not to take effect? I was the only user. Does splitting the data base make it impossible to edit the tables later ? Keith Browning Browning's Electronic Services 32-34 High Street Dannevirke New Zealand 5491 64 6 374 6322 Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
