|
|
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"
<mark.kubicki[ at ]verizon.net> wrote:
You didn't forget to add an all-important Primary Key for each table,
did you?
-Tom.
Microsoft Access MVP
[Quoted Text] >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
>
|
|
Mark Kubicki wrote:
> HOWEVER,
[Quoted Text] > 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?
|
|
thanks for getting back to me... see my comments below
-m.
"Mike Painter" <mddotpainter[ at ]sbcglobal.net> wrote in message
news:mFKZk.8045$D32.3479[ at ]flpi146.ffdc.sbc.com...
[Quoted Text] > Mark Kubicki wrote:
> > 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? YES
> Which tables? The ones in the linked database or the ones you reimported?
> BOTH
> Any chance these went through being copied from a CD and are now marked
> read only? NO
> What version of Access? 2007
>
>
|
|
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" <tom7744.no.spam[ at ]cox.net> wrote in message
news:7slej4pkpucqd1ke0n5llov3m8eoc6390k[ at ]4ax.com...
[Quoted Text] > On Wed, 3 Dec 2008 21:53:02 -0500, "Mark Kubicki"
> <mark.kubicki[ at ]verizon.net> wrote:
>
> You didn't forget to add an all-important Primary Key for each table,
> did you?
>
> -Tom.
> Microsoft Access MVP
>
>
>>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 Thu, 4 Dec 2008 07:20:33 -0500, "Mark Kubicki"
<mark.kubicki[ at ]verizon.net> wrote:
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
[Quoted Text] >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" <tom7744.no.spam[ at ]cox.net> wrote in message
>news:7slej4pkpucqd1ke0n5llov3m8eoc6390k[ at ]4ax.com...
>> On Wed, 3 Dec 2008 21:53:02 -0500, "Mark Kubicki"
>> <mark.kubicki[ at ]verizon.net> wrote:
>>
>> You didn't forget to add an all-important Primary Key for each table,
>> did you?
>>
>> -Tom.
>> Microsoft Access MVP
>>
>>
>>>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
>>>
>
|
|
Mark Kubicki wrote:
[Quoted Text] > thanks for getting back to me... see my comments below
> -m.
>
> "Mike Painter" <mddotpainter[ at ]sbcglobal.net> wrote in message
> news:mFKZk.8045$D32.3479[ at ]flpi146.ffdc.sbc.com...
>> Mark Kubicki wrote:
>> > 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? YES
>> Which tables? The ones in the linked database or the ones you
>> reimported? BOTH
>> Any chance these went through being copied from a CD and are now
>> marked read only? NO
>> What version of Access? 2007
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.
|
|
|