Search results for query: *

Hi, I want to create a procedure "EXISTDROP" that will drop a SQL Server table where the table name is passed from my VB app. Here is what I have but I'm getting the error message: "Incorrect syntax near @TABLENAME on line 5" CREATE PROCEDURE EXISTDROP @TABLENAME VARCHAR(75) AS IF EXISTS...

Hi, Does anyone know the max db size of the SQL server 2000 Personal Edition? I know the max db size for the MSDE 2000 engine is only 2GB, I was hoping for more space in the personal edition. Also - what is the going purchase rate for the personal edition? Thanks, Christy.

Hi, I have an Access front-end w/ SQL Server back-end. I have a stored procedure that checks to see if a SQL server file exists, and if so, it deletes it. The only problem is, once the file is delete, the stored proc gives me an error that the file doesn't exist. How do I suppress these...

hi, I have an Access front-end w/ an SQL Server back-end, and want to know how I can check to see if a file exists on the SQL server? My code gives me an error when the file doesn't exist: Dim rs As ADODB.Recordset Dim cn As ADODB.Connection Dim db As Database Dim cstring As String Set rs =...

Hi, I'm trying to read a .csv file using a data adapter. I've tried several different connection strings, but no luck yet. Here is my latest string.... If ext.Text = "csv" Then 'Connection string for a Text File Dim connectionstring As String...

I am new to VB, and have VB.Net 7.1. from Visual Studio Net. I wanted to know if VB.Net uses the same syntax as VB 6.0? The connection string proprerty seems different; here is what i have to use to connect to an Access DB: Public Sub ConnectToAccess() Dim conn As New...

Hi, I have a webpage created in FrontPage 2000, and I want my users to be able to type in their email address (fieldname=ADDRESS) so it goes in a "guest book" - either appended to a .txt file or as part of an email body sent to me at info@autoaudit.com (my website is autoaudit.com)...

Hi, One of my users on my Access2000 application, .mde, is seeing this error message for every button he clicks: "THE EXPRESSION ON CLICK YOU ENTERED AS THE EVENT PROPERTY SETTING PRODUCED THE FOLLOWING ERROR: CANNOT UPDATE DATABASE OR OBJECT IS READ ONLY" I zipped the file up and...

Hi, I have developed an app in Access 2002, 2000, & 97. Some of my users are having errors that I am not seeing on my computer and I think it's version compatibility issues. My questions to you are: 1) Do you think using Visual Basic instead of Access is a better solution to a stand-alone...

Hi, When I run the following code in Access 97, I get a runtime 3290 error "Syntax problem with CREATE TABLE statement". dim str as string str = "CREATE TABLE tbl_seee1;" docmd.runsql (str) do you see anything wrong with the above code? it works in 2000 so it is a...

Hello, I have a 2000 db that I converted to 97. When I run my program, I get a run-time error 3290 saying "syntax error in CREATE TABLE" statement. My code is: dim str as string str = "CREATE TABLE tbl_seee1;" docmd.runsql(str) Does anyone know why I would see this error...

Hi, I have an Access 2000 db that I need to convert to 97 for one of my users. When I convert it (database utilities / convert to prior version), the FILE / GET EXTERNAL DATA / IMPORT function is lost / shaded out and unavailable. I want my 97 users to be able to import data. Does anyone know...

Hi, One of my clients would like to modify my Access software to link to his Oracle db. I have found some useful code to link to the db, but have no db to practice on. Does anyone have a sample Oracle db that they could email me so I could practice my connection? Thanks, Christy.

Hi, I'm in serious trouble. I was experimenting with the TOOLS/STARTUP settings and un-clicked the options like "database window" and "toolbars". Now, I can't edit my database at all! I tried to un-.mde my other version but can't figure out how to do this. And I don't...