The Access97 Upsizing Wizard is to be avoided, as sqlWannabee illustrates with his mention of the trigger vs. DRI (declared referential integrity) approach. And, he is steering you correctly...

I notice that you are pulling Oracle via SS2K.

Perhaps you have created a linked server which implies OLEDB [openquery()]which begs the question: which OLEDB provider are you using?...

My opinion is/was based on statements by a handful of Access MVPs.

Perhaps they were too circumspect. I shouldn't say it can't be done.

Upon reflection, it seems to...

Thanks for the correction. How embarrassing? Very.

I hope Michael doesn't see it.

'As my friends say, be careful what you ask him [me].'

I think the answer to your question is in the tea leaves.

The SS team may have improved ado...

It only captures tables (and the associated defaults, constraints, indexes, etc.) and queries. You can get set it to create the links if you include both the front end...

I think I mentioned earlier (not sure if in this thread), no you can't count on the ACCESS Upsizing Wizard or the SQL Server Import Wizard to capture everything. ...

If the query that is joining the tables is read-only (not to update either table), I think you would find that a pass-through query would allow the join on the...

I should preface this with the admission that I am biased toward using linked tables via MDBs over using ADPs.

BE AWARE: this is a religious issue among some and my...

I believe that msg is telling you that your destination database must be hosted on an instance of SQL2005. If you are trying to connect to sql express and...

Actually, you mean SQL Server 2005, not 2007, just for clarity.

The Net Start results imply you are running something more advanced than sql express. These:

SQL SERVER ANALYSIS

...

Yes. You have it: version 8.x implies one of the versions of the SQL Server 2000 engine. The actual pattern following the '8.' indicates which version and which...

OK.

I think I can reconcile this for you.

The key is the "Microsoft ... Desktop Engine". This is usually abbreviated to 'MSDE' and is the predecessor to Sql...

Yup, out-of-range dates are a principal upsize killer.

In SQL2008, this is/will be somwhat less problematical as it will provide new date (and time) datatypes that will subsume all reasonable date...

To avoid the problem of Access pulling all records and filtering on the client side, use "pass-through" queries. These do the filtering/sorting on the sql side (warp speed) and...