> > This isn't actually an SQL Server issue, but rather that the
> > Access Upsizer creates triggers, when in SQL Server all you
> > need is a declarative referential integrity rule.
>
> So that's what DRI is. It asks whether you want to use Triggers or
> DRI when upsizing. Triggers are the default, so that's what I went
> with. Should I go to DRI?
Yes, that's better than using triggers. There's more overhead in using
triggers, so you should only use them for tasks too complex for rules.
> From what I've seen, the upsizing wizard in Access 2000 does a much
> better job than it did in 97. All my indexes, data types and
> relationships seem to have been created pretty much intact. The
> problem I have with this particular app, is I'm going to be
> demonstrating it on my server with MSDE. I just don't have the profit
> margin at this point to buy SQL Server and an Internet Connector
> license. When I get to that point, I plan on purchasing a box solely
> to run SQL Server on, as per the many times I've been told that's the
> only way to go. If this thing flies, it will go a long way toward
> that goal.
It may be the case that the Access 2000 Upsizer does a better job. I haven't
looked at it.
> As far as I know, and I have never been able to get a definitive
> answer, I can't create the database on my local machine with SQL
> Server (running the desktop edition of the Evaluation) and then
> register it (is that the correct term?) with MSDE on the public
> server. If I can, I'd love to hear the steps. Otherwise, I'm going to
> have to move the Access database over then upsize there, and without
> an Enterprise Manager, I won't be able to do anything to it. If I'm
> missing something, please tell me.
You shouldn't need to use SQL Enterprise Manager to manage your MSDE
database. You should be able to use an Access 2000 Project, which will let
you do everything from Access itself.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
