[AccessD] Default File Format

In the problem module declare a compiler constant....

#Const ACCESS2000 = True

Then further down in the module

#if not ACCESS2000
	SetOption "Default File Format", acFileFormatAccess2000
#End If

You will have to set the compile constant to False for all the other users.

Lambert 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Monday, July 28, 2008 3:43 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Default File Format

In my library file, with is identical at each customer, is a SetOption
method to set the Default File Format to Access 2000.  The code is this:

	SetOption "Default File Format", acFileFormatAccess2000

However, I'm setting up a new customer who uses Access 2000, the above
Option doesn't exist, and compiling fails.

How can I set up a procedure which will ensure that this code line works in
Access 2002 and 2003, and does compile in Access 2000?  I tried to do
something with late binding, but that didn't seem to work.

Thanks!
Dan


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com