Search results

I have and Access MDE attached to a SQL database with multiple users some of which are roaming profiles. The mde is in a local folder on each machine. On 2 of the roaming users when they open the file for the first time on their office machine it works correctly. However once they log off and...

Currently they are only using the Analyze with Excel feature. The text and date fileds Export correctly its the bit fileds (check boxes) that are disappearing.

Access Front SQL back program. When I export a report from my program into Excell the fields with checkmarks disappear. Help!!!

I Have a list box that displays several fields for each recordthe user is able to double click on the row and open the Data-entry form for the specilied record. Of the fields in the list box 3 are Datetime (SQL) The data displays as The Date and time together. I only want to see the time for...

I have two date time fields (time in and time seen) from whick I am calculating the wait time needs to be hours and minutes. This works correctly however I cannot store the data in SQL for the wait time. I know it is due to the dtatype as I am getting an overflow error. However I am not sure...

I have a database that is an Access 2003 front and a SQL back. I have established security using active directory account. My editors/data entry group works correcty. However my second group is unable to see the data. This second group needs to be able to view all the data and only edit one...

Thanks! I am creating a duplicate server for upgrade testing and want to restore the master from a my production server as well as my other databases so that everything is identical. Some of the programs were created by my predessor and I don't want any surprises. When it is time for the real...

When I try to restore my master from a back up fiel it says I need to be in single user mode. How do I get there? SQL 2000

I am chnaging my database from an Access/Access environment to Access/SQL. I have moved my tables and linked all of my tables to my Access front. Now I am having two problems. First, If I go to an existing record I can see it but not edit it. Second, When I go to open a new record I get the...

No other users were on. I did not realize I needed to be using the workgroup admin password when moving my data with DTS.

I am trying to Import data from an Access 03 database to my SQL 2000 server. Whe I user DTS it allows me to enter my type (Microsoft Access) and give my location and a user name and password. Then it gives me the following error. Error Source: Microsoft Jet Database Engine Error Description...

I think it is because the data in the field is acually creating and equation. I feel like I should have the default value in quotes for the reference back but everywhere I have tried to put the quote it has given me the error. Does anyone have a suggestion. Below is what the dafault value for...

On form A I have a text box that I can type anything into and it is saved to a table. I click a button to open form B and the data from some of the fields on form A/the table are used to populate text voxes on form B. Everthing works fine until I type a time into the text box on form A that is...

I want to add code to a command buttton that when clicked prompts the user for two values (beginning date and ending date). The two value are then used as the begining date and ending date in a query (between...and) and then the query is saved with the two new values. The purpose of this is so...

Below is the code I am using to perform the action. This does not use a stored procedure. Who received the error and when appears to be random. The button can be used for several days by several approvers with out any error and the one day one user will have the problem. Also, I checked to see...

My program is an Access 2003 database that connects to SQL 2000. I have a continuous form that shows between 10 an 25 records. I have coded an update button that when clicked updates a check box on each record displayed and then updates the form. Normally this works perfectly. However, sometimes...

I have a query that I export to a text file with fixed width settings. For one particular field that had only been one character and 5 spaces I used PGM: " " & [ProgramCode] for my field. The recipient of the export file requires that this field be 6 spaces long and leading spaces fill in...

I need to query a field for any records where this field has less that 10 characters. Any suggestions? The reason is depending on the type of customer the field can be 10 or 11 digits. IF there are less than 10 but not blank they need to be pulled for correction.

The data is controlled by SQL server the rights are controlled using AD groups. The purpose of the password is to first send the users to the appropriate form (Approver/User) then to only allow them access to their records. However, this problem is occuring for both user types.

I have a custom switchboard that opens a data entry form based on several prompts (additional forms for user name date and password). Everything works correctly. When you close out of the data entry form, you return to the switchboard. If you click the button to open the data entry form again...