FP compatible with Access 2000 format database

[whowy04]

I originally was using FP 2000 w/ server ext. 2000 along with a 2003
database. However, when I open Access 2003, it states that my table is of
2000 format --- not sure why.

Anyways, now I've updateed to FP 2003 w/ server ext. 2002 and am still using
the same database.

Now, I'm having issues with storing the data into the dbase once my FP form
is submitted with data. The data doesn't appear, or is stored at a later
time.

Help!!!

 

[Norman Yuan]

Since this is MS Access NG, I'd guess not every visitor to this NG knows
what FP is. I guess it is Front Page? If I am wrong, do not read further.

MS Front Page's version and Front Page Server extension has nothing to do
with MS Access's version. You probably use Access database (*.mdb, more
accurate, Jet Database) in web app(s). These wep apps access data in *.mdb
file via Jet engine, not access. As long as the *.mdb file is good (made in
any version of Access), the properly designed web apps should be able to
access data in it.

Access version's format only matters when you use Access to open *.mdb file.
By default, AccessXP/2003 use Access 2000 format. You can choose to use the
version's native format, though. Remember, old version of Access cannot open
*.mdb in format of newer version. That is why later version Access offer to
use pervious version's format. Again, format only matters when you use
Access to open *.mdb file. It does not affect Jet Engine accessing data in
that file (appling latest Jet Engine Service Pack is always recommended,
though).