search

ox-it / ords

Automatically exported from code.google.com/p/ords
0 stars 0 forks source link

Primary keys not indicated in uploaded Access database to Staging #767

Closed MerielP closed 8 years ago

MerielP commented 8 years ago

I've just uploaded an Access database to Staging. This is one I've used many times before for testing.

When I view the database schema, the primary keys are not indicated:

database schema - no primary keys

If I upload the same database to App, the primary keys are there, exactly as they should be.

The problem can be seen in the database called 'Uploaded database' in the project 'Staging test' on (unsurprisingly) Staging. Dave, I've just made you a project administrator.

thestoat commented 8 years ago

Please append or send me the database so that I can see what is happening on upload

MerielP commented 8 years ago

Here you go (once again, inside a zip folder to keep Github happy):

Bibliography.zip

MerielP commented 8 years ago

As requested, here's a version of the file with the tblAuthors primary key field name in lower case. Bibliography_lower_case.zip

thestoat commented 8 years ago

Should be ok now

MerielP commented 8 years ago

Hurrah - seems to be working now. Will close this issue.