This page will present a number of common Microsoft Access run-time errors and will also divulge some sample code that addresses those errors.
You must use the dbSeeChanges option with OpenRecordSet when accessing a SQL Server table that has an IDENTITY column
Click here to see a code solution for this issue.
You receive an error when using the SendKeys command similar to: Error 70 Permission Denied
Click here to see a code solution for this issue.
You receive an error when using the DoCmd.OutputTo or DoCmd.TransferSpreadsheet command similar to: You selected more records that can be copied onto the clipboard at one time - 65,000
Click here to see a code solution for this issue.
If you need any help implementing any of these code samples, or if you need modifications made, please
Click Here to get a free quote for your Microsoft Access Development needs.
Click Here to learn more
about the WSI quoting
process.