February 3, 2005 at 6:49 am
We have an SQL2000 database, and I have a small Access 2002 .adp utility to do some management.
Recently we have had a couple of cases of keys, and once identity properties, disappearing from fields in the SQL tables. The fields were still there, the key attribute has disappeared; in a couple of cases the identity property for the key field was also turned off so the auto increment did not work.
A consultant claims this is a 'known bug' with Access and that I should never front end an SQL database with Access. I don't necessarily believe him.
Does anyone know more about this?
Jay
...
-- FORTRAN manual for Xerox Computers --
February 3, 2005 at 7:22 am
1 - If this is a known bug then there must nbe a known cure.
2 - Access was designed to work with SQL server (among other things). Aside from a few strange things hapenning once in a while (all curable from the access side) I have no problem matching sql server 2000 with access 2000.
So 3 - DROP CONSULTANT.
4 - Search those forums and/or ask your questions there :
February 4, 2005 at 2:54 am
On several occasions using the compact/repair utility in MS-Access 2000 (not JetComp) I have experienced the loss of a primary key. Compact repair rebuilds the table with all data intact, but just forgets to leave off the primary key. I don't know why, and see this happen on possibly 1% or less of compact / repairs, and then only to one of many tables in the database, never to more than one.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply