Access 2010 Runtime - Link to backend database
I have a database that is split into a front and back end.
The back end is to reside on a shared network location (yet to be determined but we'll call it \\SERVER\DBSHARE for now).
The front end will be installed on the client workstations.
The Client workstations have mixed versions of Access 03 and Access 07 but all have the Access Runtime 2010 installed.
The problem is when you open the front end it spits an error out saying it can't locate the backend. As this is the Runtime version there is no Link manager to set the path.
I'm assuming (and this may be wrong) that there is a way, somewhere be it the package manager, code, pathfile to be able to say something like "Path to Backend is \\SERVER\DBSHARE\be.accdb"
Does anyone know if there is some way to set the path so that the backend can be linked when using Access Runtime
Thank you for taking the time to report an issue.
What's wrong... Please write below.
Now when I finish it all I want to be able to do is email the frontend or backend to someone without having to drive out there and this computer only has access runtime installed. So I have to go up there, bring my laptop, access their server, and link the database on my laptop, then take the files and drop it on their computer
I would like it when I email them the files an option could pop up to re-link the files since they are just using access runtime
COMPUTER1 - Windows 7, this computer originally created the database using Access 2010 Professional. This computer runs the front end of the database successfully, no problems.
COMPUTER2 / COMPUTER 3 - Windows XP running Access 2010 Runtime / Windows 7 running Access 2010 Runtime. These computers both get a security warning when opening the database. They read data fine, but do not write any data.
No error message is displayed / nothing to indicate that there is a problem.
The database admins have a full copy of 2010 and the general users will have a copy of the Access 2010 runtime installed.
The issue is that when a database is opened in the runtime, the ribbon disappears, this is preventing people from exporting datasheet views to excel etc.
I have decided to move the database into SQL, I used the export wizard and moved the database into SQL which seemed to work, and it I look at the backend which SQL made I seem to see mydata, and if I open SQL it seems to be in that to.
But my problem is, how do I link the access frontend to the SQL backend.
If I use a linked ODBC table instead of ADODB the runtime fails with "Runtime Error". It still works in full access
Database has a front and backend, with backend, on the nas, tables linked.
All pc's link with no problem.
Three of the pc.s if you turn them off, the frontend loses its connection to the backend linked tables.
If I go into external data and look at the mapped conection, it has a red cross, although I can see the network drive and the backend tables from my computer. If I click on mapped conection, the red cross disappears and the link works.
This happens on three of thefour pc's.
Any one have a clue whether this in an access/windows or network problem
Can I still install runtime on this machine and produce a runtime version of the database
You should back up your database before attempting to open the database and delete the VBA project.
My developing environment is Office 2007 ACCESS 2010. My runtime environment is Office 2007 RUNTIME ACCESS 2010.
Both ACCESS Development and Runtime are under SP1 32 bit
I tried to publish the DB but all I got was a accde extension not the accdr.