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

  • Thread starter Thread starter Mark Kubicki
  • Start date Start date
M

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
 
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
 
Mark said:
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 (!?!?)
Click to expand...

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?
 
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
 
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
 
Mark said:
thanks for getting back to me... see my comments below
-m.
Click to expand...

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.
 
Back
Top