Hi, lovely one here. I am developing an enterprise wide system using SQL server 2000 and Access XP for 200 concurrent users.
I am distributing an Access Data Project, which contains the front-ends. i need to base one of the front-end's on a SQL statement which is created dynamically. This i can do, but the data can not be updated on the form without this silly error "The data was added to the database but the data won't be displayed in the form because it doesn't satisfy the criteria in the underlying record source.". Well the SQL Statement is not changing nor is the criteria that the statment is based on.
To overcome this, i want to be able to create a temporary table on the client and use it as the record source for the form. But i can not find away to do this. If i forget about using an Access Data Project and refer to the old ODBC way of doing it using a file DSN, its not an issue.
Should i forget about using Access Data Projects to develop Applications and go back to using Access 97 with DAO as Access Data projects are not up to scatch as a scable developed platform.