Search results for query: *

Nothing. The ADP file does hold any data hence no growth is going to affect it. Rebooot

The variable that you are reading the lookup function into may not have the proper data type (hence the size in bytes) to hold the value that you are reading it into it. Try modifying the data type of that variable. For example: if you are assigning the product ID to a variable of type integer...

To save yourself a lot of headache, hire some guy who knows access for a few hours and have sit with you to create the tables for your application and the main form. Once you watch him/her do that you should be able to pick up the ball slowly. However, if you think your business is going to grow...

Try creating a view then use your recordset for the form to access that. Hope this helps. Rebooot

Go to File/Connection. In there enter the IP address of your SQL server name, login, password and select the database on the SQL server that you want to connect to using your access project. That's it. You should be able to see all the tables that you have access to under the tables tab in your...

Try to setup the ODBC connection through the control panel under ODBC connection setup and test it first. After you do that run your second step using the new ODBC source you have created. This should work, otherwise let us know. Good luck. Rebooot

Try uploading your table to the SQL server using the upsize tool that comes with Ms-Access. Once you are in the SQL server environment you will be able to append any data you need to whatever table. If you need exact code for this check the SQL server group in Google. Rebooot

Every time I run the "compact and repair database" option from the tool menu, I get the smaller ade file. This might save you time on exporting your objects to a new access project. Hope this helps. As for the original post, in your Access project do you any code that may create new objects in...