Re: Updatable Queries in Conversion Project
- From: "John Spencer" <spencer@xxxxxxxxx>
- Date: Tue, 20 Dec 2005 08:52:48 -0500
Answered in previous post.
For this specific query/problem, the solution was to remove
dbo_tblBillToInfo from the query.
"cvegas" <cvegas@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:214EBD40-027D-433A-89D3-0A1724C7857D@xxxxxxxxxxxxxxxx
>I am converting a Access 2k project and going from a LAN using a total
>access
> 2k solution to a offsite SQL backend with my Access 2K as a front end.
>
> I posted a few days earlier and John suggested that I add a field of
> TIMEStamp to my sql table. I did this and it seems to have solved that
> issue.
>
> I ran into another form that does not allow me to update the info so
> figured
> what the heck just add a TimeStamp field to both of the sql tables that
> populate that query. I inserted a timestamp field in both tables, deleted
> the original link, and relinked the table.
>
> Still tells me that the recordset is not updatable when I go in to change
> a
> customers fax number.
>
> I have a ton of queries in this project that are tied to forms that need
> to
> be updatable. I am apparently missing something important that needs to
> be
> done when doing this type of conversion.
>
> Any advise you may be able to share would be greatly appreciated.
>
> Here is the query that was updatable in my old project but now is not.
>
> SELECT dbo_tblCustomers.CusNum, dbo_tblCustomers.Active,
> dbo_tblCustomers.LastUpdate, dbo_tblBillToInfo.Active,
> dbo_tblCustomers.Company, dbo_tblCustomers.Address,
> dbo_tblCustomers.Suite,
> dbo_tblCustomers.City, dbo_tblCustomers.State, dbo_tblCustomers.RateSet,
> dbo_tblCustomers.Zip, dbo_tblCustomers.Contact, dbo_tblCustomers.[Contact
> EMail], dbo_tblCustomers.[Toll Free], dbo_tblCustomers.Phone,
> dbo_tblCustomers.Fax, dbo_tblCustomers.[Additional Info],
> dbo_tblCustomers.[Credit Hold], dbo_tblCustomers.[POD EMail],
> dbo_tblCustomers.[Same Location], dbo_tblCustomers.BillToId,
> dbo_tblBillToInfo.BillToID, dbo_tblBillToInfo.Company,
> dbo_tblBillToInfo.Address, dbo_tblBillToInfo.Suite,
> dbo_tblBillToInfo.City,
> dbo_tblBillToInfo.State, dbo_tblBillToInfo.Zip, dbo_tblBillToInfo.[Toll
> Free], dbo_tblBillToInfo.Phone, dbo_tblBillToInfo.Fax,
> dbo_tblBillToInfo.[Billing Contact], dbo_tblBillToInfo.[Contact EMail],
> dbo_tblBillToInfo.[Billing Info], dbo_tblCustomers.APCode,
> dbo_tblCustomers.NeedsAuth, dbo_tblCustomers.NotificationPref
> FROM dbo_tblCustomers INNER JOIN dbo_tblBillToInfo ON
> dbo_tblCustomers.BillToId = dbo_tblBillToInfo.BillToID
> WHERE (((dbo_tblCustomers.Active)=1))
> ORDER BY dbo_tblCustomers.CusNum;
>
> I know there is something with SQL & Access with using 1 in SQL table
> and -1
> in access tables but don't know if that would affect this or not.
>
> I look forward to your reply and thanks in advance for any light you may
> be
> able to provide.
>
>
.
- Prev by Date: Re: Updatable Query
- Next by Date: Re: Access and Word Merge
- Previous by thread: Calculating total fields?
- Next by thread: Re: converting a 3 table column into 8 column table based on Site ID.
- Index(es):
Relevant Pages
|
