Recent content by muppetmad

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...