Search results for query: *

Even still, that shouldn't make that big of a difference. I have an entire sub accounting system front end that is only about 10mb. It has graphics, and images to make more "pretty" and 10K+ lines of code as well as numerous forms, lots of queries and reports. The backend is in SQL 2000, and...

The connection string is this.... cnSQL.Open _ "Provider= sqloledb;Driver=SQL Server;" & _ "Server=servername;" & _ "Database=DatabaseName;UID=sa;PWD=********" replace servername with the name of the server replace databasename with the name of the database on that server replace...

Also, try a compact and repair on the database. It could be severely bloated. Beware that the compact and repair could take quite a while on a database of that size though.

Why would you want to?? If you are pushing 2GB in Access, you really need to look at migrating to something other than Access for the backend. Take a look at one of these..... MSDE My SQL SQL Server

Try This..... 'Sets values Set cnSQL = New ADODB.Connection Set cmd = New ADODB.Command 'Opens a connection to the SQL server cnSQL.Open _ "Provider= sqloledb;Driver=SQL Server;" & _ "Server=servername;" & _ "Database=DatabaseName;UID=sa;PWD=********"...

Never mind, I figured it out. Inorder for this to run, the user id I use to connect to SQL with must have the same permissions as the sa login or it won't work. Thanks.

I am posting this here because it seems to be more of a VBA issue than SQL. I have a sp setup on a SQL Server that runs a job. I can call the sp from Query Analizer and it runs without a problem, but when I try calling the same sp from VBA, I get the following error: Run-time error...

On the multiple monitor issue..... About half of everyone where I work have 2 monitors. The guys in our trading room have 3 or 4.

You can also just add the fields to the table and set defaults. Set the default in the date field to =Date() Set the default in the time field to =Time()

I have never had to deal with name fields that contained something other than the first name and last name. Off the top of my head, not sure how I would do it. If I get some free time today, I will see if I can come up with something.

intLoc = instr(1, yourfieldnamehere, " ") strFirst = mid(yourfieldnamehere,1, intloc - 1) strLast = mid(yourfieldnamehere, intloc + 1, maxlengthoffield) This is what I do in your type of situation. This is off the top of my head and my need tweaked a little. Mark

I agree with sfreeman's suggestion of a fe/be. The setting that you are changing is not a database specific setting. It must me changed locally on each machine that will be running the database.

I believe that WebEx may also have what you are looking for.

Thanks. I will give the suggestions a try and let you know how it goes. Thanks again.

That is the way I was planning on doing it, but the thought of having to recreate the file for one or two pieces of missing data is not sitting well. Thanks for the response.

Is it possible to edit an existing text file from VBA?? We receive a file daily from a vendor that contains informaiton that we pull into our database and then pass the file onto another company which uses it for processing. The problem is that occassionally, there is data missing from the...

There is a lot of overhead with logos in a database. So the 290k file could potentionally take up a lot more space than that within the database. I don't know a whole lot about logos and the different formats, but try converting them to a jpeg and see if that helps any.

Have you tried compact and repair on the database?

To turn off the warning messages, the line before 'Beep', you would put: DoCmd.SetWarnings False To turn the warning messages back on, the line after 'DoCmd.OpenReport "RIFA_select_totals_05", acPreview, "", ""', you would put DoCmd.SetWarnings True

When I link my tables to Access from SQL, I use a generic user and password for SQL authentication. That user only has datareader and datawriter access. Then I secure my front end and use that login to drive the access the user gets in the database.