CODEWITHSUNDEEP
ms-accessvba
Jaison
Jaison

Reputation:

Query after splitting access database

I have splitted my ms access mdb file into front end and backend

Now i have the backend in the shared folder and frontends in users PC

i havent specified the network path anywhere in the front end to push data to the backend file

Could anyone tell me where i have to specify network path ???

Upvotes: 0

Views: 384

Answers (3)

iDevlop
iDevlop

Reputation: 25272

The network path is in the linked table properties. You have defined it when linking the table. From the front-end, open the linked table in design view and get the properties window. The path is displayed in the description, like DATABASE=I:\ifs\xxx_be.mdb;TABLE=Valuation

Upvotes: 0

apenwarr
apenwarr

Reputation: 11056

Open the front end file. Right click on any table in the database viewer. Pick "Linked Table Manager." Highlight the tables you want to relink. Make sure to check the "always ask" checkbox at the bottom of the window.

Upvotes: 1

Seth Spearman
Seth Spearman

Reputation: 6790

Jaison,

Look at this answer to this question that tells how to split the database...including how to re-link the tables.

Creating the Front End MDE

Seth

Upvotes: 1

Related Questions