I did some more googling and I found someone who had the same problem.
Here
is the error I'm getting
"<Path> is not a valid path. Make sure that the path name is spelled
correctly and that you are connected to the server on which the file
resides.
(Error 3044)"
I've moved the BackEnd and tried relinking the tables, it relinked all the
sucessfully instead of the one I'm having trouble with. When I go into
the
BE, I"m able to open the table in a datasheet view. But when I'm in the
front end, I click on the Form to be Opened (Either from my switchboard,
or
directly from teh side bar) and it gives me the above error.
The person who also had this problem just ended up deep sixing their
database
and creating a new one and im****ting the old data.
chip
Klatuu wrote:
>Have you checked the record source property of the form to see what data
it
>is trying to use?
>Is it possible it is using VBA to specify a record source or any other
table.
>
>What error are you getting?
>
>I am suspicious of the mapping being a problem. If the tables are linked
>properly can all your tables and queries can be opened successfully, that
>would be very unusual. Not impossilble, because you can open external
>databases directly in code.
>
>What happens when you open the table in design view?
>When does the form fail?
>If the form has any code in it, it would be a good idea to run in debug
mode
>and trace the code until you get the error so you can pinpoint where it
>happens.
>
>And, as pietlinden says, it is always better to use UNC paths rathter
than
>Drive mapping. It isn't really all that esoteric, it is just the server
name
>and path:
>\\SevverName\SomeFolder\ASubFolder\
>> Hey folks,
>>
>[quoted text clipped - 8 lines]
>> correct location now. But I still get an error when opening one of the
forms.
>> So how do I find out where my form is pointing and correct it?
--
Message posted via http://www.accessmonster.com


|