June 24, 2003 at 4:50 am
I am in trouble and need help.
I had an Access 2000 Database which served as a frontend to a set of tables in a second backend Access database. The frontend is form driven and uses a mdw control file for permissions. All of my work was in creating a user friendly capable front end, with vbcode for all the forms. It worked very well. I could not lose this as it used daily by the whole office.
I was able to import all my Access tables from the backend Access database into tables in a database called jaesinv SQL Server 2000. I used the exact same names.
I created users in SQL Server called userlevel1, userlevel2, userlevel3 (only userlevel1 is used so far and has full permissions on all the imported tables. (SELECT, INSERT, UPDATE, DELETE, DRI)
On every computer I created a System DSN which connects to the SQL Server using permissions for userlevel1 (not Windows login). This DSN connection has the name JAESINV1
I then created links to each of the tables in the frontend using this JAESINV1 ODBC connection with the exact same names to tables in the SQL Server.
I could use all my forms and reports. BUT...
I JUST FOUND OUT - I CANNOT EDIT ANY RECORD I HAVE CREATED SINCE THE IMPORT
I can edit any older record which was imported but nothing that was created since.
When I try to change the record (even at a table level, not using a form) I am the only use at the time.
I get the same error box which looks like this.
*************************************************************************************
Write Conflict (message title)
---------------------------------------------------------------------------------------------------------------------------------------
This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made.
Copying the changes to the clipboard ....
[Three buttons] Save Record (grayed out) - Copy to Clipboard - Drop Changes
*************************************************************************************
I can probably change the record on the server using SQL statements but that make it useless for the users.
REALLY NEED HELP - Thanks - TG
June 24, 2003 at 4:55 am
Hi Tom,
could it be you're using bit field in SQL Server without a default value?
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
June 24, 2003 at 6:09 am
THANKS a5x03z1
You are a lifesaver. Changed the bit default to 0 in one table and it worked. Now I need to change the rest. But THANKS again
June 25, 2003 at 9:15 am
Do remember to update all bit records from null to a value. if not your,problem will persist. I also run Access frontend and had simular problems.
June 30, 2003 at 9:38 am
I've also had problems where Access is referencing a VIEW and there is no primary key.
Unless Access has a primary key, virtual or otherwise, it doesn't like editing records.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply