Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: skfoster
  • Order by date
  1. skfoster

    Can an Access 2000 database be converted to a Access97 database?

    Yes. From Access 2000, open the mdb file you want to convert, and then -->tool, -->database utility, -->convert database...
  2. skfoster

    network performance

    40 M mdb is not too big. Check your network. Is there a switch between server and hub? With or without switch will make big difference. Does NIC set to auto or full/half duplex in both server and workstation? As my experience, auto is fast. Also, try use pass through query in your application...
  3. skfoster

    Cannot get 2k DB to compact

    This case happened many times for me. Because the size of your MDB close to 2GB, there is no space to swap. Do the following steps: 1) from my computer, copy this MDB (A) to new MDB(B) 2) delete all tables in B 3) import one bigest table from A to B 4) compact B 5) check the size of B, repeat 3)...
  4. skfoster

    like expression

    Be sure that like "*" will not retrive null data.
  5. skfoster

    copy a DB from sqlServer to another sqlServer

    If copy old version to new, the easier way is using sql native backup and resore.
  6. skfoster

    Cant reinstall Win98(non-SE, non-Upgrade CD)

    The easy is run this file c:\windows\command\scanreg/restore.exe to restore previous regestry.
  7. skfoster

    Access 2000 - CRASH

    Do you have backup? If yes, restore it. You can try scandisk disk. Sometime, try scan virus will help. But the simple way is to restore it from backup.
  8. skfoster

    Cannot add record(s), what happens???

    Tell me more detail.
  9. skfoster

    SQL 7.0 , any patch for ODBC timeout?

    You need network administrator to change the setteing of network adapter. Before it, try just append a 100 records to SQL linked table. If still get time out error, I am sure that it is network performance problem. I have the same case.
  10. skfoster

    SQL 7.0 , any patch for ODBC timeout?

    Check your network card setting. Change full/half duplex to auto in client and server.
  11. skfoster

    SQL Server tables backup

    I try use SQL 7.0 backup but can not save to another server other than x:\mssql7\backup. Did I do something wrong?
  12. skfoster

    Access 97 on W2K: No license

    This is very strange solution but work. You can find out on Microsoft web site. Find and rename a font file called Hatten.ttf to Hatten.tt_. Re-install Access97. Rename the font file back.
  13. skfoster

    Same access queries gives different results

    Pay attention on null value.
  14. skfoster

    Match the input data in table record

    Sorry, it is DAO.
  15. skfoster

    Match the input data in table record

    You can use RDO recordset to open recordset and point to table. Something like: rst!mytablefield.
  16. skfoster

    Export data from Access to Word

    Try use rich text format to export.
  17. skfoster

    Easy Question regarding SQL backup

    If you want to backup SQL while it stil running, you need SQL agent from Verita. It cost price.
  18. skfoster

    SQL Server - MS Access front-end...general opinion

    I have the same problem. Check your server and workstation network card. Change full duplex to auto.
  19. skfoster

    Outputting Access data to MS Word...ouch...I'm hurtin'

    The easy way to export Access report is using Word rich text format.
  20. skfoster

    Linked tables painfully slow!

    Did you index backend database?

Part and Inventory Search

Back
Top