Using Access on a server with database on local PC

[Rags]

I'll try to explain what I'm trying to do. I want to use the MS Access (2010) application residing on the remote server on a Access database(accdb) that is located on my local (home) PC. I copied the database from the server. How do I get Access (running on the server) to work on my copy of the database?



I tried using my local (on my PC) copy of MS Access (2007) to work on the database, but but I get file errors (file paths look like server paths).

Any help will be appreciated.

Thanks,
Rags

[June7]

This is a split db design? Backend on server and frontend on home PC? You are logging in to the server from home PC?

[ItsMe]

...I want to use the MS Access (2010) application residing on the remote server on a Access database(accdb) that is located on my local (home) PC..

By itself, this statement insinuates the server is your home PC. Remote access is usually handled with RDP, VPN, or a SharePoint list.

[Rags]

The server is not my home PC. The server is located at a remote location. Using my home PC I can access the DB via RDC(Microsoft's remote desktop connection). I have no problem using Access on the server (from hone) and the DB that's on the server. I downloaded the DB to my PC and now I'm trying to access it.

Thanks

[hapm]

Why you want the db locally if you can't edit it locally? Anyway, you can setup your rdp client to forward your local hard drive to the server, or setup a network file share and give the server access to that. In both cases you will have a performance loss because of the network connection.

[ItsMe]

Yah, I do not understand why you are creating a copy of the Access file. If you are using RDP then you should leave everything at the office, so to speak. No front end files and or DB's should be used outside of the company's intranet.

[June7]

Did not answer question - is this a split db design? Exactly what did you copy - just the frontend? Of course the frontend will no longer have links to backend tables.

[Rags]

Why you want the db locally if you can't edit it locally? Anyway, you can setup your rdp client to forward your local hard drive to the server, or setup a network file share and give the server access to that. In both cases you will have a performance loss because of the network connection.

I do want edit it. My goal is to edit a copy residing on my hard drive so as to not corrupt "real" DB. How do I setup my "rdp" to do that?

Thanks

[Rags]

Did not answer question - is this a split db design? Exactly what did you copy - just the frontend? Of course the frontend will no longer have links to backend tables.

Sorry that I didn't answer question. Since I'm not an Access expert, I didn't know what you meant by a split design. When I open DB on my home PC I see form screens and various "buttons", however, when I click on most buttons I get some sort of can't find file error.

[June7]

Do the tables have little arrow at top left edge? This means a linked table and it is a split design.

[Rags]

Do the tables have little arrow at top left edge? This means a linked table and it is a split design.

I don't actually see the tables, just screens like attached. Is this called the front-end? I just want to experiment with a copy of this so as to not corrupt original.

Thanks

[June7]

Is the filename extension .accdb?

Hold down the shift key when opening database. This should override most optional settings and prevent automatic code execution. Then look at tables in the Navigation pane.

[Rags]

Is the filename extension .accdb?

Hold down the shift key when opening database. This should override most optional settings and prevent automatic code execution. Then look at tables in the Navigation pane.

Yes, the extension is .accdb.

[Rags]

Yes, the extension is .accdb.

Thanks for the "shift key" instruction.....that worked when I used Access via RDC and when I used my local copy of Access. However, when I tried to actually open a file locally, the file path Access is looking for is a path on the remote server and I get an error. Is there anyway to modify so I can have the file path be for files on my local PC?

Thanks

[hapm]

What is the files name access is looking for? I expect it to be either a reference to a missing code library or the linked tables that don't find the backend. If its an accdb file you will need to copy it to your local computer as well and fix the linked tables using the table link manager. If its a missing reference install the needed libraries and fix the references using the reference manager from the vba editor.