after upsizing cannot insert new record

[asafb]

Hello after upsizing my mdb file to sql server i cannot add a new record in access. what happend?

also, is it better to create an ADP file instead of creating links to sql?

thanks guys!
asaf

 

[asafb]

also, when i upsized using ADP format, then all my queries went crazy, like stuff stopped working, why?

thanks!

 

[cmmrfrds]

You need an unique index on all the sql server tables. Also, it doesn't hurt to add a timestamp data type to the tables since that will quarantee uniqueness on recordset updates.

Do you have update permissions on the tables?

The upsizing wizard usually changes the queries to views.

An ADP is defintely better. The processing will be done on sql server versus the client and the network traffic will be less than using linked tables.

I have upsized a few apps without any major problems. I one case, I could not use an ADP because of client politics.

 

[asafb]

how do i add a unique index to a table?
asaf

 

[cmmrfrds]

The easiest is to use Enterprise Manager. If you are in a company with a DBA, then explain to the DBA that you need the unique index on each table and they can set it up.

If you need further assistence then explain your enviroment and what tools you use on sql server.

Who is the database owner (dbo)?
Roles and permissions on the tables?
Type of login? sql server or NT Authentication?

You will need to know these terms to communicate with the DBA.

 

[asafb]

Okay, so what should i do withthe views in stead of the queries? any help?
asf