Design Process: create front end without actual DBS connections

[dumdum]

It's been about a year since I've done any VB programming. My experience level is what I would consider moderate, but this is something I've never had to do before.

I want to design a VB6 Front End that will use the tables in a SQL 2000 Database but... here at home I do not have SQL Server or the ability to connect to those databases during the design process. I do know the structure of all the tables and I could make copies of those tables if necessary and bring them home.

My goal is to design this at home, load the exe on the computers and work and Wow everbody.

 

[strongm]

MSDE...

 

[ArtieChoke]

Or MS Access - but there are minor differences in SQL...

"I think we're all Bozos on this bus!" - Firesign Theatre

 

[dumdum]

Thanks, I can do Access but I want to make sure I have 100% compatibility with our SQL box/dbs.

 

[vb5prgrmr]

Then go with strongm's suggestion. It is basicly sql lite and it is free or if you can afford/find it get sql 7.0 enterprise. It has a desktop version of SQL that you can install on nearly any MS OS.

Here are some basic steps that you can do to make sure that you have exactly what you need.

Install MSDE/SQL 7.0 Desktop and make sure it is working.
Script the database to a sql file.
Use that script file and create your tables on your home machine.

Good Luck

 

[dumdum]

Thanks, I do own the Enterprise edidtion and I will go that route. Again, thanks for the help. It's been way too long since I've done any dbs programming etc and it's amazing how much I'm having to retrain myself

 

[strongm]

>It has a desktop version of SQL

Which is...<fanfare>...MSDE

 

[vb5prgrmr]

>Which is...<fanfare>...MSDE

But is it not also without the 2Gb limit?

 

[strongm]

Sorry. Has that limit both in the SQL Server 7 MSDE and MSDE 2000 - and the performance hit you get with over 5 simultaneous users (what MS like to call "concurrent batch workloads")

The DE used to stand for Data Engine in SQL Server 7, but was simply redesignated when SQL 2000 was released to Desktop Engine

 

[vb5prgrmr]

Ahhh yes, I remember now.

What's the first thing to go in old age?