Splitting Acess Question & Sql - Still Learning

[TomP]

If I split the database and down the road purchase Sql will that affect
anything? Would it be better not to have a split dbase when you use Sql? Can
I combine the split dbase into a single file?

Thank you,

 

[Roger Carlson]

If by splitting the database, you mean putting all the forms, queries,
reports, and code in one database and put all the tables in a separate
database (linking them back into the first database), then yes. This is
very much like what you would have if you used SQL Server, all the "program"
in one file and all the tables in the SQL Server database.

If you are planning on upsizing your database to SQL Server sometime in the
future, there are some application design techniques you should investigate.
A good resource for this is "Microsoft Access Developer's Guide to SQL
Server" by Mary Chipman and Andy Baron.

Yes, you can combine a split database back into a single file, but I can
think of very few instances where that would be a good idea.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[NetworkTrade]

there is no issue for you on this...and you can easily remerge a split db by
simply re-importing the backend tables into the front end.

 

[Armen Stein]

Yes, you can combine a split database back into a single file, but I can
think of very few instances where that would be a good idea.

I agree with Roger - except that I would say "zero" instead of "very
few".

If you've already done the work to split a database, there's no reason
to merge it again. If you're concerned about relinking, there are
lots of free techniques out there, including ours:
http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp

The J Street Access Relinker can automatically and silently relink any
back-end Access database that is found in the same folder as the
front-end application.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com