Category Archives: Access 2007 problems/solutions

Access 2007 is really buggy. We at Data Control have to use it because our clients want to use it (or have to use it). So, while we wait for Service Packs to be released that solve these issues, or while we find work arounds to get the job done, we’re going to post our findings on this blog.

Hope this helps everyone!

FTP files using Microsoft Access

I have an import/export client that runs their entire operation with Microsoft Access as a backbone application. This company has been in Fastcompany for a couple of years now. Today I had the opportunity to go back and slightly modify … Continue reading

Posted in Access 2007 problems/solutions, Access Code Examples, Microsoft Access Solutions | Tagged , , | Leave a comment

Using File System Objects in Microsoft Access

If you want to manipulate files and folders from within Access, here’s how you do it. First, open a module or create a new one. From the Tools menu, choose References… and the References window opens. Scroll down to the … Continue reading

Posted in Access 2007 problems/solutions | Leave a comment

Complex Reporting

(and building a source form to understand how the report results are derived) Sometimes you need to build a really complex report. I had to do that for one of my Fortune 500 clients. They were trying to automate a … Continue reading

Posted in Access 2007 problems/solutions | Leave a comment

Specific Port in Connection String to SQL

When creating a project that will use SQL Server as the back end, the default port used is 1433. You need to have your firewall and router forwarding incoming requests on that port. However, if you need to use a … Continue reading

Posted in Access 2007 problems/solutions, Uncategorized | Tagged | Leave a comment

Access linked to SQL

Be sure to set a default value for bit fields in SQL. Access does not like it when you do not. Access will place a default value into the fields if they do not have one and as a result, … Continue reading

Posted in Access 2007 problems/solutions, Uncategorized | Tagged , | Leave a comment

64 Bit

Be aware that 64 bit operating systems along with 64 bit MS Access could spell trouble for your code. It will spell trouble for any libraries that you may hav e obtained along the way. There is a nearly total … Continue reading

Posted in Access 2007 problems/solutions, Uncategorized | Tagged , , , | Leave a comment

Improve Db Performance in a Network Environ

Installing the following code into the first form that opens in a database will increase the database performance in a network environment, especially with Windows 7. Option Compare Database  Public Function PrintISAMStats()     ‘ Print the values returned by … Continue reading

Posted in Access 2007 problems/solutions, Uncategorized | Tagged , , | Leave a comment

Likesearches in large SQL tables

I’ve had several clients now that have requested a stored procedure that will return records based on key words entered by a user. There can be one or many key words and all have to match in order to match … Continue reading

Posted in Access 2007 problems/solutions, Uncategorized | Tagged | Leave a comment

SQL Server and Visual Basic

Remember when casting values that there are some cases where a null value will result in an error and no conversion. Check your properties for your variables in VB and you fields in SQL.

Posted in Access 2007 problems/solutions, Uncategorized | Tagged | Leave a comment

SQL or Access Adding Records

Suggestions on how to let users enter new data into SQL or even Access. 1) Build them a real data-entry app (could be web-based, but doesn’t have to be) that will check all the inputs before submitting the data to … Continue reading

Posted in Access 2007 problems/solutions, Uncategorized | Tagged | Leave a comment