Search:

That seems to join the 2 lines instead of splitting them


Dim str As String = SerialTextBox.Text.Replace(" ", vbCrLf).Replace(vbTab, vbCrLf)
Dim lines = str.Split({vbCrLf},...

oh so it does, how would i select each line instead of each character?

Hi, can anyone tell me how to remove the extra line break when using this code:


Dim str As String = SerialTextBox.Text.Replace(" ", vbCrLf).Replace(vbTab, vbCrLf)
For Each s As...

Thanks :blush: - Sorry just read other threads across google and some people said you couldnt use @@IDENTITY in access

However, i found a great webpage showing how to retrieve the LastID with...

Am i right in thinking that scope_identity() & @@IDENTITY cannot be used with an Access database?

Hi, yes i just cant get the code suggested to work with my existing insert statement

Existing

Dim sql1 As String
sql1 = "INSERT INTO Products (SKU, Brand, ProductName,...

Unfortunately i'm still having trouble getting this to work :(

The pic below shows the 2 tables (Products & SerialNumbers)

I thought it was best if the serial numbers were put in their own...

That link you sent may contain the answer :)

I want to work out how to add the productid and serialnumber to the serialnumber table

This adds the product details to the products table without any issues


Dim sql1 As String
...

I'm creating an access inventory database, one product can have many serial numbers e.g. 10 laptops same model, different serial numbers

I have 2 tables:
1. Products (Columns=ProductID...)
2....

Have tried dozens of combinations without success :frown:

I would have thought adding this would have excluded all .aspx pages but i'm not sure why it wont work


<add input="{URL}"...

I think i add need to add a 2nd rule to stop .aspx pages from being redirected

I've tried the following but it doesnt work


<rule name="san aspx">
<!--Removes the .aspx...

I've installed a new wordpress website

In order to get friendly links on the website i have added the following code to my web.config - however my existing .aspx page wont post unless i remove it...

After doing a bit of reading i see the SQL CE can be deployed with the reference dll's included, so sql server doesnt need to be installed on the client PC :)

So i could use SQL SE & CE without having to install any sql software on the client PC?

I use MySQL on my own PC for my localhost testing, again could that be used on a client pc without having to...

Database needs to be stored on the local machine, which rules out SQL server express & CE.

Local databases that i know of:
Access (Free-little security)
Sqlite (Free-Moderate security)
Oracle...

Database needs to be stored on the local machine, which rules out SQL server express & CE.

Local databases that i know of:
Access (Free-little security)
Sqlite (Free-Moderate security)
Oracle...

Shaggy, what database would you personally use if you were selling a desktop program?

Currently my .net Desktop app uses an access database which i know has little security.

I need to secure the data so am looking for suggestions on the type of database to use.

I've tried SQlite...

forgot to update - it ended up being the 3rd party obscurification i use. Replaced the reference files and all is working :)

My vb.net software wont work on windows 8 :blush:

I'm running windows 8 x64 on a virtual machine

When i open the program, it crashes and a message pops up "myprogram has stopped working"
...

I'm moving my database from access to sqlite - however i'm having issues with converting the following:


Dim connectStr = (Strings.DBConnectstrings)
Dim strm As New...

My web.config contains passwords to my database and smtp and i want to tighten up the security, i want to protect the passwords fully so if a hacker or webhost employee accessed all the webserver...

If you take my exe.program out of the situation and someone has a database file which in this case is an access database, they can open it and access all the data.

You can password protect the...

I've found this which is for sqlite databases http://sqlcipher.net/

Basically something like this for access databases is what i'm looking for

I've attached data files from 2 of my competitors - data.tqs & data.dat

Please try and read the data - You cant!

I'm not going to spend hours decompiling their source code, they've done enough...

Hi, i currently use an access password protected database to store my app data.

However there are several apps that can reveal access database passwords so i'm looking into securing the data, so...

Many thanks guys - Paul excellent work :)

My database is installed in the Application Data folder, how do i add that location to my database connection string?


Friend DBConnectstrings = "Provider=Microsoft.Jet.Oledb.4.0;Data...

Excellent, many thanks for the pointers :)

Right im off to change a couple of paths

I've done a quick find/replace to change all the registry entries to the HKEY_CURRENT_USER - i didnt realise when i originally wrote it that the registry nodes had different write permissions.

As...

The software is being used on a corporate network, all the users are "standard users" and the IT support are reluctant to grant the users admin rights.

I want to try to solve / fix the issue if...

My software reads/writes to the registry and to the database in the local installation directory.

It runs fine when the user is logged in as an administrator, however if logged in as a standard...

I had the client change the LAN settings to disable the proxy settings and set it to Automatically Detect Settings

The app now trys to connect but shows the following:
...

This is a new customer - first PC they have tried to run the software on

They've asked for the website IP the software connects to so they can add it to their firewall

I'm now awaiting their...

thanks for the info - was thinking i'd have to modify the webrequest for proxy use

Hi, one of my clients is running my exe app from a network PC and its throwing an error showing no internet connection

Could a proxy server be blocking it or is this more likely the companies...

Thanks for the link, i tried a couple of variations but get parse errors

WHERE (CustomerEmail = @CustomerEmail) AND (IsPaid = - 1) LIKE Product ('%', @Product,'%')

My database can have several products in one column 'Products' e.g. Product1,Product2,Product3

I've created a webpage where the user can purchase a 2nd product at a discounted price - however the...

Im trying to make a form so the client can type in their email address and have their activation email resent - similar to a password resend form

The following works, except it will include...