waht are the size limitations before the database is "unuseable over RAS?
i get error when trying to ras into an access database.
has anyone ever sucessfully accomplished this?
thanks, will
i get error when trying to ras into an access database.
has anyone ever sucessfully accomplished this?
thanks, will
1. importing data from Access 97 databases in remote sites
I am new to SQL server and I am hoping that it will allow me to import
data from Access97 databases located in 6 different places in the county.
When the project is running full blast those Access databases will be
generating 4-5 million records weekly so I will also have to be deleting
the data after I have verified that it has transferred correctly so that the
Access databases don't get too large. The Access databases are located
on NT4 computers connected to the SQL server over T1 lines running
TCP/IP. What would be the best procedure (and command) to import
the data? Is there a way to delete the data on the remote servers? And
finally, can I automate this whole process to happen weekly?
2. sp_OA OLE Automation Problem
3. MS-Access 97 to SQL Server to MS-Access 97
4. problems with set explain on
6. Accessing the modules of an Access 97 database.
8. Problem accessing Access 97 replicated database with ODBC 4.02
9. Accessing data from a Access 97 database
10. Converting Access 97 Database to Access 2
11. Convert Access 2.0 database into Access 97
12. Accessing a password protected Access 97 database using the Jet Engine