Cannot go to specified record...

[Voodeux2014]

After a bunch of messing around with my database I found out that it seems to be a table link issue. When opening a form (frmAddDevices) it is supposed to go to a new record. I messed with the code and the allow additions and all that stuff. After a while I realize if I am opening the table in the front end part of the database I cannot add any new records or edit any records. One the backend of the database the table works as it should. Any tips would be greatly appreciated!

[NTC]

the front end is where all the controls exist.....so it is not unusual that the experience differs between front and back.

in the form's property, in the Data tab - is the AllowAdditions property - you will want to check that...

there can also be code in the form's Open or OnCurrent Event which affects things..... there can also be a filter applied in the opening argument

so there are a variety of places to 'touch' a form in order to control how it opens...you'll just have to sort things out...or whip up a new form if that is feasible and faster...

[Voodeux2014]

I checked all of the for properties and code. It appears to be something with the table itself. When using the navigation pane to open the table, the table itself will not allow me to add a new record.

[NTC]

assuming we are discussing an Access table and not a link to an excel or text file.....you should delete the table in the front end file...and then relink to it...and then check.

[Voodeux2014]

I have tried that as well. Once linked it is uneditable.

[orange]

What can you tell us about the design and development of the database? Who designed, developed and tested it?

You say After a bunch of messing around with my database

This isn't the way a developer talks or does things. Where are you changing things? Did you may a list of what you changed? Do you have a backup?
Deleting the tables in FE and relinking should get you the proper "linkage" as NTC said. Is there any parameters or conditions that would suggest the table(s) is/are readonly?

[Voodeux2014]

The person who designs it, develops and tests it is I.
Well you found me out, I am not a developer. I am slowly learning the ins and outs of Access on my own because it is something that I want to learn about. No need to call me out on that note.
Of course, I have a backup. I would like to learn why something isn't working before I just regress all of the work that I have done. This issue didn't occur until I changed a field data type in the table that is now giving me the issue. I have unlinked and relinked the table already and it has not changed the issue.

[orange]

Can you post a copy of your database (remove anything private) first (Compact and repair, then zip)

[Voodeux2014]

PEC IT Database.zip Here you go. Had to unencrypt the backend as well as change the locations of where the tables are linked from.

[NTC]

are your file locations set up as trusted locations?

[Voodeux2014]

Yes they are.

[NTC]

I think there is the need for a sanity check.

a. sitting at PC1 - which is where the front end file is suppose to be located; you can use Windows Explorer to go to where the back end file is located; open it, edit it, save it

b. remaining at PC1 - create a brand new db; use External Data tab to create link to same table in back end file; once linked then open it, edit it, save it

[orange]

I tried to put your backend and frontend in separate directories and relink the tables.
Was unsuccessful. I don't know if it something with the

unencrypt the backend as well as change the locations of where the tables are linked from.

.

It would not let me relink some tables.

The only thing I saw from a very limited view of tables was the lookup at table field level in a couple of tables. Don't know if it's relevant to your issue, but I would not use that feature. I would have a classic table lookup (reference table) approach.
But I can't get the application installed to test, perhaps someone else will try.

[Voodeux2014]

Well I just attempted it again. When I initially link the table to the front end it will work properly. Once I close the front end and reopen it, it is back to read only.

[Voodeux2014]

Here is another scenario...seem to be zeroing it down...looks like the table is getting "locked" somehow but cannot figure out where.

I have one front end open on PC1.
I have a second front end that I will open on PC1 as well.
Upon opening the second front end I receive the error that is attached.
After pressing OK on the error I can edit the table.