Topics Search

Access 2010 Runtime - Link to backend database

Access 2010 Runtime - Link to backend database
Views: 66
and having trouble sourcing information that makes sense.

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
Sponsored Links:

More topics

 

How to re-link tables

Preview
I have a database with the frontend and backend on same network. Now when I have to do changes to it I take a copy of the frontend or backend home and re-link the table on my computer.

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
 

Frontend/backend: Writing data not working on some computers

Preview
SERVER1 - Holds the database back end. Permissions on the database file (And folders it's in) are full access for everyone.

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.
 

Access 2010 Ribbon - Runtime

Preview
We are in the process of upgrading from Access 97 to Access 2010

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.
 

Linking frontend access into SQL database

Preview
I have a access 2010. Database which I split into frontend and backend which works well.

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.
 

2010 Runtime ADODB Connection Failure

Preview
I have a routine which connects to MySQL database with ADODB connection. This worked in 2003 and 2007 runtime but throws a 430 error on 2010 runtime. It works in full access 2010. Has there been a change of policy to restrict this type of connection in the 2010 runtime?

If I use a linked ODBC table instead of ADODB the runtime fails with "Runtime Error". It still works in full access
 

access 2010 windows7 nas linked tables

Preview
Have had 4 new pc.s(windows7 office 2010) connected to a network attached storage device.
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
 

Runtime access 2010

Preview
I need a beginners tutorial on the use of Runtime - I have access 2010 installed - I think I downloaded and installed access runtime for 2010 - for the life of me I cannot find any references to runtime in access or in windows list of programs.

I tried to publish the DB but all I got was a accde extension not the accdr.
 

Access 2010 Runtime Database

Preview
I want to deploy a single user database to one laptop which has a fullly blown version of Office 2010 on it.

Can I still install runtime on this machine and produce a runtime version of the database
 

Depolying ACCESS 2010 runtime

Preview
The database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is first deleted. Deleting the VBA project removes code from modules, forms and reports.

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
 

Runtime 2010 ADODB Connection failure

Preview
I have a routine which connects to MySQL database with ADODB connection. This worked in 2003 and 2007 runtime but throws a 430 error on 2010 runtime.

Error 430: Class does not support Automation or does not support expected interface
It works in full access 2010. Has there been a change of policy to restrict this type of connection in the 2010 runtime?

If I use a linked ODBC table instead of ADODB the runtime fails with "Runtime Error". It still works in full access.