Re: Connecting to Remote Acess DB

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Use UNC (Universal Naming Convention) and you do not need to do any of this.
See the MS Knowledge Base article KB192689.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource@xxxxxxxxxxxxxxx
www.pcdatasheet.com

"Kevin" <Kevin@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:85A8E752-541D-40A5-BC1E-C9C5250EB88A@xxxxxxxxxxxxxxxx
>I am developing an Access DB that will reside on a networked PC that I want
> to access from any PC connected to the network. I will have an access
> front
> end connect to the backend db. I am developing this for a friends business
> and he will have probably 8 or 10 PCs to connect all networked. I do not
> want
> to connect using ODBC because I will not be there to be sure it is done
> correcty. I just want the link to be Access file to Access File. I need a
> routine to locate the db on the networked PC through the File System. The
> network drive will be mapped. How can I do this. I think I would want to
> check to see if the tables are linked properly and if not, the routine
> would
> find the file and refresh the link automatically without user interaction.
> Any help would be greatly appreciated!


.

Relevant Pages

  • Help with blocking access
    ... With the help us someone here a while back, I setup REJECTs in my access file after all my RELAY address for each network 1-255... ... This I thought took care of my problem of unauthorized connections as we want to force everything through some authorized gateways and disable connections from any other network or IP address. ...
    (comp.mail.sendmail)
  • files open slow when using folder redirect
    ... I have set-up GPs to rediect 'My Documents' to a network share ... When I open an Word, Excel, Access file, it ... If I make the same network location a 'home directory', ...
    (microsoft.public.win2000.group_policy)
  • Connecting to Remote Acess DB
    ... I am developing an Access DB that will reside on a networked PC that I want ... to access from any PC connected to the network. ... I just want the link to be Access file to Access File. ... routine to locate the db on the networked PC through the File System. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Profile issue
    ... and can access file on the network. ... inspiron 1150 and he is able to rename files on the network. ... Permissions are unrelated to user profiles, ...
    (microsoft.public.windows.server.active_directory)
  • Re: Database Access
    ... database, and point at it and see if it works. ... No, I actually meant put it on a network shared drive on a server, like those usually around in a corporate environment. ... Additionally, if the user of the "host" PC shut down, everybody would be s.o.l. ...
    (microsoft.public.dotnet.framework)