Removing References

[chipymunk via AccessMonster.com]

Hey folks,

Got a problem here and I'm not sure how to fix it. At one time, my
computer's mapped network drives got fouled up. In the end, I got mapped
network drives pointing to the save Server location. One was labled P and
the other N. The problem is that somewhere, my database is pointing to the N
Drive. I dont want that. Because I've had to go around to all my users and
remap their drives to include the N Drive.

So I ran Linked Table Manager and all my linked tables are pointing to the
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?

 

[pietlinden]

Hey folks,

Got a problem here and I'm not sure how to fix it.  At one time, my
computer's mapped network drives got fouled up.  In the end, I got mapped
network drives pointing to the save Server location.  One was labled P and
the other N.  The problem is that somewhere, my database is pointing tothe N
Drive.  I dont want that.  Because I've had to go around to all my users and
remap their drives to include the N Drive.

So I ran Linked Table Manager and all my linked tables are pointing to the
correct location now.  But I still get an error when opening one of theforms.
So how do I find out where my form is pointing and correct it?

You would be much better off using the UNC path when you do this
instead of a mapped drive letter. There's code at VBNet to convert
from mapped drive to UNC.

 

[Klatuu]

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\

 

[chipymunk via AccessMonster.com]

No I know that. I'm getting to that part. I've inherited this database from
someone who didnt know that much about them. So its on my agenda of things
to do. I think I've narrowed it down to the form. When I open the, there is
a reference to that mapped network drive. But I cant find it. I'm thinking
about just destroying the form and starting from scratch,which was also on my
agenda of things to accomplish.

Hey folks,

[quoted text clipped - 11 lines]
You would be much better off using the UNC path when you do this
instead of a mapped drive letter. There's code at VBNet to convert
from mapped drive to UNC.

 

[chipymunk via AccessMonster.com]

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 importing the old data.

chip

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?

 

[chipymunk via AccessMonster.com]

One more observation. When I'm in the FE, I dbl click on the Linked table.
I get the same error. So now I'm not sure that its a form issue, rather
perhaps a linked table issue. But I get no error on the BE. I can open up
the table, without issue there.

So my FE is pointing to the wrong BE. At least as far as this one table is
concerned. No other tables have this problem..

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 importing the old data.

chip

Have you checked the record source property of the form to see what data it
is trying to use?

[quoted text clipped - 22 lines]

 

[Londa Sue]

I'm interested in anyone has a solution to this problem. I've investigated
what I thought would be the problem with my database (one user is getting the
error, the other two are not). If I open the database from its server
location or using my front end, I get no errors when I click on the command
button to open the main form; it opens as designed. If the user (one w/prob)
tries to open it from the server location, then he gets the error 3044 when
he tries to click on a command button that opens the main form.

Thanks,