VB Forum / Database Access / June 2006

We are planning to move our database from Access to Sql server.But the front
end application to remain in Access.We will be creating ODBC links to the sql
server database to use its functionality. The problem is if while creating
the links in Access if  I do not supply the field for ...

How can I create a filed with a no limt field size for storing largs text
strings?
.Fields.Append "Status", adVarChar, [Unlimted filed size here?},
adFldMayBeNull

Is there any way to replace a query in an MS Access database.
I need to do this with access.application in VB 6. This is not a
choice. I cannot introduce DAO to the project.
I've tried the following, but there's no SAVE event. Is there something

I have a table to store staff's rosters, which includes a "Shift_Date"
DateTime field.  I'm wondering is there a function(like WeekDay etc) allows
me to select all Saturday shifts within a period of time?
Thanks!!

I just use DataSet to bind DataSetGrid and display from SQL DB.
when starting run in Visual Studio 2005, get "Line 1: Incorrect syntax near
'1'" error message from below fill line, any help is greatly appriciated.
objDataAdapter.Fill(objDataSet, "mindata")

I'm having troubles running a macro from a form on a table in the same
database.
Essentially. I'm filling in the fields of a form with the results from
a query. The table, form, and macro are located in the same

Hi to all,
I want to change the default-delimiter when I export a table into a
text-file (SELECT * INTO [test.xml] IN 'c:/tmp/' 'Text;' from table).
Does anyone know how to do this?

I keep getting an "object variable or with block variable not set"
error with this code....
I want to use my loadData function twice, to get two different sets of
data, so I figured I could use two DataSource objects and put an

i am having a little trouble getting my grid to update the database.  Im
sure there is something i am missing, but dont know what.
I fill a grid, and then have a monthly or daily price that can be updated.
So i change one price, and click my save button.  The following code

I am an absolute newb and i really dont know what to do.
I am supposed to be moving one database that in an excel file
to a text file that will be used to update the new database.
I dont know how to import data from an excel sheet export

I got stuck in a senario, let me explain in detail.
I am using ADODB.Recordset 2.5 in VB 6.0. I have 2 Recordsets in my
application. One is residing on Client side and other is on Server Side.
1) Server Side Recordset is being used to update any change in data.

I’m trying to design a front end program in VB.NET for a MS Access database.
I’m getting Concurrency Violation errors when updating if there is a DateTime
field in my table that has been edited in Access. Seems to be when there is a
Time value in the column.

I'm running this code:
Dim myQuery As String
Dim myRecordSet As ADODB.Recordset
Set myRecordSet = New ADODB.Recordset

i need some help to understand the structure behind Sage MMS MSSQL
Server tables.
We deal with Sage Line 200 and 500 and do various integrations to get
costs out, stock, add new entries and BOMs automatically from CAD

I am using Microsoft ActiveX Data Object 2.5 control in my application and i
have set my cursor location at adUserClient. Now i want to query my
client-end recordset.
Is it possible to write any SQL statement to get data from recordset or any