So this is my problem, which i have worked on for waaay to many hours now.
I have Visual Studio 2010, an SQL express server, and i am trying to write a simple database program.
I have a table on the SQL server, tbl_todo. This table contains some fields, some are date, int and 1 field which is bugging me, which is a bit field.
I make a dataset to this table alone, using just the default optios on the...
MrDeej
Last Activity: Aug 6 '11, 05:42 PM
Joined: Apr 21 '07
Location: Norway
-
Bug i VS? Datagridview + checkbox = error
-
Push events from client to client
Hello!
I have a little trouble formulating the heading of this tread, but i will explain what my challenge is.
First of all, we are converting from Ms Access to Vistual Studio 2010 for our internal programs.
In that conversion we want to start with some of the basic functions we have created. One of which is a messaging system in the Access database.
The access messaging system works like... -
For your wan conserns you could use local .accdb or .mdb files on each computer, which are connected to a SQL server trough VPN or whatever.
When each user has his own copy off the file, and just the data is trafficed trough the WAN the speed issue is less of a bugger. We have been using Access->SQL trough a 2mbit internet connection at one plant connected to my company. -
I am not sure what you want, but some things i can help you with.
First off all you have written code in both ADO and DAO. I think ADO is faster and more programming friendly. Secondly you have added excess code wich dosent do anything.
Here is ADO to insert posts.
...Code:dim Rst as new adodb.recordset with rst .open "Select * from [yourtable],currentproject.connection,adopenforwardonly,adlockoptimistic
Leave a comment:
-
How to convert Access VBA to Visual Studio?
Hello my good people!
We have developed an application on the Access plattform for the last 3 years. Now we see that it has grown to a size where we would like to convert to standalone program because of Access licensing demand. I have been in contact with MS about Visual Studio and gotten a price for 300€ pr license of VS.
I also had some technical questions about VS, but there MS have a technical customer support... -
You should be albe to use the same .mdb or .accdb by different users. Access is deafult shared database, but when you enter the database and start making design changes access locks down the file.
Make sure the users dont have to make design changes. At my firm we was at the most 15 users on the same .mdb at the same time. No problem, with using it. But we had to convert away from relational tables and bound forms to non-relational...Leave a comment:
-
For this database it worked with group by. It seems a little slower to show the results, but it works.
However, i have a different database on another computer, and this one works without the group by clause on a similar query to the same table/server. It is also some difference in service packs and hotfixes on that access installation.
Maybe it is a difference in somehow access communicates with sql server, OLE DB and...Leave a comment:
-
Hmm.. same result when i us the "WHERE LSLGNR IN ('TDO')"
To make the confusing even bigger i get only 'TDO' result when i use the group by option in the query. This way i actually can use it, but still dont like Access having such bugs.Leave a comment:
-
Bug in access query engine?
This SQL
returns these values
Anybody have an idea of what causes this?... -
Using Access on terminal with lower res than 640 x 480
Hello!
I need to run my access .mdb on a terminal with resolution at 320x240. Access gives me an error message when i open. I can bypass this by making forms with the active content that fit the 320x240 box and let resolution be 640x480 but the logon screen (Citrix ica) gets all misplaced and is not very userfriendly.
So, therefore i ask if anybody know a way to bypass this limitation? All forms and function works very... -
Separate table should solve your challenge.
Like i wrote in #4
Or maybe i have misunderstood youLeave a comment:
-
Yes you can add the field [location]
This however limits you to 1 location pr product.
I have built a similar system, but with 900 products and 3500 locations :=). Each product can be at uppto 20 different location inside our productionLeave a comment:
-
you can use DAO with SQL server and Access.
For normal usage you wont feel so much difference, ADO gives you more options as a programmer but for the user it isnt much difference.Leave a comment:
-
Just one table
[tbl stock location]
Fields:
ID, Product ID, Lokation, Quantity , etc etc
then you have good flexibilityLeave a comment:
-
Found it
Shift+F2 :)Leave a comment:
-
VBA shortcut goto procedure
Hello!
I have a question.
In our VB code we have alot of procedures which calls other procedures. Is it a way to jump to the procedure which you are call'ing in the project explorer?
Today we use ctrl+f to find the call'ed procedure, but i think this is a pretty stumble way to thing.
Please let me now :=) -
You can do it in the sql of the combox
Example:
Select field1,field2,f ield3 as ' ' from table [bla bla bla]Leave a comment:
-
A lot of work done now, but it works as hell.
For special interested people i post my code
First the user interface:
To make wherestring based on textboxes above listbox:
...Code:Function Opprett_Where_utrykk_SP(Where As String, Skjema As String, tbxnavn As String, Verdi As String, Liste As String, Optional Avansert As String) As String Dim Indikator As String
Leave a comment:
-
Thank you Jim Doherty. Pass-trough query did the job, it is considerably faster when i open my left joined table with 1 million posts :=)
Thanks a million.
Here is a good link for finding the walktrough by m$
http://support.microsoft.com/kb/303968
And NeoPa: Could you ellaborate? We also use ADO to populate listboxes, but by experience there are some functions that doesnt work with ADO that works...Leave a comment:
-
Retrieve Records from Stored Procedure
Hello my good people!
It have come to my mind that stored procedures can help us speed up the retrival of records from our SQL server.
I have now made a stored procedure at our server which is called "StoreProcedure 1"
normally i would use this code to populate listboxes with information. I would prefer to use a stored procedure cause of the speed advantage i think it has.
...Code:
No activity results to display
Leave a comment: