Question Helping a Beginner get on their feet : Linked Tables

[Geforce]

Firstly, hello to everyone here at the access-programmers Forum, I hope you're all very well!

Secondly, I'm after some, well, help really.

I've been lumbered with what I believe is a front-end/client linked style database (I suppose that's what Access is really) with which I've been struggling with what is most probably an extremely easy problem for around a week now; I don't like being beat, but this has me beaten.

First off, please excuse me for not knowing the exact access terminiology, but I'll do my best.

So let's begin.

Problem: I want a checkbox on the Form "Order Acknowledgement" Inside of Client_2003.mdb.

So I create a checkbox called "proforma pay" and I get a little green triangle in the corner of the check box - I assume that's because it's not linked to anything. Ok I get that.
In the normal view, the error is "Control can't be edited; it's bound to unknown field 'Proforma Pay'.

So this is where I'm getting stuck.

I've tried to create a new column in the linked table, but it can't be modified because it's linked. Ok I get that.

So, I go to the back-end and I go to design view, and I get this error message: "You can't open the table 'Order Acknowledgement' for modification."
A query or form bound to the table is open and you may not have permission to open this table in Design View.. bla bla bla. :banghead:

So does that mean I have to create a new table in the back-end and then link it?

All I want is for a checkbox to be able to be checked if a Proforma Invoice has been paid, but at this present time, the box is just greyed out - assuming because it's not linked to anything.

Thanks in advance !

 

[jkl0]

You will need to open the back-end exclusively, no one else can be in or actively linked to the back-end. If you can get everyone else out of the database, open access, goto open, and when the browse window comes up, select the file. The open button will have a down arrow beside it. Click on the arrow and choose open exclusive.

 

[pbaldy]

You need to modify the table in the back end and refresh the link (or relink) in the front end. What I suspect is happening is that the front end was open when you tried to modify the table. Make sure everyone is out of the front end, then try again.