Search results

Just to clarify: 1) If you're using MySQL and not SQL Server, you'll need to distribute MySQL ODBC driver since they are not installed on Windows PC by default as is the case with SQL Server. 2) I wouldn't call File DSN a DSN-less connection, exactly. As Pbaldy said, it's convenient for...

Examples of this? As far as I know, nullable foreign keys seems to be part of the standard. I just verified that nullable foreign key is allowed on SQL Server 2008 R2 and I'm pretty sure it is true with MySQL & PostgreSQL though I''ve not tested it, nor would I want it anyway.

I suggest you read the article about cascading to null which hopefully brings out the difference between "Required" property (which corresponds to NOT NULL DDL) and foreign key. Personally I don't like the idea of allow null foreign keys and make my foreign keys required most of time.

DCrake - No. 2007 is solidly 32-bit only. Just to be clear here - there's two senses of how we can use "32-bit/64-bit" - WRT the OS or WRT the application. In your scenario, you are likely dealing with 64-bit OS but 32-bit Application (e.g. Office 2007). Because Office 2007 is still 32-bit...

First of all, does he REALLY need 64-bit Office? The chance are that he doesn't and would be better off with just 32-bit Office. Microsoft currently recommends against installing 64-bit Office and your user must have went out of his way to get it to install 64-bit. But assuming there is a legit...

If your web host allows remote connection, yes. Some may require you to use some form of VPN or remote login, but as long you work it out with web host, this'll work much better.

Just to be explicit: I'm led to believe that the security of data is primarily centered around securing the web server and avoiding use of certain code that would allow exploits (e.g. SQL Injections) and less to do with physical storage of data. In other words, many web server communicate with...

I'm also aware that some have succeeded in using Access database as a web host, but since your intention is to use it interactively, I think you'll find it a bad idea. Why not just use a free RDBMS (SQL Server Express? MySQL? PostgreSQL?) that you can place on your web host, base your websites...

Just to help Jeannette (welcome to AWF!) out - Recovering from corruption Preventing corruption

Also, some expressions are OK. e.g. Const Sum As Long = 1 + 1 Const A As Long = 1 Const B As Long = 2 Const AnotherSum AS Long = A + B I frequently do something similar to support multiple assignments, typically with bit flags: Public Enum MyFlags A = 1 B = 2 AllFlags = A Or B 'Set both A...

Well, you certainly can write to the document to alter the layout. I'm not sure whether writing in javascript commands will also execute it (I somehow doubt it, since there needs to be some kind of trigger for the browser to invoke its scripting engine). Essentially you'd just google on how web...

I believe he meant to instantiate a variable containing a particular value of enum. I also guess that he wanted it to be const because he didn't want to change the value at the runtime only at development/deployment.

Elaborate.

SELECT Format(Now(), "yyyy-mm-dd hh:nn:ss");

I can confirm that VBA does not like creating a constant of type enum. Never tried to do that before so I have no idea why it'd not accept enum as a possible data type for a constant other than the speculation that constant may be meant to hold primitive data types only. This also is an error...

Access already has a Now() function which returns similar result. (However, if you want same date time, you'll have to wrap it in Format() and pass the ISO definition in) I'm not aware of an native function to create a GUID but I know there's several examples of using API calls to create a GUID...

Yes. Either use a combobox and/or listbox control, set row source to select both id and display value but set column width to "0;" so the first column is hidden and thus show only the display value. Just like in traditional Access.

Pelerin - indulge me. When you double-click the word "CreateDynaset", right-click and select "Definition" in the popup menu what happens?

I'm not hopeful that this will work but did you try converting the file? The alternative is to install Jet 3.5 and reference DAO 3.5 object library but that can be weird with Access 2007 which comes with Jet 4.0. Note further that Jet itself is obsolete; we should be using ACE (basically...

Well, if the code is not compatible with 2007, I'd rewrite so it uses the newer DAO syntax instead of trying to use the old code that may not work correctly.