Office 2003 access problem when moving from one machine to another

T

Tom van Stiphout

You need to give us more information. What EXACTLY happens when you
open the file at the office? Access does not care if it's running on
Win2000 or WinXP.
DO NOT open a database file with Notepad (or much worse: Word); you
may well cause corruption. There is nothing relevant to see, and
certainly nothing to edit.

-Tom.
 
M

MrT

Hi:

I made access db on home machine Office 2003 Win2k then took to
office with xp & Office 2003 and it won't open. I looked in file with
text editor and it contains information on path on original Win2k
machine. Why??

How do I get around this?
 
B

Bob Larson

Did you open the file with the text editor when you had it on your home
machine too? Sounds like you may have corrupted the file even before you
brought it to work. You should open an Access file with Access or the
Access runtime, not with any other Office product or Notepad, or Wordpad,
etc.

--

Thanks,

Bob Larson
Access MVP
Administrator, Access World Forums
Utter Access VIP
 
P

Pete D.

Yes they are,
1. Use same version or newer of the Access program as the datafile was
created in.
2. Have full access (security) to the location of the datafile.
3. If you use linked tables in a backend make sure you update them after
moving to new machine.
 
M

MrT

Thanks.

No I did not open it before taking it to then office. I only looked
after problem.

Bottom line: Are the db files portable? Just copy and save on new
machine? Even if there are reports?
 
P

Pete D.

Right click on the table in Access and click delete. This will delete the
link to the file. BACKUP FIRST!!!
 
M

MrT

Pete said:
Yes they are,
1. Use same version or newer of the Access program as the datafile was
created in.
2. Have full access (security) to the location of the datafile.
3. If you use linked tables in a backend make sure you update them after
moving to new machine.
Click to expand...

Thank you. That is what the error message was. Linked tables. The
original data was created in Dbase (I find Dbase much easier to
manipulate than any more recent products) then imported into access.

How do I de-link it.?

Thanks

Best regards
 
M

MrT

Pete said:
Right click on the table in Access and click delete. This will delete the
link to the file. BACKUP FIRST!!!
Click to expand...


I did and now the mdb won't open says the file is not there. It also
says it is a dbf file (the original name of the DBase file).

I am very confused now. When opening (importing) a dbf file and you
end up with a file with the extension mdb why does it say it is a dbf file?


So I am back where I was with the linked table.
 
M

MrT

Hi:

I had to delete and recreate with get data import. Seems Ok now.
Had to recreate the dbf too since instructions for importing said use
same structure as source so I deleted all records in mdb and it deleted
all records in linked dbf without warning me. Oh well, live and learn.


Thanks again.

Thanks.
 
Top