uploading a table

[Guest]

If I have a big Access database on a Internet Service Porvider sever, and I
need to add another table, is it possible to upload just this table without
uploading the whole database?

 

[Scott McDaniel]

You can run a Make Table query, if you have the necessary rights. Check out
Create Table in online help.

 

[Guest]

Yes, I do. But i already designed that table in my local computer, so
building and populating it again using Make Table online seems more diffcult
then uploading the whole 15M database, unless MakeTable allows somehow to
copy the existing table - does it allow so?

 

[Özden Irmak]

Hello,

Check out Klik! CompareLib which compares and synchronizes structural
differences in MSAccess databases...

http://www.kliksoft.com/?S=2&SS=10

Regards,

Özden

 

[Scott McDaniel]

It will, assuming you can "find" the table you want to fill:

SELECT * FROM tblYourTable INTO tblYourWebTable

I'm not sure how you'll connect ... likely via an ADO connection. Check the
www.able-consulting.com ado connection faqs for proper strings, etc.

Also check online or MSDN help for full syntax of the SELECT ... INTO
statement.

 

[Kelvin]

How about keeping this new table in a database by itself. Uploading this
new file. Then in your original database create a query to link to this new
table in the new database.

Select * from NameOfTable IN "NewDatabase.mdb"

You can then just use this query as the source for the table.

Kelvin