Beginner: Mde error- couldn't make changes

[bbrazeau]

I have a database mdb. that I've made a mde. file out of. When I try
to run the file I get a can't make changes requested, would create
duplicate values error.
Now for the facts: The open event on the form that produces the error
supplies a new number to a primary key field by looking at the highest
exsisting number in that field and incrementing by 1, similar to the
way an autonumber would work. The code finds the record with the
highest number,selects, copies, then paste appends it to a new record,
it then increments the number by one so as not to create a duplicate
value. I have search this forum and found some info on the subject but
no answers it is my understanding from these posts (see below) that
access strips away any code written in the form to make the mde. Is
there a work around? If so could someone explain it to me? Thank you.
Following is a thread from my search.
"Making an MDE file will not do anything to a table...it simple
compiles and "strips-out" the source VBA code behind the forms. If
you look at an MDE
database you will see the tables are quite unchanged. MDE files make
great
front-ends for MDB backends. Making an MDE as a container for a bunch
of tables
would serve no purpose."

[DFS]

"bbrazeau" <bb******@adelphia.net> wrote in message
news:90**************************@posting.google.c om...

I have a database mdb. that I've made a mde. file out of. When I try
to run the file I get a can't make changes requested, would create
duplicate values error.
Now for the facts: The open event on the form that produces the error
supplies a new number to a primary key field by looking at the highest
exsisting number in that field and incrementing by 1, similar to the
way an autonumber would work. The code finds the record with the
highest number,selects, copies, then paste appends it to a new record,
it then increments the number by one so as not to create a duplicate
value.
bbrazeau,

At the point you do the Paste | Append you are trying to create a duplicate
value in the primary key field. That's what's causing the dupe error.

You have to do the Paste | Append with the ID value already incremented by
1. Here's one way to do it:

INSERT INTO TABLE (IDField, Field2, Field3, ...)
SELECT (DMax("IDField","TABLE") + 1) AS NewID, '" & Field2 & "', " & Field3
& ",...
FROM TABLE
WHERE IDField = DMax("IDField","TABLE")




I have search this forum and found some info on the subject but no answers it is my understanding from these posts (see below) that
access strips away any code written in the form to make the mde. Is
there a work around? If so could someone explain it to me? Thank you.
Following is a thread from my search.
"Making an MDE file will not do anything to a table...it simple
compiles and "strips-out" the source VBA code behind the forms. If
you look at an MDE
database you will see the tables are quite unchanged. MDE files make
great
front-ends for MDB backends. Making an MDE as a container for a bunch
of tables
would serve no purpose."