With a 'create table' or an 'alter table' SQL statement I can add tables or columns to my online live Access database.
I can set new columns to non-required using 'null' in the SQL statement, but is there a way to set the 'Allow Zero Length' property to 'yes' as well?
Question:
When i linked my images to my Access database, i keet getting a #.............# aroung it?
example: database has ""/myimages/picture.jpg""
I was getting this on the picture "http://www.mysite.com/myimages/picture.jpg#http://picture.jpg#"
How can i fix it?
Read MoreSteps to Create a DSN-Less Connection String for your Access and SQL Server database(s) using some nice windows features.
Read MoreHow to filter one recordset with another on the same page? Here is a quick tutorial.
Read MoreAre you making a Content Management System?
Are you making a Forum?
Then I'm sure that you are about to ask:
How do I display the Text as the user entered it? because it shows on the browser as one big block of text...
Read MoreUniversal Data Access through OLE DB
Universal Data Access Through OLE DB provides a comprehensive introduction to OLE DB as an enterprise development tool.
This white paper is being made available for your review only; it is not supported by Microsoft.
Also read: Switching from ODBC to OLE DB:
http://www.udzone.com/showDetail.asp?TypeId=2&NewsId=859
Read MoreThis method explains how to manipulate the server generated Date(), Time() etc functions.
I found this useful since I have a UK site hosted in the US which resulted in all my date/times being incorrect due to the server being on US time.
Read MoreFor database connections in UltraDev you often need to supply an ADo Connection String. Here is a tip how to generate such string very easily.
(Windows only)