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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy