I split a MDB, and now the front end don't work

[Mark Kubicki]

I have a Project, which already had a linked set of tables (to a single
database), but still had a other tables integral to it.
I decided to split the integral tables from the project, so that it will
have 1 set of tables linked to one database, and a 2nd set linked to a 2nd
database...

Having cut and pasted the set of tables integral to the project into their
own database, I imported them back to the project..
(they were renamed to distinguish one set from the other; the data source of
the forms, code references, etc had also been updated...)

HOWEVER,
While I can open the tables in datasheet view; when I open a form which uses
one of the tables as a datasource, the data is there, but it all seems to be
locked -I can't change any of it nor add any records, etc (!?!?)

Any sugestions (what-so-ever) as to what could be going on would be greatly
appreciated.
Thanks in advance,
mark

 

[Tom van Stiphout]

On Wed, 3 Dec 2008 21:53:02 -0500, "Mark Kubicki"

You didn't forget to add an all-important Primary Key for each table,
did you?

-Tom.
Microsoft Access MVP

 

[Mike Painter]

HOWEVER,
While I can open the tables in datasheet view; when I open a form
which uses one of the tables as a datasource, the data is there, but
it all seems to be locked -I can't change any of it nor add any
records, etc (!?!?)

Can you add records directly to the tables?
Which tables? The ones in the linked database or the ones you reimported?
Any chance these went through being copied from a CD and are now marked read
only?
What version of Access?

 

[Mark Kubicki]

thanks for getting back to me... see my comments below
-m.

 

[Mark Kubicki]

i didn't change any of the tables' structures; however, with your
recommendation, i went back and made certain that all of the tables did have
a primary key (adding when they were missing);
it didn't help

-mark

 

[Tom van Stiphout]

On Thu, 4 Dec 2008 07:20:33 -0500, "Mark Kubicki"

After you add a PK, you need to reattach the table. After that, open
the table in datasheet view and it should now be editable. That's a
good step.
Then open the query underlying your form. Is it editable? No? Then
post the SQL. You may have some syntax that makes the query
non-updatable.

-Tom.
Microsoft Access MVP

 

[Mike Painter]

thanks for getting back to me... see my comments below
-m.

Make sure all the locations are trusted. I don't know if it's true but it
makes sense to be tht you should not be able to update something if both
sides are not trusted.