Access 2003 front end with sql 2005 backend

  • Thread starter Thread starter James Scho
  • Start date Start date
J

James Scho

Hello,

I have converted my split MDB configuration to an Access 2003 front-end with
a SQL 2005 backend using ODBC. I am experiencing a situation with the new
configuration where I am unable to copy & paste records that was done rather
easily with the split config. Otherwise all functionality entering orders and
order details works fine.

Specifically, I have an ORDERS table that has linked data to an ORDERDETAILS
table. Each order has an ODERID primary key with identity. The UI for this
exists in a form that has ORDERS table as the parent and a subquery
form(ORDERID id the link one-to-many) that facilitates the connection to the
ORDERDETAILS table. There are points in time that makes entry easier to
extract or COPY an order detail from the subquery form of one ORDERID and
paste it to the subquery form of another ORDERID. When I try to do this I get
an error that I cannot update/paste the records.

Again, this has been done for years in the MDB split environment without any
problems.

thanks in advance for your help,
James
 
Try using a datasheet form, or an Access query on the front end to copy &
paste records.
 
Thank you Arvin.

I apologize for not stating it earlier, but in both scenarios the sub form
is in datasheet form.

thanks,
James
 
Hello Arvin,

Just for the sake of giving it a try - I reinstalled a new subquery form in
datasheet form to see if it would enable me to copy & paste, but
unfortunately there must be another cause for this error. Any other
suggestions are greatly appreciated.

thanks,
James
 
Arvin,
the query is in MDB, I am not using ADP. All permissions are allowing
additions - still not working.

thanks,
James
 
Arvin,

Thanks for your help - I actually opened a case & it seems that there may be
more to this. I actually may resort to writing code to reproduce what I had
in my old MDB environment. I believe I am abonding the idea of being able to
copy & paste manually - I didn't really care for this feature from a
stability standpoint anyway.

thanks again,
James
 
Back
Top