hi..
i am using one database as test database in access 97.. but in this database there are some linked tabels... could you please let me know what is the difference btw tabel and linked tabel.. when i try to open these table it gives me error ..path not valid..how can i open this tables..
many thnaks in advance..
nitesha
Hi..
I have one .mde application in which there are some linked tabels.. Now problem is the i can see two such a linked tabel which i can not find into a database(from where the table is exsit.).. this linked table is form same databse where other tables are exist. I tried..to show hidden objects,systemobject..but no joy... Could please how can i find them...Actullay i am working on applicaion which is developed by someone else. form the data of these tables it seems that these are backup data..because these tabe got same data as two others hae..which are amin tables in my application./
I appreciate your help.
Regards
Nitesha
I used two combo boxes in a form to enter data into a table. I want to allow user to look at the table from the Form. Can I use a Command Button to do so? Thank you for your help.
View 5 Replies View RelatedHallo everybody
I have an Access databse in which I have devided the tables into backend and frontend by using the Database Splitter wizard.
Then if I create any tables in the frontend Access file then thease tables are visible only in the front end of this system , not from other systems if I put the back end in network.
its ok for some tables , but now I have a table which I have to put in the shared backend , but if I cerate in the front end it is visible only in front end and if I create in backend it is visible only in backend.
how to send a table in the front end to backend after database splitting is over, so that I can access this table from other systems.
if it is possible please help me.
Thank you.
Kiran
Hi
I want to see Which tabel was opened, who and when opened it.
And if possible I want to see what is changed.
I want to see as I mentioned above as a "log file"
Thank you
Sedat ONAT
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 am trying to build a Form that will show an estimate (then eventually will be moved to a project if customer and employee aggree to price and project) in a Form F_Estimates is a M_Customers(Customer_ID) (Based on a Table) and thier info in a Subform. Also is the "projected costs" from parts out of the Parts(Part_ID) (Based on another Table) in a second Subform as a list that I need to calculate $$$ in
(Dang that still sounds evil and definately NOT understandable even after edit... so)
Here's some basic info
Tables
EstimatesandParts - Table
EstimatesandParts_ID : Autonumber
Estimate_ID : Number
Part_ID : Number
Parts - Table
Part_ID : Autonumber
PartNumber : Text (not a number due to some part#s have letters in them)
PartName : Text
Unit Price : Currency
Description : Text
Estimates - Table
Estimate_ID : Autonumber
InvoiceNumber : Text (again can have letters in it)
EstimateDate : Date/Time
EstimateTime : Date/Time
Employee_ID : Number
Customer_ID : Number
ProblemDescription : Memo
Customers - Table
Customer_ID : Autonumber
FirstName : Text
LastName : Text
CompanyName : Text
Address : Text
City : Text
Province_State : Text
Postal_ZIPCode : Text (CDN Postal codes are letter num letter...)
you can see the link table in the EstimatesandParts Table
Now I want to use that link to populate a subform in the F_Estimates form
Forms
SF_Customers - SubForm
(all boxes atm are text boxes on this form till I figure out the Parts section then will use same base for this so I can pick any customer in the database to be the customer for this estimate. Also will have ctrl button for making new customer with customer form and a refresh on Focus Gain bit of code)
FirstName
LastName
CompanyName
Address
City
Province_State
Postal_ZIPCode
SF_Parts - SubForm
Default View -Continuous Forms
(want it to be a list of parts that I can grab prices and descriptions from then in a bit of code to calculate a cost of parts)
Part_ID : Combo Box
Control Source - Part_ID
Row Source Type - Table/Query
Row Source - SELECT Parts.Part_ID, Parts.PartNumber, Parts.PartName, Parts.UnitPrice, Parts.Description FROM Parts ORDER BY Parts.Description;
(Pulls info from the table Parts for input into a list of parts to be used on that project)
PartName : Text Box
UnitPrice : Text Box
(here's where I run into problems due to the fact that the form is not based on the parts table but rather the link table EstimatesandParts so I can't propogate the info to the 2 other text boxes, ps I dont care if they cant be text boxes and have to be linked or some other type I'm not "set" just need to find out how to make it work )
(have tried a couple things to complete this task)
Me.txtPartName = Me.Part_ID.Column(2)
Me.txtUnitPrice = Me.Part_ID.Column(3)
(works AWSOME ... for ONE ROW then propogates the second selection to the first and second and third selection to first second and third and so on ...)
(tried to make control source for the txtPartName to)
=Forms!Parts!Partname
(Doesnt exist .. akkk, cant use ActiveForm either as it doesn't focus on the SubForm but the MainForm ... cry)
F_Estimates - Form
Estimate_ID
InvioceNumber
EstimateDate
EstimateTime
ProblemDescription
(all basic Text Boxes)
Employee_ID
Customer_ID
(Combo Boxes Select Customer and Employee from list of present ones of each)
SF_Customers
SF_Parts
(Both SubForms on the main form)
Now this is an Exerp from my entire Database I like to work on one small problem at a time and I have made this its own little database till I figure out the problem then I will bring the info I learn back into the rest of the database and go from there ...
Hope you can help I have a feeling I will need to make a recordset and go from there but I'm just not able to wrap my head around that for some reason
Thanks in advance for ANY and ALL help that I get from here
Hi,
I have an Access 2000 database with some linked tables. When upsizing the database I selected 'Save password and user ID with attached tables'.
Therefore in the Linked Table manager after each table in brackets I have the name of the database to which the tables are linked.
I am now wondering if I want to link the tables to a different database how do I change the database name, which is in brackets after the table name.
If I select a table and select 'prompt for a new location each time' I am getting prompted to select a different DSN. At the moment I don't have a DSN and I don't want to have to set one up.
I imagine that the database name and the user id and password I entered in the upsizing wizard are stored in some configuration box but I don't know where I can access this.
Can anyone point me in the right direction??
Thanks
I have a database with the tables linked from another database. The problem is that i need to copy the database to and from another machine in order to work on it. As this involves putting it in a different location each time, i have to relink the tables.
Is there a way to link the tables reletively so that as long as they are in the same Directory they will be linked?
Column A in Spreadsheet is AlphaNumeric and Numeric. When I link to the worksheet, it displays the Alphanumeric entries but shows #Num! for the numeric entries. I have tried changing the format of the cells from number, general and text but get the same results. How can I show both alphanumeric and numeric in a table?
EXAMPLE:
DC100900
AA999111
11199922
Thank you in advance for any assistance!
I have a frontend and a backend to my database. Actually, I have two backends....one with real data and one with sample data.
Currently when I am switching between databases, I am using the Linked Table Manager, which I am finding to be a bit of a pain. If I am already linked to one of the two backends, in order to switch to the other I have to rename the one currently in use so that it will prompt me for the new source.
I think MS Access looks for the current link before asking you for a new one. If the current link is still active it won't ask you for the new one. Renaming the current link effectively makes the link 'inactive' and allows me to link to the other database.
Does anyone know a better way to do this?? Can I change the link in code?? That way I could just make myself a form that I could use to switch between the two different backends.
Any other ways to resolve this would also be appreciated.
Thanks
Brian
I have only started using acces recently. When working I have used strange names for queries forms and tables. I would like to "clean" the file and rename some items. I have found acces not to rename linked parts automatically. Is this possible? Thank you.
View 1 Replies View RelatedHi,
How can I prevent the user to link tables from SQL Server?
In SQL Server, I give out read and insert permission on specific table in SQL Server, I create one MS Access database which linked tables, I hided the database windows, create the forms. I want the user to input/read the data via the forms.
However, if the user create the new MS Access file, and then use ODBC to link tables himself if he knows server name and database name. He can see and input the data into the table directly.
So, how can I prevent the user to link tables to their files?
Hi,
I'm using Access 97. I have an Access application that consists of two databases, a front end witht he usual forms, reports, queries etc. and a back end with the data.
I use my own simple logon form to restrict access at the front end, but nothing on the back end.
I really want to restrict access to the back end by placing a password on the database.
How do I still allow people who use the front end to get into the system and access the data, yet prevent them from accessing the back end directly?
I have put the password on the back end easily enough, but when I try to use the front end I just get the message, 'Invalid Password'.
Regards,
Bernard D
Is it same thing about speed and other issues to have ADP application that works with SQLserver and to have a MDB (or MDE) application that has no querys but works with sql views instead?
Thanks
Hi there people.
Just wondered if anyone had linked an .mdb backend to a .accdb frontend and wondered if they encountered any problems. Or indeed, if it's do-able.
Oh, the frontend is Access2007 and the backend is Access2003
The data tables are exactly the same it's just that the forms are prettier in 2007 and the records in reports can be edited individually.
Hi folks,
I have a table and I want most of the fields available to others. I also want the other users to be able to add fields to the table (not the master but theirs). Here's an example to explain it better:
MasterTable contains the following fields:
Name,Address,Phone,Training,Checks.
I want the Users to have a linked table with access to:
Name,Address,Phone
I also want the users to be able to add their own fields like:
Date of Birth etc. to have a table that is linked to Master but they can change some fields.
Any suggestion would be much appreciated.
Thanks,
Colin.
OK, so now in my Dbase Ive got the main data, and another table with 2 fields in,
in the second table its a part number and a weight,
on the main data I need the user to select the Part number with a combobox that the weight is filled in the maindata automatically, I dont understand Relational Dbases, yet so if anyone knows how I can do this, please explain in little words, lol
I did manage to do this earlier in the dbase with box sizes and weights but as there are only 4 size of box I coded it into he VB, but with the caps there could be up to 100 different caps.
Anyone HELP PLZ.
I am connecting linked tables in access 97 , my database is splitted into frontend and backend and i am linking tables to backend but i gets an erros application or B]object definition [/B] error. whats the way out?
View 1 Replies View RelatedI have a database that is really just a bunch of reports based off of one excel sheet. I am using the excel sheet as a linked table.
My problem is that there is going to be a number of copies of this database in use, and i want the user to be able to say where this excel sheet is located, but not every time the database starts up, only when they change location.
the database is not opening up with the database window displaying so i cant teach them how to go to the properties and linked table manager.
what can i do that will detect if the database cant find the table, the linked table manager will open up automatically?
I have 7 tables to track client data. The 1st table uses AutoNumber to create the 'Client ID' number. The other 6 tables are linked to this table, and in turn each other, through the 'Client ID' field.
All information entered in all 7 tables is done so on one form. This form has a tab control to separate the input fields.
The problem is this. If I enter information in the form, but no field in one or more of the tables gets filled (table gets left completely empty because the fields were not relevant to that record), the record does not save itself to where it can be viewed in the form anymore.
I have programmed a command button to copy the 'Client ID' from the 1st table to the rest, and so far this works, but I would like to have this done automatically without any action required by the user. I tried the 'OnDirty' for the ClientID field on the form, but I do not think that works. Mybe 'OnUpdate'?
Any suggestions?
Help please.
I have a text file containing approx. 45000 rows of data. I've created a linked table to upload the file into access keeping the seperator's in place. The file has date and time recorded as e.g. 20050123 for 23/01/2005 and 91527 for 09:15:27.
Therefore I'm trying to run a macro on the linked table to delete all records from an existing backup table, append new records to it, convert dates, convert times.
However, every time I change the text file to another set of data, the append query falls over. If I go into design view of the query, delete the fields and recreate the fields the query will then run.
It appears as though because the data being linked has changed, the query doesn't recognise the linked table anymore.
Any ideas?
Cheers
D
I'm working with a split database. I frequently change the b/e link to different .mdb files. Sometimes it's because I'm debugging or testing changes to the front end, sometimes it's because I'm working with data from different projects.
I thought it would be nice if I could display the name of the currently-linked back-end .mdb file on a form. I've been unable to find a way to return to a variable the name of the b/e file.
Any suggestions?
I'm using Access 97 (still) on Windows XP Pro.
Can anyone help me change a link to attached tables relative rather than absolute?
View 2 Replies View RelatedHi,
I use a number of tables as data for Combo boxes (i.e. Equipment List, Site Lists etc.).
Using these directly linked to the BE DB was quite slow so therefore I run queries on startip of the DB to copy the data from the BE to the FE and base the queries on the FE. This all works fine and I have no issues with this.
My questions is mainly in regard to the redundant linked tables. Do these have an effect both memory and performance wise after the initial update?
If so, am I better using a recordset update to populate the FE tables on startup and deleting the linked table and append query?
What is the recommended best way to deal with this kind of issue?
Regards
JC
Hello,
I've inherited someone elses databases and I'm tryi ng to update some tables to add new fields. When I look at these in design view I get this message:
"Table ... is a linked table with some properties that can't be modified" And it won't let me add these new fields.
How do I get access to change this to allow me to add these fields?
[BTWI'm using Access 2003.]
Thanks for any help