MDB to MDE

[tanha]

in the first place want to offer my best regards to all,
sorry for editing the Thread
I have a MDB file size around 1 mb, I converted that to 2002 and 2003 format, also Converted to MDE too
Problem:
I want to put the DB in the Server and the clients can use of that...How it is possible?

 

[MicroE]

you will need to split the database.
http://www.myaccesstips.com/deploy/deploy.html

 

[a_20120]

Thanks for replying...
I splitted the DB too, But what to do after that, what else I need? what should I install on Srver and what on Client?Do I need to install MSDE or ODBC? plz guide in detial

 

[MicroE]

The link I posted provides detailed documentation on sharing the db over a network. You don’t need MSDE or ODBC. The BE is placed on the server, the FE on each PC.

 

[tanha]

PROBLEM LINKING FE with BE

Hi every body,
Right now I have a BE and FE DB, where I put the BE DB in my own DB, and the FE DB on the client PCs, if the Clients change the place of the FE DB on their PCs, WHAT code do I use to ensure the Front end sees the back end and WHERE do I put the code?

 

[Robert88]

Hi Tanha,

If you always network map to the backend with the same drive you only have to make the relevant connections in the front end to tables in the relevant network mapped drives where the back end tables reside.

Hope it helps.

Robert88

 

[RuralGuy]

You should use the UNC rather than mapped drives. If you link up using the Linked Table Manager, it uses the UNC name.