I have a need to move an Access table on a server to Oracle. The problem is that there are many Access mdb's that link to the mdb on the network drive. So...

Problem In a multi-use database, how do I restrict a user from having access to certain records and allow it for others. The scenario is as follows: The...

Problem In a multi-use database, how do I restrict a user from having access to certain records and allow it for others. The scenario is as follows: The...

Is there any ways of putting a lock on an application access db to lock users after, say 90 days? -- The fun is not in the speed but the sudden stops!!!

After creating a form, my screen flickers when I move the mouse across a few labels. I can repeat the problem because the labels are all the same ones that are...

Hi All, I copied my database to a test area and during some table renaming in the test database I lost all the links between the tables in the relationships...

Hi All, I have to do some work where I need to copy some original data from a existing table into another identical test table in another database. The tables...

I am trying to decide the best way to design a DB that tracks inventory of Electronic Equipment. Where I am struggling is that the various types of equipment...

I have a Supplier table that contains 'supplier name' and 'supplier number' fields. Both are unique. I have chosen 'supplier number' to be primary. In a...

Hi All, Is there anyway that I place a button on a main for form to switch the subform form view between data sheet and form view? Or is there another way? I...

Hi All, I have two related tables that are updated via a form. I need an item of data in the second to be mandatory i.e.. Default Value only populates...

When I do a crosstab query, the dates do not come out in ascending date order; for example: 1/12/2004 1/19/2004 1/26/2004 1/5/2004 12/29/2003 The above...

Hi,, I have a table with a default value =time$. Problem is when I enter a new record the time value of the NEXT record defaults to the time when that...

Hi All, I notice there is a variable called CurrentUser(). I would like to have this value automatically added as the default value in a field in a table...

Hi, I tried to import dbf file into MS Access and it looked good. I notice that the problem screw up my queries setting. I notice that the field name...

In the middle of database design and need some advice - I am unsure if I went down the right path... In my DB, each customer has lots of information -...

I put a linked table to SQL Server in an Access 2003 database. The field I want to link on in the SQL db is a social security number without the...

I am trying to figure out how to set the default value of a field called email. I want the default value to be pulled from the inputed data in a field called...

I have a table that has 10 characters in a "part" field. There could only be 7 or 6 (variable) characters that are actual, usable data. I have a form where a...

Hi All, I am looking to redesign our server database to deal with clusters and virtual servers better than the existing one does. My problem is that whatever...