Linking To Another Database

Dec 1, 2005

I use a packaged software program at the dealership I work at. In the past I have been able to pull queries and information out of the database and into Excel. The query builder pulls the data as read-only and thus no fear of changing the main database. I have developed an access database for doing commissions. I want to be able to link my database with the companies database as read-only. This would save typing a lot of the duplicate information (ie customer name, date etc.). I have been able to successfully link the 2 databases but realized quickly that anything I change in msaccess will change on the main database. I don't want to corrupt the main database and really only want to pull the information for viewing. Any comments or help would be greatly appreciated.
Thanks
Rob

View Replies


ADVERTISEMENT

Database Size Limited To 2GB / Query Multiple Database Without Linking Tables?

Sep 7, 2011

I'm trying to set up a simple query that links four tables. However, the tables are extremely large, all in excess of 1.5GB each so I had to split the tables up into four separate DBs. I've tried the following with no success:

1) Link the 4 tables in the DB which contains my primary key. This quickly inflates increases the file size above 2GB and won't let me go any further.

2) Build a remote query to connect the four tables. This looked promising until I tried to run the query and it became evident that it only knows to point to the last database source that you specified.

I'm running everything locally on my C drive. The data source are simple text files (1.6 million rows) from the FDA website.

View 3 Replies View Related

Linking To Database

Jun 27, 2005

I have a field on my Form. The form holds all the information about Artists under our record label. I need to be able to attach a copy of each artists contract to their separate form. I just found out that you can't physically attach this. Does anyone have any ideas and how I could play this. Any ideas would be well appreciated.

Thanks
Shane

View 2 Replies View Related

Linking To More Than One Backend Database

Nov 13, 2007

Hi - I have a front end database that is linked to 2 backend databases. I'd like to add code so that after the splashscreen pops up it checks to see if the front end is linked. If not then asks the user to enter the path for the two backend databases. I need your HELP!!1

Bukaw

View 1 Replies View Related

Help With Linking Excel Into A Stores Database

Oct 9, 2006

first time poster, please be kind.
I am currently updating our supply stores database in work. When an item becomes unserviceable we need to attach a form to the item before sending it away. i would like the data entered into the 'unserviceable' table within my database to be transposed onto an excel spreadsheet (see attachment) and then automatically printed out with the data in the relevant boxes. Can anyone tell me how this is done please? My knowledge of access is rather limited and I am teaching myself as I go along.

View 1 Replies View Related

Hyperlinks - Linking To Objects In Database

Apr 7, 2005

I have recently updated my version of Access.
Within a tbl i have a series of hyperlinks.
All of these hyperlinks are linked to an object within the database, a macro as an example.
When i go to edit these hyperlinks, it does not allow me to link 'to objects within the database'. This options used to be available in my older version of Access. Am i missing something?

View 3 Replies View Related

Linking Database Fields To Attachments.

Aug 19, 2004

Hi i am working with a database that contains customer information
and sometimes files and attachments will need to be saved into the
database. I presume i will have to save the attachments somewhere
and then link to them, but i really haven't a clue where to start. Does
anybody have any information about this or even know where i can
look for information!
Thanks in advance!
Treasa

View 2 Replies View Related

General :: Linking To A New Database File

Apr 11, 2013

I am trying to do some different things and want to experiment at this time. You may think this is a C# question, but I have searched everything I can and can't find an answer. Everybody seems to understand it differently and do not give good answers. I have found that Access people are more creative, are willing to take a chance, and will understand the question.

I created a C# project. I created a database with a table in C#. Now, I would like to dump my data from Access into that table. The database is an .sdf file. If I can do this, I may use this as an Access FE BE later on.

View 1 Replies View Related

Re-linking A SQL Database To Access 2010?

Jan 26, 2013

Connect an existing Access project to a different SQL Server database and the instructions are so simple however when I get to On the file tab click SERVER to open the Data Link Properties Dialogue, there isn't a SERVER option to click on.

