|
hi all
i have an quick Project i must do for a Client, is it advisable to use a Stored Procedure for Access as a Backend, and how is that Compiled, i always do sql, OR SHOULD I use naked SQl ?
Thanks
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Just to be clear, do you want stored procedures for Access as the backend database, or are you using Access as a front-end to a SQL Database?
If you want stored procedures for Access, then you cannot. The closest you will get is to use a Query, which is effectively the same as an SQL View.
Steve Jowett
-------------------------
It is offen dangerous to try and see someone else's point of view, without proper training. Douglas Adams (Mostly Harmless)
|
|
|
|
|
Thanks you, that means i wil use a naked SQL , a Query .
Thanks
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Access doesn't support stored procedures.
It does support stored queries, if that is enough for your purposes. (It's basically a stored procedure that is limited to a single query, and has no other featuers like flow control commands.)
As such, stored queries doesn't add much, so it's mostly a matter of taste if you want to use them or not.
Experience is the sum of all the mistakes you have done.
|
|
|
|
|
Hi there VB Pros i'm doing a project that requires to encrypt and decrypt files.
I need to create this algo from scratch.
Anyone has any clues as to how to do that??
|
|
|
|
|
How complex does it have to be?
You could use a simple character replacement method, based on a string provided by the user or some other source.
Steve Jowett
-------------------------
It is offen dangerous to try and see someone else's point of view, without proper training. Douglas Adams (Mostly Harmless)
|
|
|
|
|
Got your message. Does not have to be complex a simple encryption algorithm to encrypt and decrypt files.
The button sub routine will contain the algo when the user clicks the button the file gets encrypted.
|
|
|
|
|
Where does the requirement that you do it from scratch come from? Its 99.99% likely that if you write your own algorithm it won't last 15 minutes of cryptanalysis....
|
|
|
|
|
wantta know how to solve this problem!!!!
xlApp = New Excel.Application
xlBook = xlApp.Workbooks.Add
when added workbooks to excel application
this error occour..
"Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))"
|
|
|
|
|
Hi,
I also got this error, when i try to run my already created application on my friends PC, the problem is he has the Office 2000 in his pc installed.
Do one thing uninstall the office from your pc and install the XP or higher version of office.
Hope this will help you.
with regards
Yogesh Agarwal
|
|
|
|
|
thanks alot for u advice..
yes, it is cause of my excel is old version..
now upgrade to office2003.. it is ok...
|
|
|
|
|
yogesh_kumar_agarwal is right!
You'll probably need to use 'Late Binding'
instead of 'Early Binding'.
Therefore do NOT use the MS Excel ObjectLibrary and
Imports Microsoft.Office.Interop.Excel .
'Google' for MS Excel, Late Binding & VB.NET and
you'll probably get your answer.
Good Luck.
|
|
|
|
|
thank you answer ...
i can solve it now, by update office to 2003
|
|
|
|
|
|
That's odd. There is a managed API, but it's very limited and buggy. You can use it for simple video playback, etc, however.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
sir,
can you provide me the link from which i get Managed API ?
Thanks
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
My Company
|
|
|
|
|
How Can I Compress And Decompress A File Using Visual Basic 6.0
Manoj
|
|
|
|
|
Check out this MSDN article[^]
Steve Jowett
-------------------------
It is offen dangerous to try and see someone else's point of view, without proper training. Douglas Adams (Mostly Harmless)
|
|
|
|
|
Hello there,
I have a “load” event on a startup form with a notifyicon that starts a timer on another form to execute code at a given time from settings in My.Settings. This works well.
Then I make use of a login form to stop the timer and load the form where the timer is on and adjust My.Settings via numericupdowns to change the given time to execute the code and use a button to start the timer again.
The problem is that it is not using my new settings. I tried My.Settings.Save() – which only works when I restart the app.
The timer is stopped before I adjust the numericupdowns and it does start again on the button exit.
Help please
|
|
|
|
|
Did your code reload the settings after you Saved them? You might want to check out the Reload method of My.Settings.
|
|
|
|
|
|
Hi every one
I had a application in VB6 which we migrated to VB 2005 Express
The application is designed to access a centralized DB server (Postgres 8.2) and all the clients will have there own copy of the application
In my Vb6 application I was able to connect to the DB using ADODB connection and ODBC data source / DSN, this gave me freedom that no matter where the DB server is located I can just configure the DSN in each client machine and the application will work
Now when I want to do the same with .Net I am not able to do the same.
I had tried using Npgsql and Data.OleDb.OleDbConnection
But I am not able to succeed
Can u plz give me an idea how to do it, any sample or reference if possible?
Regards
Nishkarsh
|
|
|
|
|
Did you look at these options?
Clickety[^]
nishkarsh_k wrote: I had tried using Npgsql and Data.OleDb.OleDbConnection
some error information would be useful, I would expect the OleDb connection string to work but I note there are some caveats on installed components with the connection string. They also supply and ODBC method you may be more comfortable with.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
All the options given in the link involve server IP, but i wanted to do it with using DSN
can u plz send a example to use ODBC or OleDb with DSN.
|
|
|
|
|
I am have problems adding records to an array. I am using a structure and an arraylist
Code Snippet
Public Persons As New ArrayList
Public Structure Person
Public First As String
Public Last As String
Public Home As String
Public Work As String
Public Mobile As String
End Structure
and the next block is to add a record to the list
Code Snippet
Dim p As New Person
p.First = txtFirst2.Text
p.Last = txtLast2.Text
p.Home = txtHome2.Text
p.Work = txtWork2.Text
p.Mobile = txtMobile2.Text
Persons.Add(p)
lstPhone.Items.Add(p.First + " " + p.Last)
The above code works but the trouble i'm having now is I cannot append to the array or save it.
Can anyone help?
Thanks all
Regards
Zeldacat
|
|
|
|