Can't Edit any Data in my Database (1 Viewer)

B

billgyrotech

Banned

Local time

Today, 13:10

Joined

Apr 18, 2013

Messages

258

• Jun 28, 2019

• #1

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

Wino Moderator

Staff member

Local time

Today, 11:10

Joined

Aug 30, 2003

Messages

36,124

• Jun 28, 2019

• #2

Check the permissions on the folder it's in.

 

B

billgyrotech

Banned

Local time

Today, 13:10

Joined

Apr 18, 2013

Messages

258

• Jun 28, 2019

• #3

All permissions are set to Allow.


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

 

pbaldy

Wino Moderator

Staff member

Local time

Today, 11:10

Joined

Aug 30, 2003

Messages

36,124

• Jun 28, 2019

• #4

Sure, you can attach them here.

 

B

billgyrotech

Banned

Local time

Today, 13:10

Joined

Apr 18, 2013

Messages

258

• Jun 28, 2019

• #5

Okay thanks so much we are in a bind.

 

Last edited: Aug 5, 2019

Gasman

Enthusiastic Amateur

Local time

Today, 19:10

Joined

Sep 21, 2011

Messages

14,231

• Jun 28, 2019

• #6

Is the file read only?

 

B

billgyrotech

Banned

Local time

Today, 13:10

Joined

Apr 18, 2013

Messages

258

• Jun 28, 2019

• #7

It sure is acting that way

 

pbaldy

Wino Moderator

Staff member

Local time

Today, 11:10

Joined

Aug 30, 2003

Messages

36,124

• Jun 28, 2019

• #8

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

 

B

billgyrotech

Banned

Local time

Today, 13:10

Joined

Apr 18, 2013

Messages

258

• Jun 28, 2019

• #9

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.

 

B

billgyrotech

Banned

Local time

Today, 13:10

Joined

Apr 18, 2013

Messages

258

• Jun 28, 2019

• #10

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


Could this be the cause?

 

B

billgyrotech

Banned

Local time

Today, 13:10

Joined

Apr 18, 2013

Messages

258

• Jun 28, 2019

• #11

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

Wino Moderator

Staff member

Local time

Today, 11:10

Joined

Aug 30, 2003

Messages

36,124

• Jun 28, 2019

• #12

Glad you found the problem.

 

The_Doc_Man

Immoderate Moderator

Staff member

Local time

Today, 13:10

Joined

Feb 28, 2001

Messages

27,137

• Jun 29, 2019

• #13

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.)

 

B

billgyrotech

Banned

Local time

Today, 13:10

Joined

Apr 18, 2013

Messages

258

• Jun 29, 2019

• #14

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

Immoderate Moderator

Staff member

Local time

Today, 13:10

Joined

Feb 28, 2001

Messages

27,137

• Jun 29, 2019

• #15

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.

 

B

billgyrotech

Banned

Local time

Today, 13:10

Joined

Apr 18, 2013

Messages

258

• Jun 30, 2019

• #16

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?