FAQs relating MS-Access
When I try to access the management area of MS Access database via The Console, I get "Page cannot be displayed error".
This is because you are using Internet Explorer with the recent security patch. Microsoft has implemented a new restriction on the browser,which prevents access to URLs containing the username and password. The link from The Console's Database section points to http://username:password@domain.com/database/ .
To overcome this problem, go directly to the database folder on your website. i.e.
http://www.domain.com/database/
NOTE: Replace "domain.com" with your actual website address.
You installed the database support for me, but when I go to the database/ folder, it says "Access Denied".
There are 2 possible reasons for this occurring:
1. You created a database/ folder using FTP on your website and our automation system was unable to create the appropriate files. To solve this problem, respond to our support staff requesting to re-create the database upload instructions for you.
2. You FTP username and password has changed after the installation of MSAccess support on your website. To fix this, simply contact our support staff and request to have the password file re-created.
Using MSAccess and SQL, I am getting an error on my ASP page.
When using MSAccess and SQL, a record set object must be used. e.g. instead of:
set Search=contentXCn.execute(SearchSQL)
use:
- Set Search = Server.CreateObject("ADODB.RecordSet")
- Search.CursorType = adOpenStatic
- Search.ActiveConnection = contentXcn
- Search.open SearchSQL
The reason for this is the Access database is not stored locally on the server, but over a ODBC link, which means that not all functionality is available.
The locale settings change to US from the AU format as I input data into my MsAccess database on ASP.
You cannot reset the date outside the locale paramaters unless it's .NET. Web Secure currently does not support .NET. The workaround is you can recast the date as a string and back into a date, where it will swap the value yet again. Set the date in ISO format which is recognised by US and AU locales (YYYY-MM-DD). This format means that it is still a valid date in both US and AU locales and there is no locale or SQL confusion about the date format. Sample code:
if (Request.QueryString("cost_date") <> "") Then
cost_date = Request.QueryString("cost_date") cost_date = IsoDate(cost_date) end if
Function IsoDate(dteDate)
If IsDate(dteDate) = True Then
DIM dteDay, dteMonth, dteYear
dteDay = Day(dteDate)
dteMonth = Month(dteDate)
dteYear = Year(dteDate)
IsoDate = dteYear & "-" & Right(Cstr(dteMonth + 100),2) & "-" &
Right(Cstr(dteDay + 100),2)
Else
IsoDate = Null
End If
End Function |
