Search results for query: *

That's what I was afraid of...thanks!

Thanks for the advice. I will definitely keep it in mind as we begin implementing the software. ODBC is definitely the way to go. If a direct connection is not possible, I would still like advice on how to get data from a text file into Access when multiple table need to be updated. Thanks!

It has been purchased but not implemented. If it is ODBC compliant, what would you suggest?

Unfortuneately, I do not know if the software is ODBC compliant. It is new software that has not been implemented yet so my knowledge of it is limited at this time. I am looking to gain insight ahead of time so that when we implement it I can make sure things are set up appropriately to...

I am in the preliminary stages of trying to figure out a way to get purchase order data out of an accounting program and into an Access database. The Access database has multiple tables that contain all of the necesary information for a purchase (ex. Voucher, Item details, vendors, etc). I am...

That definitely does the trick. Thanks for your help. Steve

I am looking for a way to copy a table and give it a name containing the date the table was created. Can someone help me figure out the code necessary to do this. Here's some more background... I have a table called CurrentData which contains the most recent upload of data from our G/L...

I do not have a username and password filled in for my ODBC connection. Does it use a default user then?

I am trying to add line numbering to a report that contains 4 subreports. Is it possible to do this with Access 2000? I need the line numbering to continue sequentially from one subreport to the next.

I am having difficulties with querying data from Access 2000 using Microsoft Excel. We use security on all of our databases which I think might be part of the problem. When I go to create a query in Excel I am told that it cannot connect to the table. A few tables work fine but not all which...