Search results

Has anyone else ever experienced this problem? Any recommendations on how I might troubleshoot? I can't find anything to go on with this error. Many Thanks

Hi, We have been having intermittent problems with an MS Access 2000 front-end application linked to a SQL Server 2000 database recently. From the switchboard a user was sometimes getting "There was an error executing the previous command". When she shut the application and opened it again it...

MS Access Database Issues Hi, We have been having problems with MS Access for a few weeks now (MS Access front end to a SQL Server 2000 database). We have a shared .mde file which is in a network folder and used by 14 users. All users use MS Access 2000. Recently users have intermittently been...

Hi, We have an MS Access 2000 Database front-end to a SQL Server 2000 database. The database was initially developed in MS Access and then upsized to SQL Server 2000. I am just wondering .... When I do a query in the MS Access front-end, does the application return all of the data back to the...

Hi, I have a query which returns 1 value (The description associated with the maximum ID in the table). I have a Text box on a form and I would like the default value of the text box to be the the value from the above query. I have tried to build an expression using the expression builder by...

Hi, Many Thanks for all the responses To answer your questions: - We can't isolate it to one form. It seems to occur throughout the application. - I gave the users access to a new version of the mde file last Friday with the error handling code removed. The error occurred again with that. -...

Hi, I am absolutely puzzeled with a problem we are having with an Ms Access 2000 application, which is the front end to a SQL Server database. We have a database which was working fine for over 6 months. And now all of sudden users are intermittently getting the error messages: "Error...

Hi, I created a database in Microsoft Access and then upsized it to SQL Server afterwards. I now need to add a new column to a table in the database. So I added the new column in SQL Server using ALTER TABLE command. This column is a foreign key which has an associated parent key in another...

Hi, We have an MS Access .mde file on a network drive which is shared by 15 users. This Access Application is a front end to a SQL Server database. Lately we have been having intermittent problems where users are getting the message "There was an error executing this command". When they close...

Hi, I have an MS Access application installed on a number of machines and it is running fine on all of them except one. On one of the server when I am submitting a form to search the database I get the error message: "Automation Error. Element not Found." Same version of MS Access on all...

Thanks a million for that allan. That sorted the problem.

Hi, I have a form with a number of fields and buttons on it. The form is opened in "add new record" mode. I have noticed that when I move from the last field in the tab order to the first field in the tab order it saves an entry in the database. This is causing me problems because when users...

Hi ghudson, Just managed to compact it yesterday and it did decrease the size if the .mde file from 190MB to 2MB. It is still growing as users use the database but I have set the autocompact option on so should compact itself after the last user logs out. Can't find anything on web though to...

Thanks Ghudson Is the Autocompact option to "compact on close". It is the only option I can see. My .mde file is growing extremely quickly. At the moment it's at 85MB after 2 days. What data is Access storing that's causing it to grow this quickly. All of the data is stored in SQL Server so...

Hi, I have an MS Access database. It contains tables linked to tables on SQL Server. Therefore MS Access is really only acting as a front end to the SQL Server database. I converted the MS Access database to a .mde file. I noticed over the past few days that the .mde file is growing in size...

Hi, I have a form and I set the record souce for this form based on a query built by users (they select different options). I open the form and then assign the form's record source to the SQL query. This works fine 90% of the time, however, sometimes instead of displaying the query results it...

I eventually found where this configuation data is stored: in the Connect field in the MSysObjects table. However I am unable to update this field. I get the message: "Control can't be edited;it's bound to replication system column 'Connect' " Is there any way that I can unbind this column in...

Thanks Pat, At the moment I don't use a DSN. When I was upsizing the database I selected to create a new database and entered a username and password in the wizard that had permission to create a database. These details seemed to be stored somewhere in the database in order for it to be able...

Hi, I have an Access 2000 database with some linked tables. When upsizing the database I selected 'Save password and user ID with attached tables'. Therefore in the Linked Table manager after each table in brackets I have the name of the database to which the tables are linked. I am now...

Hi, I have an Access 2000 database and I have hidden the database window in the startup options. I have also saved the database as a .mde file. However, if a user opens the database while pressing the shift key they can still get access to the queries and tables in the database and can change...