Path error

[jongjong]

Hi,

Please help us with the error when we open the file on different computer as shown attached. We no longer have communication with the programmer. I apologized If there are missing information. Im into Basic of Access now.




I hope a step so that I can fix it.

appreciate it.

[June7]

Is this a split design db? Is CSubData.mdb the backend? Is C drive path location on the first computer? Can the second computer see the first computer files? What is the frontend file name - does it have an mdb extension? If you are on a network, the backend should be on the central file server then in frontend set up link pathing to the server file.

[jongjong]

Is this a split design db? Is CSubData.mdb the backend? Is C drive path location on the first computer? Can the second computer see the first computer files? What is the frontend file name - does it have an mdb extension? If you are on a network, the backend should be on the central file server then in frontend set up link pathing to the server file.

I'm afraid Im not able to answer your question right but I'll try.


1. Is CSubData.mdb the backend?
-- Please see screenshot I hope it helps. When I click debug it shows the highlighted macros created.


2. Is C drive path location on the first computer?
-- Yes.
3. Can the second computer see the first computer files?
-- No. Getting error ...path is invalid.


4. Its not on a network. I don't know if it was created it a network environment.

[June7]

This really looks like a split design. If it weren't split there would not be a link error. If it were an 'all-in-one' db, everything - tables, queries, forms, reports, code - would all be in same file. With a split db, the tables are in one file (the backend) and everything else is in another file (the frontend). The frontend must set links to the backend. If you move either file, the links will fail.

[Mick99]

Hi JongJong, the issue is easy to fix.

1)To start with create a folder on your desktop called DbData.
2)Copy the CSubData.mdb database onto a Thumb drive or if it is on the same computer simply copy it into the folder you just created.

If the data base used to work on this computer then someone has moved the folder that holds the backend.
else
the backend is on another computer and you will need to copy that over to your computer.

Given that MS Access is looking at the C: drive means that it was probably never on a network, so I wouldn't be too worried about that.

C:\Users\corinthian homes\Desktop\DbData\CSubData.mdb


Cheers Mick