Can't Edit any Data in my Database

[billgyrotech]

Hello,


I don't know what happened but my back end database won't allow any changes whatsoever now.


Does anyone know what may have happened?


Thanks,
Bill

 

[pbaldy]

Check the permissions on the folder it's in.

 

[billgyrotech]

All permissions are set to Allow.


Is it possible to attach one front end and the back end for you to see?

 

[pbaldy]

Sure, you can attach them here.

 

[billgyrotech]

Okay thanks so much we are in a bind.

 

[Gasman]

Is the file read only?

 

[billgyrotech]

It sure is acting that way

 

[pbaldy]

I can edit data directly in the back end and from the front end.

 

[billgyrotech]

I noticed something on my folder:


Under General tab the attributes box for read only has a square black box in the box not a check mark. I click on it and make it blank but reopen and it goes back to that state again.


I have a feeling this is where the issue lies.

 

[billgyrotech]

The folder is on our server and it has problems that needs to be reset for our inventory program.


Could this be the cause?

 

[billgyrotech]

To let everyone here know I found the issue. I was in the middle of backing up the data to Excel and didn't realize the Excel file was still open so for some reason it was still linked some how. I closed the Excel file and the database is working again.


Thanks everyone

 

[pbaldy]

Glad you found the problem.

 

[The_Doc_Man]

Backing up to Excel? How? Were you doing an TransferSpreadsheet or did you try to link to an Excel table or open it as an object? (1st and 3rd will work OK, no bets on 2nd one.)

 

[billgyrotech]

I am planning to move the data to my new database is why I went to Excel.


So far I have had issues trying and no success. Some records get lost.

 

[The_Doc_Man]

Do you realize that you can simply link to the old database from the new one and draw data over? It is possible for you to (as a temporary measure) statically build links to the old DB, then create new but empty tables in the new DB and run a query from old to new using the syntax associated with INSERT INTO newtable (list of fields) SELECT list of fields FROM oldtable ; and once the data has been transferred, dissolve the links to the old tables.

 

[billgyrotech]

Doc Man,


Some field names are different and the old database isn't normalized properly. Instead of IDs for the main table from the other tables using foreign keys I put the actual names of Customers on the main table for instance.


So I painstakingly used formulas in Excel to match the IDs properly for each sub table.


So I have that now an AFRs table that has all of the correct foreign keys and also edited the names of fields properly so they match the categories in the new database.


What would be the next step?