Access 2003 front end with sql 2005 backend

[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

 

[Arvin Meyer [MVP]]

Try using a datasheet form, or an Access query on the front end to copy &
paste records.

 

[James Scho]

Thank you Arvin.

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

thanks,
James

 

[James Scho]

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 Meyer [MVP]]

Check your query to make sure that you have permissions to add records. If
you are using a SQL View, instead of an Access query, go back to the Access
query. I am assuming that you are using an MDB, not an ADP.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[James Scho]

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

thanks,
James

 

[Arvin Meyer [MVP]]

Foe record locking to work properly, you need to allow all permissions
except Full Control to the folder housing the database.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[James Scho]

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