Work my DB over Network

[heman85]

Hello People
This is my excenario

I have a DB closed (accde)and I have the Front End with other linked tables all closed (accde)
All my DB and linked tables are on my Server (Place on C:\MyDATA)

I share this folder (Server C:\MyData) to get a mappingfrom this folder on a workstation. If I try to use the database over a mapping drive, I receive a error like dont found the tables.

How can I work over the network this DB?

 

[Galaxiom]

The workstations will be looking for the tables on their own drive.

Change the links to a UNC path.
If you need to used mapped drives then map the folder on your own drive to the same letter used by the others.

 

[heman85]

The workstations will be looking for the tables on their own drive.

Change the links to a UNC path.
If you need to used mapped drives then map the folder on your own drive to the same letter used by the others.

UNC Path???
What is that?

 

[Galaxiom]

UNC = Uniform Naming Convention

\\Computername\sharename\subfolder\file.extension

Computername is the name our your PC
Sharename is the name given to the shared folder in your share setup

 

[heman85]

UNC = Uniform Naming Convention

\\Computername\sharename\subfolder\file.extension

Computername is the name our your PC
Sharename is the name given to the shared folder in your share setup

I gonna try Thanks Very Much

 

[heman85]

I gonna try Thanks Very Much

Nop dont work

 

[Galaxiom]

Difficult to point to what is wrong without knowing more about your network. Could be a firewall problem.

Check the other computers can see the shared folder on your computer using the UNC path typed into their Windows Explorer.
Are you sharing just the folder or the whole of your C drive?

Note that the share in the UNC path is not C:\ but the sharename.

 

[heman85]

Difficult to point to what is wrong without knowing more about your network. Could be a firewall problem.

Check the other computers can see the shared folder on your computer using the UNC path typed into their Windows Explorer.
Are you sharing just the folder or the whole of your C drive?

Note that the share in the UNC path is not C:\ but the sharename.

I share the C: drive and the folder on the servr and set permissions to everyone.

My application load but appear a message trying to find a local database. I save the tables in the same folder that the Frond End (Main Form) C:\my application

 

[heman85]

Difficult to point to what is wrong without knowing more about your network. Could be a firewall problem.

Check the other computers can see the shared folder on your computer using the UNC path typed into their Windows Explorer.
Are you sharing just the folder or the whole of your C drive?

Note that the share in the UNC path is not C:\ but the sharename.

Its not a network problem All firewalls are disconected and I can see my folder over the ntwork (Browse)

 

[Galaxiom]

My application load but appear a message trying to find a local database.

This sounds like the tables are still linked inside Access via their C:\ path.
I also think I have misunderstood the location of the tables.

They need to be linked inside Access with their share path.