Not Valid Path error

[Kiran Prakash]

As i try to open the access database and relate forms its gives me error message as shown in image.


Verified all network connections and server data's were all found ok . But still receiving this error message

[ranman256]

do you have linked tables? (not shown)
do not use drive letters to link tables, ...ALWAYS use full UNC paths: \\server\folder\folder\database.accdb
relink w UNC paths.

do you have vb code referencing objects?

[CJ_London]

I agree with Ranman, use UNC. With regards your error, perhaps you do not have a mapped drive S? or perhaps it is mapped to a different location?

[Kiran Prakash]

Ok Thank You.

Yes there are many tables attached to the database.

Actually we are working with data that has to be shared over server. But i actually created the Access database in my Desktop which is connected to server and then later changed location of access database to sharing folder .

Now is there any solution to re link the paths ? Or i have to start right from the scratch ?

[CJ_London]

plenty of vba examples around to automate linking, but for a one off, use the linked table manager to relink

[moke123]

You may want to check out JStreet Relinker. https://www.jstreettech.com/downloads.aspx

Its very simple to integrate and especially helpful during development if you move the files around or want to switch between backends.