Recent content by awhitsel

I wrote an application using Access 2002/XP, and my supervisor wants to have it upgraded to Visual Basic 6 with a SQL Server 2000 back-end. Is there a program or utility available that can automatically do this, or will I be stuck in re-writing the entire program from scratch. Please advise...

I have a user who is experiencing two errors with an application written in Lotus Approach version 9.8. The application is currently housed on Windows XP machine. The errors are: (1) Can not find the memo and picture plus file for C:\Lotus\Work\Approach\Cymaster.dbf (2) Warning...

I opened up the database in Access 2002 and tried compiling the code, but the "Make MDE File" option is still disabled.

I am working with another person on creating an MDE file out of a Access 2000 database. The program was written in Access 2002 using a default Access 2000 format. Whenever my co-worker tries to compile the database as an MDE file, the option is disabled. When the database is opened in Access...

I have an Access database which I recently upsized to SQL Server using the Upsizing Wizard. When I link to these tables in another Access database, the tables open up OK, but the data is read-only. I can look at the tables in SQL Server, and they are read-write there. Is there a way to move...

We have a large number of CR 8.5 files that involve a picture of someone's signature and their by-line being placed in them. We have recently had several cases of employee turnover in our organization and some of those people have had signatures on those letters. Is there any way to actively...

Can a SQL stored procedure be used as a data source for a Crystal Reports 8.5/9 file, and if so, how do you establish the connection between the report and the procedure? Please advise. Thank you.

So, does that mean if we want to access the SQL Server database without using a DSN, we would need to connect to an ODBC connection?? How do we connect to the SQL Server without using a DSN?

I have an application written in VB5 that contains two CR9 report files imbedded as designer (.dsr) files. We have discovered that these CR9 files are linked to the SQL Server database using an ODCB connection. Is there any way to link the database to these two reports without using an ODBC...

I have an application written in VB 5 using Crystal Reports 9 for a couple of reports. In the code I am using the Report.Database.LogOnServer to set the DSN and database that the CR9 report is looking off of. We would like to be able to change the DSN and database between a production and test...

Yes, any oddball characters that appear need to replaced with either a letter or a number. I tried doing an update query on my end for replacing the characters, but it went nowhere. Please advise. Thanks.

The carat was randomly placed in the text box as a result of an encryption module that was run earlier in the program. The conditions are that the resulting encrypted character must either be a letter or a number - no oddball characters. I am writing a correction module to handle this problem...

I want to be able to change a value in a text box, but I am getting a run-time error 2448 (You can't assign a value to this object.) Here is the code that I am currently using (the current value of the text box is a carat (^), and I want to change it to a letter A): Select Case PER1ID_11Value...

Another update: My co-worker is getting the out of range error again.

An update on this situation: One of my co-workers got this same error. She is now able to access the tables, however, I am still receiving the error. I also receive the error when accessing the Permissions tab for the database properties. After that, I receive an error stating that it could...