-
Archives
-
Meta
Category Archives: Access 2007 problems/solutions
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 Microsoft Access FTP, Microsoft Access import and export business, Microsoft Access vba code examples
Comments Off on FTP files using Microsoft Access
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 SQL Server Ports; VBA Connection string to SQL Server
Comments Off on Specific Port in Connection String to SQL
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 Access Locked Records, SQL
Comments Off on Access linked to SQL
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 64 bit, dll, libraries, Windows 7
Comments Off on 64 Bit
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 Network, Speed, Window 7
Comments Off on Improve Db Performance in a Network Environ
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 SQL Search Like
Comments Off on Likesearches in large SQL tables
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 Null SQL VB
Comments Off on SQL Server and Visual Basic
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 Adding Records
Comments Off on SQL or Access Adding Records
Referencing values on subforms
Remember the syntax for the way to recall information from a subform to a form is [subFormName].[Form]![FieldName]
Posted in Access 2007 problems/solutions, Uncategorized
Tagged Subforms
Comments Off on Referencing values on subforms
VPN
Take advantage of free resources to create a VPN for remote access. LogMeIn is one such resource. Use it to create a VPN between your base location and any remote users you might have. That way you can remote into … Continue reading