Search results

I am using adp to front end a SQL server database. When I open forms and specifiy a where condition it seems to set the server filter property of the form to my condition. If I then open the form to create new records or edit a whole recordset the filter is then applied. Is this a feature or a bug?

BTW. In my design I created a relationship from tbl_user, tbl_administrator and tbl_engineer to tbl_login by including a foreign key column - FK_tbl_login - in each of the tables.

My original database design was such that each person type table i.e user, engineer, administrator had their own table (tbl_user, tbl_engineer and tbl_administrator). Each table had a one-to-one relationship with a table called tbl_address and a one-to-one relationship with a table called...

Surely the engineer-person and user-person relationship has the same problem but one level higher. i.e I still have one child table (in this case person) with two relationships to seperate parents (user and engineer).

Is it possible to have two 1-2-many relationships from a single table? Presumably you would need two foreign keys but one would always be null. Is that possible?

Unfortunately not in this case because both are entirely different entities in terms of their content, parent tables, etc. Its simply a case of having two tables that happen to have the same relationship with another table.

I have two tables tbl_engineer & tbl_user. Potentially the people in either table can be trained. I'd like to store details of this training in tbl_training. So my question is; How do I create a relationship from tbl_training to both tbl_engineer & tbl_user that ensures RI?

Good morning I have a list box with a SQL server view as the data source. I want the dataset to be filtered to include only results with a particular foreign key which is stored in a field on my form. I can do it in the behind module by programmatically specifying the row source but I'm...

I have an MS Access database where the tables are held in a backend on a file server and the forms, reports, queries, etc are held in a front-end which is distributed to each user. This has worked fine up to now. I now have a requirement to access a number of MySQL tables that are held in a...

I have some cde in which I'm trying to ignore error 3349 whenever it occurs. The code ignores it fine the first time but the second time the error occurs the code does not seen to go into the error handler. Can anyone help? Private Sub butGo_Click() Dim db As DAO.database Dim tdf As...

We have an Access Database split between front and back-end. The BE is 50Mb and the front about 60Mb. We have a requirement to provide access to the database to our other branches all of which have broadband. I have been trying to find out the best way to achieve this over IP as we do not want...

I've tried that but to no avail I'm afraid.

My understanding is that in UK law its pretty straightforward that if you work for a company they own the copyright to anything that their employees design as part of their normal role. I have no problem with that at all. My question is effectively what does IPR do that isn't already covered by...

I have designed a software package based around an Access Database at my company (based in the UK). There is a good chance that the company will be able to sell the software and potentially make a handsome profit. My boss wants me to sign an Intellectual Property Rights agreement. Does anybody...

I still haven't managed to fix this problem. Any ideas?

I have a main form with a subform which in-turn also has a subform (in datasheet mode). When the user clicks a button on the main form I want to disable all of the controls on the subforms. This works fine until the user clicks the button while the focus is on one of the text fields in one of...

As an addition; All of my primary keys are autonumber and all of the foreign keys are long integers. Is there a more efficient way of storing the foreign key? The foreign keys are all indexed duplicates OK.

Relationships The database is configured as follows; One parent record (the enquiry); Multiple child records (site addresses); 7 different types of child record (project types). There are 1-many RI relationships in all above. The project types are vastly different and require different...

I have an address table which had five one-to-many RI relationships with other tables. I recently added two more tables/relationships and it seems to have slowed down my database. I made other changes at the same time so can't be sure. Would I be correct in saying that this is something that can...

Come on guys. I know you know really.