Upsizing Access to SQLserver

[J Staniforth]

My problem is that many of our Access db's use linked tables. However apparently this is not catered for in SQLserver (actually using MSDE).
Does anyone know how to achieve a similar result - I think some of the tables will reside in Access db's at least initially.

Thanks in advance,
John.

[JHausmann]

Access can use linked tables with SQL Server (creating a local Jet or Access DB that has links to the SQL Server, for example, is relatively straightforward) Can you give more information on what you want to do and how you plan on doing it?

[J Staniforth]

Sorry,
your right it was ambiguous. I meant the the linked table should reside in the SQLserver db and provide a link to an Access table.
I need to do this to provide a migration path which I can persuade some of my SQLserver skeptical colleagues.
Any assistance would be most gratefully recieved (it really would ;-) ).

Thanks,
John.

[JHausmann]

I think I would:

1) upsize your existing Access table(s) to SQL Server table(s)
2) replace the old Access table(s) with linked table(s) (pointing to SQL server table(s)).

The net effect would be your programs/users would still be using Access and the table would reside on SQL server.

Once you get to SQL Server, you'll get the opportunity to experience the joys of replication...

[cgl88]

I installed
VB Studio
MSDE/SQL Developer 7

Now I can't use the DBGRid in VB without the system crashing...please tell me why! The db controls try to open the MS ACCESS database but i get an error and then i get booted out of VB. Is MSDE deliberately doing this? I have gone to so many web sites but cannot find out what is wrong. I don't want to re-install everything because it'd take forever and it may still have this problem.

Please advise. This is soo frustrating.