Updatable Queries in Conversion Project

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Answered in previous post.
For this specific query/problem, the solution was to remove
dbo_tblBillToInfo from the query.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top