My SQL server was on my local machine because I use Goldmine PE 9.2. I moved the SQL server to a different machine, I can connect to it, I can use it with Goldmine, all is well from my local machine except when ever I use my .accdb file, since the SQL server has been moved, I have to login with each request by the access file. This is sometimes six and seven times per session, waiting, error message, logging in, waiting, error message, logging in until it has all it needs to produce my required lists. It's mind numbing and I can't for the life of me find where I can reconnect to the SQL database so I don't have to do this so many times per session.

In Access 2010 32bit running windows 7 64bit. How do I find the datalink properties to connect my .accdb to a different sql database?

View 5 Replies View Related

Modules & VBA :: Linking Back End Database With Password?

Apr 28, 2014

I have a Back end (with password) which resides in a netdrive while the front end is installed in each individual users desktop, the problem is, some of the users netdrive was mapped in a different way (different letters..some are J others are G). I'm looking for code that I can relink the database to the front end in runtime, I did try to look in the net but I can't find anything that I can put the password as parameter.

this sample code from Dev is good, but i got an error because the database requires a password.where i can put the password?

Code:

Function fRefreshLinks(NewDbName As String) As Boolean
Dim strMsg As String, collTbls As Collection
Dim i As Integer, strDBPath As String, strTbl As String
Dim dbCurr As Database, dbLink As Database
Dim tdfLocal As TableDef

[code].....

View 8 Replies View Related

General :: Hyperlinks - Linking To Objects In Database

Sep 24, 2012

I have Access 2007 and I use to be able to Hyperlink to an object in my database 9no upgrade0 But suddenly this option is not available. What can I do?

View 4 Replies View Related

Back End Database Linking And Drive Mapping

Feb 25, 2013

I have built a Database links to multiple back end databases. The whole database is completed, and I have to share it across the company, so I have placed the Database and all of the Back End databases on a "public" shared drive. I have the "public" drive stored as my Q drive. So when I link to the back end databases, the path it stores is Q:DatabasesDatabase.accdb

However, the problem is that not everyone will have the "public" drive mapped to Q. It's possible they could have it mapped to P or A or whatever. So if someone has their "public" drive mapped to P, this database will not work (since Q:DatabasesDatabase.accdb would not exist for them - it's really P:DatabasesDatabase.accdb).

Is there a way around this? So that instead of it mapping to the relative letter (Q or P), can it just refer to "public"?

View 2 Replies View Related

Linking A Database To Access On Network Path Level

Apr 2, 2006

Hi there,

I want to link an excel sheet to my database but I dont want to link the location with a drive letter but instead linking the network address. How can this be achieved?

In addition, I want to startup application with a command line in a access macro and used this line but it doesnt work.

\Tgsshs11data.nl.post.comocc&sqa$OPS_ProcessesReportsAwkward est.txt

In general how can you work in access with network path strings?

best regards,


Paul.

View 1 Replies View Related

Linking A Database To Access On Network Path Level

Apr 2, 2006

Hi there,

I want to link an excel sheet to my database but I dont want to link the location with a drive letter but instead linking the network address. How can this be achieved?

In addition, I want to startup application with a command line in a access macro and used this line but it doesnt work.

\Tgsshs11data.nl.post.comocc&sqa$OPS_ProcessesReportsAwkward est.txt

In general how can you work in access with network path strings?

best regards,


Paul.

View 1 Replies View Related

Backend Database - Front End Application Linking Issue

Nov 25, 2007

Hello all,

I have a back end database that i cannot access at the moment. Is it possible to set the link of the tables for the front end application based on the location that the database will be even though i can't see that location now?

Thank you in advance.

View 1 Replies View Related

Modules & VBA :: Linking External Tables To Current Database?

Mar 16, 2015

I was wondering if it was possible to link random external tables to the Active Database through VBA. I would like to run the code that would open up a dialog box that would let the user select the database as well as the tables within that database that the user can select to link to. I am able to select the database and but not able to select the actual tables. The tables will be random so I can't make a constant statement for a specific database.

View 1 Replies View Related

Modules & VBA :: Automatically Linking Database With ODBC Connection

Jun 26, 2015

