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.
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.