Re: Upsizing

thanks.
Just had a look and each table does have a primary key.
Ill look at the other points though.

"Sylvain Lafontaine" wrote:

> Use the Refresh command (F5 or View --> Refresh) on both the Tables and the
> Queries window.
>
> The more commun cause with problem editing data is a missing primay key.
> When the Select queries begin to be very complex, you must also set the
> UniqueTable property and possibly the ResyncCommand too. There are other
> possibilities, like problem with a Bit field; however, in your case, I will
> first look into the possibility of a missing primary key.
>
> --
> Sylvain Lafontaine, ing.
> MVP - Technologies Virtual-PC
> E-mail: http://cerbermail.com/?QugbLEWINF
>
>
> "jsw" <jsw@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:4D2CD008-4E70-4FB0-A97C-746D77288AE4@xxxxxxxxxxxxxxxx
> >I have upsized an Access database to an SQL database via the Access
> >upsizing
> > wizard.
> > The first few times I did this all was ok (ie I could enter / edit data in
> > the SQL database via Access).
> > I then changed the original Access database (inserted some fields etc) and
> > used the upsizing wizard again.
> > This time all my tables seem to be locked. Sometimes the data is lost and
> > I
> > just get the table headings, with no data and no boxes to enter the data.
> > Other times I get the data but no more blank data boxes to enter more
> > data.
> > Usually 2 of the 4 tables loose their data and the other 2 tables keep
> > theirs. In each case however I can not enter any more data.
> > Just to add I can enter data directly into the sql database via the
> > database
> > utility program stored on the main server, this can then be viewed
> > correctly
> > via access on the other pc (but can not enter data).
> >
> > Sorry for the long question but whats going on?
> > Thanks
> > Jon
>
>
>
.

Relevant Pages

  • Re: Upsizing
    ... >> first look into the possibility of a missing primary key. ... >> Sylvain Lafontaine, ing. ... >>>I have upsized an Access database to an SQL database via the Access ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Access 2003 max rows
    ... run into locking problem with the other users of the database. ... Sylvain Lafontaine, ing. ... I have SQL database, I made a ADP access 2003 project file to connect it ... file format set to both Access 2000 & Access 2002-2003 and still I can see ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Q: Datatables, Datasets and updating
    ... I have two tables A and B in the SQL database. ... ID_A (the primary key of A) and NAME_A (a string ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Updating the SQL key value
    ... bill wrote: ... I save them in a sql database using the field "order" (a smallint) as the primary key. ...
    (comp.lang.php)
  • Re: Q: Datatables, Datasets and updating
    ... the automatic updating features of a DataSet and DataAdapter. ... > transfer the data inputted into the SQL database. ... >> The problem seems to be that you have defined Primary Key to mean Identity ...
    (microsoft.public.dotnet.languages.csharp)
Quantcast