VB6 front end to SQL Server Express 2008

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I have very little experience with any version of SQL Server but quite
a bit using mdb files. But I now have a requirement to build a
database application where there will be upwards of 500 new records
being made per day. Based on the amount of data being captured I
estimate that an mdb based system will begin to sweat big time in
three to six months. So I am looking for an alternative and up popped
SQL Server 2008 Express in my research.

I have never used it but I understand it can be used via VB6. I'd like
to hear from anyone who has done so and, if possible, see some web
links to some tutroials or any other help.

Bernie
.

Relevant Pages

  • Re: Uploading Access database
    ... You can (if you remove .mdb files from the list of non-allowed files) add a ... I.e. SQL Server can handle converting this file into a blob/image for ... The problems come if you use the database from WSS. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: DTS Examples of moving data from Access to SQL Server
    ... >I'm going to use a DTS package to move multiple MDB files into SQL Server ... Is there anywere that has good example of different parts of DTS ... If so, I'll move it into the SQL Server, ...
    (microsoft.public.sqlserver.dts)
  • Re: Search multiple MS Access database files via asp.net web application
    ... Instead of having 10,000 individual mdb's, you need to consolidate your ... Access, being a desktop database system, ... like Sql Server - where one Sql Server database alone can store a ... I am assuming each of the 10,000 mdb files is pretty ...
    (comp.databases.ms-access)
  • "There isnt enough memory" error
    ... and back ends are MDB files, so no SQL Server involved here. ... dynamically hidden based on the contents of a recordset, ... Only one of the reports has a graphic on it (a linked bmp, ...
    (microsoft.public.access.reports)
  • Swapping DBs
    ... ..mdb files and send them to other users ... I have been reading that with SQL Server Express, you can treat databases ... we can not use SQL Server Express because it doesn't support ...
    (microsoft.public.sqlserver.msde)