Search results for query: *

Bingo, figured it out just as you replied! Thanks!

Or maybe there is a setting on the sql server that allows you to omit the prefixes (something like "Force fully qualified table names")?

Well i setup a sysdba user and it's still wanting me to use the prefixes. Any way in the connection string I can prevent this?

I wrote a bunch of code with queries that only specify the table name, without the prefixes. I was using sysdba as the user id in the connection string. Now I am using sa and I think that's the reason it wants me to reference a table in the format dbname.userid.tablename. My questions are...

I don't think this is possible but wanted to check and make sure. We have to enter data manually on a website and then click a submit button to send the data to them, one record at a time. I want to write a program that automates entering this information and sends the data, the same way the...

I can add trusted sites to the registry, thanks anyway.

I found these links: http://msdn.microsoft.com/en-us/library/ms537143(VS.85).aspx http://msdn.microsoft.com/en-us/library/ms537181(VS.85).aspx#programmatic but I don't understand how I put this into my VB .NET application to make it happen. Can someone help? What I will be adding is not a...

Okay thanks!

I'm curious as to whether or not there is a way to log every connection and query run against the database. If so, could someone give me a brief description on what would be involved? Thanks!

I have an application that right now works with palm handhelds. Basically the palm synchronizes with several "temporary" access databases, and then the windows application connects to those databases and pulls the information into the main database. I need to redesign this using Windows CE...

It started working! No idea why, I just tried linking to the rtf file while it was in a different directory and that did it.

Not sure what you mean by check the encoding, but it's an RTF file... created in wordpad. I tried recreating the files in wordpad and saving them as RTF's and it still doesn't work. I'm out of ideas!

I created a setup project that installs my web application just fine. However, I added a license agreement form and a readme form and set the file properties to rtf files and it is coming up blank. Here's exactly what I did: 1. Created setup project to be part of the solution that includes...

Thank you for the code shelton! Chrissie1 this is in fact the problem because every one of our clients experiences the issue. Removing .NET 2.0 framework fixes the issue for everyone as well.

Thank you for the reply! Our application launches a client-side application and basically it breaks if it is the 1.1 version and the user upgraded to version 2.0. The reason this happens, as it was explained to me, is that the app tries to use the 2.0 version of any control no matter what...

Is anyone else having problems with stuff written for .NET 1.1 not working when the client upgrades to .NET 2.0? Unless I'm missing something, how can microsoft think this is okay to release a software upgrade that breaks applications made for the previous versions???? Also, is Microsoft...

Table is indexed on the primary key. All fields are as small as possible. I think we've just found access' limit. I reduced the number of records by a lot in the one table and now the database is back to flying, even after a compact and repair. We're just going to move these bigger accounts...

I have an application that I believe to be growing beyond the capabilities of Access. There is a table with about 5.9 million records that my application is having speed issues accessing after compacting. Here's the deal: DB size (no compact): 700mb Records in table: 5.9 million Simultaneous...

I have an application that uses a VB 6.0 front end with an access db and when users run reports on a machine with either of these versions of norton (haven't tested any others) the report speeds are decreased by over 50%. An example: Run report and it takes 24 minutes Remove norton Run report...

So I guess the (0) tells the select method to select the first record in the results? Thanks!