I had this problem if 2 users were logged to the same .adp file.
Now I have it like you - some copies of .adp file connected to one SQL server database and it works with no problem.
In Office 2000 you have "Stored Procedures" and "Views" separated in 2 items in the menu. In Office 2003 are both in the menu "Query". There are both choices - to create a stored procedure and to create a view. There's no other difference, it works the same way.
download and install Service release for Access
Informations here:
http://support.microsoft.com/kb/269824/EN-US
Download here:
http://www.microsoft.com/downloads/details.aspx?FamilyID=AF6C8D03-7633-45B4-AB96-795EE656F2A2&displaylang=EN
i think it's not possible to prompt in a view, but it's possible in a stored procedure.
Create Procedure nameOfStoredProcedure
@enter_id float
AS
SELECT * FROM table WHERE id = @enter_id;
I've sorted data in a subform by a column (date). When I try to overwrite the date, the sort disappears and the data are unsorted. It happens everytime I try to overwrite data in a column that is used for sorting. How can I keep the sort order and editing the data in the same time?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.