Table Information

[Lisa]

A situation occurred where our access database is no longer usable to enter
information. The information in the database can still be viewed.

How can we transfer the existing information from this PC to another PC?
Unfortunately the PCs are not networked. Also, how can the information be
compared between the two systems to ensure that existing records are not
overwritten when the information is transferred?

 

[scott04]

Lisa,

Just a thought but you can always create a new mdb and import all of the
exsisting tables, queries, and forms.

When you say no longer able to enter forms what exactly happens?

 

[Klatuu]

Do you know what it is that is preventing you from entering data in the
database? That would make a difference in how you approach this problem.

If there is no connection between the computers, you will have to transfer
the database to memory stick, CD, or some other removable media both
computers can use.

As to not overwriting data in the other copy of the system, you would have
to construct queries that will filter out duplicate data. Again, without a
complete understanding of your data, it is impossible to provide a detailed
answer.