Old Fart in Australia needs help!

[Pat Garard]

G'Day ALL,

I would like to create a database for use on a PC with
Office 97 (ie for Access 97).

My PC has Office Xp, my Notebook Office 2000.

Can I do this with the resources that I have available?

 

[Dirk Goldgar]

G'Day ALL,

I would like to create a database for use on a PC with
Office 97 (ie for Access 97).

My PC has Office Xp, my Notebook Office 2000.

Can I do this with the resources that I have available?

You can create your database with either Access 2002 or 2000, and then
convert it to the Access 97 file format. You must be careful to use
only those features of Access which are available in Access 97 -- no
CurrentProject or CurrentData references, no references to a form's
Recordset property, etc. When the database is first opened on the
Access 97 PC, it may be necessary to fix the references. I'm not sure
whether they'll be fixed up automatically for you, and I certainly
wouldn't trust the automatic fixup.

 

[Pat Garard]

G'Day Dirk,

Much appreciated!