there are many threads about Table Linking but i coud not find one that answers my specific questions.
1. Can i either prevent database from linking to my tables? (or give permissins )
2. If not, can i make the table read only when linking?
3. Is there a way to confirm what databases are linked to my tables?
We have a case where there is an append query in one database that is is updating another database table. We have moved all the tables to MS-SQL (2008) using the SSMA tool. We were wondering if it would be possible to create a new linked table in the DB where the append query is. Of course we cannot use the SSMA tool again since the table already exists on the MS-SQL server.
Normally when I try to make linked tables from Access, it wants to create a ODBC connection which we are not using.
I have a database with a number of linked tables that are linked to tables in different databases (not a back-end).for example, I have table1 that is linked to table1 in K:databasedb1.mdb.table2 linked to table2 in S:datadata.mdb.and so on...
However, recently we have moved all our databases to a new location.
K:databasedb1.mdb is now residing in O:masterdatabase
and S:datadata.mdb is now residing in O:masterdata
and so on...
I'm now in charge of relinking all those tables to point to the new location.I would do this in linked table manager one by one but we have 100s of tables linked to multiple different databases in different location.is there a way to create a VBA code that will automatically do this re-linking process?
so,
1. find unlinkable tables
2. search its new location under O:master
3. re-link it to the new location
Database names and tables names have not been changed. Just the location of databases.
I'm trying to use a template to track assets-specifically this template:URL....Is there a way I can link an excel doc to my database that provides all of my data, that is thereby linked to other tables within Access?I want my data to be updated as it is manipulated within the independent excel doc when I open access.
View 6 Replies View RelatedI have a db that runs call stats (Master) this exports to several Department (Slave) Databses. The Slave db's can be accessed by any of number of Managers.
My problems (Amongst others!) is that I run the master every 15 mins and the slaves are linked to the master tables. How can I set this up so that these slaves can be updated whilst they are logged into?
Is there a way to prevent Access from the absurd notion it needs to concatenate 'DBO_' as prefix to tables linked from SQL Server db? :mad:
Thanks.
I have built a database and within it my queries I use for reporting make tables in a separate database. This allows me to work in my data base and update info as needed. My problem is that my make table queries wont run if anyone has one of the report pivot tables open. I have added macros to all the Excel files that pull from the reporting DB but I still have several times when I cannot update because someone is using the pivot table, Is there a way to allow me to update the report DB's while the pivot tables are open? I have tried using manual refresh methods and disabling auto update on open but the result is the same.
View 2 Replies View RelatedHi, I wonder if anyone can help me. I'm very frustrated I have a database that I didn't create and the links aren't working on other users pc's but they are on mine. There are 9 links to various databases. 8 out of 9 work on my laptop. The 2 important ones don't work for other users. If I log on to another pc then the 2 important links don't work but all others work including the one that didn't work on my laptop.
I relaly don't understand this, the only thing I can think of is to go on every users pc and restore links but I know I shouldn't have to do that.
Has anyone got any suggestions?
Hi,
I have two databases in Access.
One of the database acts as backend i.e it has only tables including some Linked Tables(which are linked to some third database)
Other database is an executable in which all the tables are linked to the bakend database.
I am not able to link to the linked tables in the backed database. Is there a way of doing that?
I have a Form that refers to two Reports, both of which refer to two query's one for each. the whole lot(1 Form, 2 Reports, 2 Querys) is in one mdb file and the actual database is another mdb file. How do I get my objects to get their data from the main Data Base File? the 5 objects are acting as a small report making application.
View 5 Replies View Related:confused: Does anyone know if there is any way to link to seperate databases so that any information entered in one will update the same information in the other and visevirsa?
Thanks
Hey all!
Okay, so here's a real puzzle, so put on yur thinking caps!
I have two large databases that are twins of eachother, with only a minor difference in a small corner of one table. Even the forms are exactly the same.
I want to split each one from thier tables, so I have databases strictly for [tables], and strictly [forms, queries and reports]...
Then I would like to get rid of one of the copy cat [forms, queries and reports] db's leaving a single [f,q and rpts] db with the ability of ANY user (not a semi-skilled db dev such as me) to have the option at opening, which db to link to for the tables (without going into the tool bar, since it is not visible to them).
Is there an EASY way for a "non-dev" user to choose which [tables db] on an opening form/switchboard?
Live long....prosper.
i have a table called tbl1. in this table i have field month, year, or trainee. is it possible that above mentioned three field found same data table automatically delte those rows. so i found only unique data. or their is another way to make this possible.
View 2 Replies View RelatedExtreme novice small business trying to use Access, need some help.
I want to setup a simple payroll system in Access - we have a database of 13 employees already in Access as well as a form we created with fields to enter hours and calculate total due. This may end up being very easy or very hard, but I'd like to know how to, first, set up the form so that it performs the calculations (hourly rate x hours) and then enter this information into another database that will keep track of the weekly payroll...is this far more complicated than I think? Any help/suggestions/points in the right direction are much appreciated.
I have two databases that are used by different teams. There is reluctance for both teams to use the same data base because they are used for different purposes etc.
However, there is quite a bit of information that crosses over. Basically, when an order is logged it goes to Database A (DBA) then they import the customer information such as name, address etc. Then the order is passed to team B who deal with the order, who use Database B (DBB). Currently Team B have to import all of this information again into DBB.
What I want to do is link the two databases so that once something has been added to DBA it becomes available from a drop down list on DBB and team B can then import all of the other necessary information they need.
What would be the best way of linking these up? i thought about trying to create a button in DBB so that when it is selected it asks for an order number which would then search DBA for that number and provide a new record in DBB with the first few fields already completed.
Attached is my many to many relationship setup. I would like to prevent the possibility of entering the same person more than once for the same training event. I am assuming that I do this by setting an index setting for a field the junction table?
View 3 Replies View RelatedI have Linked a few ODBC Databases to my database in the Tables objects. How do I make them usable for queries or as record source for my form? I tried to create a query but the ODBC databases do not show up in the Table options.
View 14 Replies View RelatedI currently have two Access Databases (one with the raw 'data' and the other with the queries and reports that turn it into 'information' - the data database links into the other).
For contingency purposes, I now want to move both Databases onto sharepoint in case I have a system failure on my laptop (I don't have a server I can put these on). When I upload these onto Sharepoint the second database still seems to link to the file on my computer..
Is there a way I can get a Database to link into another database that's held on sharepoint?
Table in my access 2010 is configured to have a unique records (no duplicates)which has now records more than 2000 so i copied the table and pasted Structure only. what i would like to have is that new table which presently is empty should not add any record which is already available in old table. While entering data in new table i would like users to see the error if they try to enter the record which was previously entered in old table.
View 8 Replies View RelatedHi
I have an access database which is linked to several tables in other SQL databases. I have made a list box displaying a single field from one of the linked tables. I have the list set to multiselect simple. After I've made a selection and then go to close the form I get this error message.
ODBC - Insert on a linked table 'dbo_Name" failed.
I dont want to change any data in this table. I only want to read and extract it to another table. How can I stop access from wanting to update the table.
OK I've thought about it some more, can I as part of the on click commands for the close button, clear any selections from the list prior to closing the form. That way there are no fields selected to be changed and no error message. If I can any pointers on how?
I am currently working on a database which has links to two other databases both of which are password protected. The problem occurs when the main database needs to access data in the others as it prompts for their passwords to be entered.
I was wondering if anyone knew a way to automate this so that the user would not be asked for the password but instead it would be coded into the main database.
Any help would be appreciated.
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?
Is there a way to query any system tables to list all tables that are being referenced in any queries, forms, reports, modules, etc.? We've inherited a rather large Access application containing some tables that we suspect aren't being used at all by the application, and we'd like to verify this suspicion before deleting these tables.
TIA
I have two tables, which have same fields. The tables are used for keeping record of news clippings, that are clipped in two different offices. I understand that the best way to manage the database will be combining them into the same table. Yet, it's not an option for the time for some technical reasons. Each table has the same fields as follow:
Input date
issue date
headline in English
news source
category
I want to have a list of news clips from the two tables by a specific category. I will have a form, that allows user to select category as the criteria to query the two tables. I manage to do that in a single table, but how to do it for two tables. This will be very help if you can help. ideally, I can use category to query news clips as well as academic journal clips (from another table) table.
Thanks.
Can we link a table of one database to a query of another database ?
View 1 Replies View RelatedIs it possible to create a table and create a field that links to field in another table?
View 11 Replies View Related