B
Bob Ford
I was asked to create and setup a database from ms access using sql server.
my suggestion is to use a dsn-less connection, in case another user need a
copy of the db, there is no hassle to create and setup odbc. am i right
with this analogy? will there be performance issues?
also, what is the proper way to update monthly columns values from ms access
to excel? i have a vba code that opens an instance of excel and uses
copyrecordset to output the updated values. but my concern is if multiple
users modify the monthly data from ms access, this will trigger to run the
excel update and that one excel file will lock users out from updating
spreadsheet.
pls help. thank you.
my suggestion is to use a dsn-less connection, in case another user need a
copy of the db, there is no hassle to create and setup odbc. am i right
with this analogy? will there be performance issues?
also, what is the proper way to update monthly columns values from ms access
to excel? i have a vba code that opens an instance of excel and uses
copyrecordset to output the updated values. but my concern is if multiple
users modify the monthly data from ms access, this will trigger to run the
excel update and that one excel file will lock users out from updating
spreadsheet.
pls help. thank you.