I am looking to automate the process of linking my Access DB with an ODBC connection to an SQL DB with VBA (unless there's an easier way to do it?) - some sample code - if this is possible at all?

View 2 Replies View Related

General :: Split Database - Prevent Linking To Back End

Jun 25, 2015

I have a split database. I have secured the mde sufficiently but I need to secure the back end so that no one could link to tables in it. If I introduce a password to the back end is this going to require those using front end to supply the password? If not then this could be good solution.

As the database is on the network drive, is there any other way to prevent people to link to the db? Can I hide the db in the network drive? Or should I hide tables in the BE. Should these still be available to be linked?

View 6 Replies View Related

Modules & VBA :: Update Open Form After Linking To A New Backend Database

Mar 18, 2014

I have an Access DB with a form that allows the user to select a new backend database. I can connect to the backend and then .refreshlinks but nothing on the form is updated. I have tried requiring the form but that doesn't do anything. I've tried loads of other things, refresh, recalc etc., but nothing updates the open form.

The only way I have managed to get it to work is to close the form and reopen it, then it shows the data from the newly linked backend database.

While it works, it doesn't look good but also there seems to be some problem with it because eventually it reports an error saying "cannot open any more databases" and when clicking OK comes back with "An error occurred while sending data to the OLE server (the application used to create the object" and a whole bunch of other messages.

I think it might have something to do with the fact that the form has a number of MS graphs open on it, but I'm not sure. Also, I can't track down a particular line of VBA code which causes this error.

how to update a form after changing the backend database.

View 14 Replies View Related

Linking To Another Database From On Database

Nov 20, 2006

I am working on a database that will be an addition to an existing one on the company server. However, to make the overall layout not so complex and allow room for other additions in the future, I'd like to keep the databases separate. This will also ensure more efficiency, integrity and troubleshooting overall.

Does anyone know how this is done?

Thank you in advance for your help,

~Kilch :eek:

View 4 Replies View Related

Securing Backend Like Webserver Database And Linking Via Odbc Or Roaming User Profile

Apr 29, 2006

On a webserver certian files are stored above the root directory. Therefor the user of the website can never access those files directly. But he is utlizing that file.

For example:
We use Hotmail to see our mails. but we never download the complete database.

So is there a method that we can secure the backend using roaming profiles or something else so the user has a link to the backend but cant directly access the backend.

View 2 Replies View Related

Tables :: Two Identical Database - Importing Tables By Linking To Data Source

Dec 3, 2012

I have 2 identical database in terms of structure but it differs in data.

Basically I would like to import data from subDatabase to mainDatabase and ensuring that there are no duplicate records.

I have used the "link to datasource method" through importing the tables to have the "updating" function.

However, this method also means that the records in mainDatabase are also imported over to subDatabase which I do not want.

Is there a method to ensure that the records are shared/update one way only? (i.e. import from subDatabase to mainDatabase and not main to sub?)

View 1 Replies View Related

Forms :: Database With 3 Tables - Linking Combo Boxes And Text Boxes

Jul 29, 2015

I currently have 3 tables within a database with student details of three different classes. I need to create a user form that has a dropdown box which I can select a student from one of these tables with a number of text boxes below which brings up all the students details, then once the student has been selected and the correct details are shown then I need to create a button which allows me to move that student from one table to another.

View 4 Replies View Related

Linking One To Many

Feb 6, 2005

i am new to databases and have developed a ads site

when the user registers they can post ads for free.

i would like to allow one user to post more than one add.

these are my databases

[members]
memberid = autonumber (primary key)
username unique
password
surname
firstname
address
post code
country

[ads]
adid autonumber (primary key)
adtitle
price
picture
contact
date posted
end date

i am guessing i will have to create a one to many database but i am lost at how to do it.

any advice would be appreciated.

View 1 Replies View Related

Linking Help!

Jul 17, 2007

hello,
I've got a back-end/front-end Access database. The front end sits on a user's desktop. There's one table she needs to update, but cannot because it's not linked. It's table called Login that contains passwords/users names. The table did not exist in the front-end. I would like to copy it from the back-end to the front-end and link it, but when I try to do that, I don't see it in the list of tables. I do this rarely. How does this work exactly?

thanks-

View 2 Replies View Related

Linking To A SS

Dec 13, 2007

Is there anyway to link an excel spreadsheet to an existing database table - so that entries into either update each
other?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved