Access 2000 vs 2003

[Will]

We have an old computer with Access 2000 on it.

We have a simple single table Access 2003 database on another computer on a
Peer-to-Peer network.

We call that computer the "Network Drive" as it has most of our files on it.

We have a single user entering new records in the database from the old
computer.

Ocassionally when she finishes entering data into a record and tries to go
to the next new record she gets a popup message... and the new record won't
get added to the data base.

We have to quit and restart Access on the old computer... and she has to
re-enter the new record.

We don't have the exact message now but it seems it was something about the
drive not being available or something.

I'll post back if when I get the exact message unless someone can help me
with this information.

I'm not sure if there is an issue updating records in an Access 2003 db from
a machine running Access 2000 or what is going on.

Thanks for any help.

 

[Allen Browne]

If the error message reads:
Error Message: Error Accessing File. Network Connection May Have Been
Lost.
it could be this nasty old issue:
http://support.microsoft.com/?id=304548
And if so, your A2000 machine is desparately in need of an upgrade. Get the
service packs for both Office 2000 and JET 4 from:
http://support.microsoft.com/gp/sp

If the file is being used by 2 computers at once, you really need to split
it as described here:
http://allenbrowne.com/ser-01.html

You may also find that a Decompile is useful, especially as you have been
using different versions. Steps:

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database to get rid of this junk:
Tools | Database Utilities | Compact

3. Close Access. Make a backup copy of the file. Decompile the database by
entering something like this at the command prompt while Access is not
running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

4. Open Access, and compact again.

 

[Tony Toews]

We don't have the exact message now but it seems it was something about the
drive not being available or something.

We need the exact error message but I suspect it was "Disk or Network
Error" If so that generally means a flaky network connection such as
a loose cable.

I'm not sure if there is an issue updating records in an Access 2003 db from
a machine running Access 2000 or what is going on.

So long as your systems are up to date on the Office and Windows
patches that shouldn't matter.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm